MySQL 查询问题

Question

我有当前的数据库设置:

Forename | Surname | Department | Completion_Status
Tom        Smith     Sales        Started
Bob        Jones     Sales        Completed
Alison     Baines    Sales        Not Started
Arthur     Smith     Marketing    Started
Claire     Staines   Marketing    Completed

我能够毫无问题地返回总行数，以及完成状态为“已开始”或“已完成”的总行数，但不能在单个语句中返回 - 但是我想要在单个语句中执行的是:

COUNT for Department As Total AND the COUNT for Department As Responses WHERE Completion_Status IN ('Started', 'Completed')

它看起来像这样:

Department | Total | Responses
Sales        3       2
Marketing    2       2

希望这是有道理的!？

谢谢荷马。

Answer 1

选择部门，
       COUNT(部门)              AS 总计，
       COUNT(completion_status) AS 回复
来自结果
WHERE completion_status IN ('开始', '完成')
按部门分组
按部门订购