mysql - 使用 MySQL 选择排行榜

Question

好的，我有一个包含以下字段的表:

correct_id, player_id, 奖励

我想创建一个列表，按降序排列谁的答案最正确、他们答对了多少问题以及他们获得的总奖励是多少。我该怎么做？

SELECT player_id, sum(correct_id), sum(reward) FROM questions_correct GROUP BY count(correct_id)

Answer 1

试试这个:

SELECT player_id, COUNT(correct_id) CorrectAnsCnt, SUM(correct_id), SUM(reward) 
FROM questions_correct 
GROUP BY player_id
ORDER BY CorrectAnsCnt DESC