单项选择题

检索最少有3名职工的每个部门的职工工资总额
A) SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
HAVING COUNT(*)>=3
B) SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
GROUP BY 部门号 HAVING COUNT(*)>=3
C) SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
GROUP BY 部门号 SET COUNT(*)>=3
D) SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
GROUP BY 部门号 WHERE COUNT(*)>=3