php - 如何通过单个查询获得两个单独的结果

Question

我的目标是获得每个人的积分总和并返回用户名和他/她的总积分。

id      |   username  |   points

1           Michelle       23
2           Chester        44
3           Michelle       13
4           Chester        23
5           Chester        65
6           Chester        43
7           Michelle       65
8           Chester        12
9           Michelle       54
10          Chester        76

想要的结果

username   |  total_points

Chester    |  total points of Chester
Michelle   |  total points of Michelle

Answer 1

怎么样:

SELECT      username, SUM(points) total_points
FROM        mytable
GROUP BY    username
ORDER BY    username