检索最少有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