Code:
SELECT u.username, g.points
FROM users u, (
SELECT games.user_id, max(games.points) as points
FROM games
GROUP BY user_id) g
WHERE u.id = g.user_id
order by points DESC
SELECT u.username, g.points
FROM users u, (
SELECT games.user_id, max(games.points) as points
FROM games
GROUP BY user_id) g
WHERE u.id = g.user_id
order by points DESC
problem se desava kad treba da dodam games.created_at, onda moram da ga uvrstim u group by tako da mi onda vrati sve redove iz tabele games umesto samo usere sa maksimalnim poenima. Kako da selektujem i created_at iz games tabele a da "ne poremetim" trenutni select? Hvala unapred