php - 两次求和并分组

Question

我有这样的表:

| ID | Team   | User    | Try1 | Try2 |  Try3 |
| 1  | Black  | Chris   |  2   |  6   |  4    |
| 2  | Black  | Brian   |  10  |  8   |  10   |
| 3  | Red    | Mark    |  6   |  2   |  8    |
| 4  | Red    | Andrew  |  4   |  10  |  6    |

我需要将团队尝试分数一起计算以获得总数。

SELECT *, SUM(Try1 + Try2 + Try3) AS total FROM team_pts GROUP BY team ORDER BY total DESC

问题是 - 我如何输出每个团队每次尝试的总成绩？像这样的事情:

| Pos | Team  | Try1 | Try2 | Try3 | Total |
|  1  | Black |  12  |  14  |  14  |  40   |
|  2  | Red   |  10  |  12  |  14  |  36   |

对不起我的英语!

Answer 1

您需要在总计之前对列进行求和:

SELECT *,
       SUM(Try1),
       SUM(Try2),
       SUM(Try3),
       SUM(Try1 + Try2 + Try3) AS total
FROM team_pts
GROUP BY team
ORDER BY total DESC