php - SQL:计算每条记录的列值

Question

我一直坚持创建查询。

我得到了一个具有这种结构的表“视频”:

id | artist | song | hits

记录是这样的:

1 | Rihanna | Song1 | 400
2 | Rihanna | Song2 | 100
3 | Prince | Song45 | 300
4 | The Police | Song456 | 1000

这是我的非工作查询:

SELECT DISTINCT artist, SUM(hits)
FROM videos
ORDER BY hits DESC

结果是:

Rihanna | 1800

但我想要这样的结果:

Rihanna | 500
Prince | 300
The Police | 1000

我在这里做错了什么？

Answer 1

SELECT artist, SUM(hits) as hitscount
FROM videos
GROUP BY artist
ORDER BY hitscount DESC

添加了评论中的建议。谢谢!