mysql - 取决于 id 的行值总和

Question

我正在尝试根据来自同一张表的 cid 获取新表中成人和 child 的总和。

餐 table 销售

+-----------+------------+---------------+
| cid       | adult      |  child        |
+-----------+------------+---------------+
|         1 |     20     |      20       | 
|         1 |     30     |      10       |
|         1 |    100     |      35       |
|         1 |     10     |      25       |
|         2 |     40     |      10       |
|         2 |     20     |      70       |
|         2 |     30     |      60       | 
+-----------+------------+---------------+

期望的输出:

+-----------+------------+---------------+
| cid       | adult      |  child        |
+-----------+------------+---------------+
|         1 |     160    |       90      | 
|         2 |      90    |      140      |
+-----------+------------+---------------+

请帮帮我

Answer 1

SELECT cid, SUM(adult) AS adult, SUM(child) AS child 
FROM sales 
GROUP BY cid