I am currently running this query:
SELECT *, COUNT(name) AS ActionCount
FROM plays
GROUP BY name
ORDER BY ActionCount DESC LIMIT 0, 50
To select the most prominent/common names in a game of mine, how would I also get the total sum of the mileage every player drove through without running a query for every one of the 50 users selected above assuming I have a 'mileage' field in every game.