首页 > 试题广场 >

在一个项目任务表 tasks 中，有字段 project_i

[单选题]

在一个项目任务表 tasks 中，有字段 project_id 和 status。要统计每个项目的待完成（status = 'pending'）任务数量，哪个 GROUP BY 查询正确？

SELECT project_id, COUNT(*) FROM tasks WHERE status = 'pending' GROUP BY project_id

SELECT project_id, COUNT(*) FROM tasks GROUP BY project_id HAVING status = 'pending'

SELECT project_id, SUM(*) FROM tasks WHERE status = 'pending' GROUP BY project_id

SELECT project_id, COUNT(*) FROM tasks GROUP BY project_id WHERE status = 'pending'

查看正确选项

Stacey_xue

Having字句过滤的是分组后的结果，where分组前筛选出符合的数据，再进行分组

发表于今天 06:44:02 回复(0)

提交观点

问题信息

SQL

难度：

1条回答 1收藏 22浏览

扫一扫，把题目装进口袋