| id | name | price | | ---- | ---- | ---- | | 1 | 程超 | 19 | | 2 | 江炜 | 20 | | 3 | 程程 | 66 | | 4 | 云舒 | 50 | | 5 | 程超 | 44 | | 6 | 云舒 | 88 | | 7 | 江炜 | 3000 | | 8 | 程程 | 5000 | ~~~ //获取每一个人的消费总额 SELECT name,SUM(price) GROUP BY name; ~~~ ~~~ //获取每一个r人的消费总额,按消费总额降序排列 SELECT name,SUM(price) FROM sales_table GROUP BY name ORDER BY SUM(price) DESC; ~~~