mysql - 带条件的 SUM 行的 SQL 语句

Question

我有user_id = 23 我想查询，我还有一个表work_log包括project_id, user_id, log_hours 像这样:

+----+------------+---------+-----------+
| id | project_id | user_id | log_hours |
+----+------------+---------+-----------+
| 1  |    23      |   23    |   2.5     |
| 1  |    3       |   23    |   3       |
| 1  |    23      |   23    |   1       |
| 1  |    24      |   23    |   3       |
| 1  |    24      |   23    |   1.5     |
| 1  |    23      |   23    |   0.5     |
+----+------------+---------+-----------+

但现在我想对每个结果的所有 log_hours 求和:

+------------+------------------+
| project_id | sum_of_log_hours |
+------------+------------------+
|     23     |       4          |
|     3      |       3          |
|     24     |       4.5        |
+------------+------------------+

如何编写 SQL 语句来获得该结果？

Answer 1

应该这样做:

Select project_id, sum(log_hours) as sum_log_hours
from work_log
where user_id = '23'
group by project_id