mysql - 查询中的分组依据和排序依据

Question

我正在努力计算几项赛事的总奖金。我想按总奖金对结果进行排序，但这似乎不起作用。我只能按事件分组，或按总金额排序(这只是给出总金额列)。

这是查询和表格:

SELECT event_id, SUM(money) as 'total money' 
FROM prize 
GROUP by event_id  
ORDER by 'total money' desc;

谢谢

Answer 1

正如@juergen d所说，这会对你有所帮助。

SELECT event_id, SUM(money) as `total money`
FROM prize 
GROUP by event_id  
ORDER by `total money` desc;