求至少有4个职工的每个仓库的工资总和( )。
A.SELECT仓库号,COUNT(*),SUM(工资)FROM职工;
WHERE COUNT(*)>=4
B.SELECT仓库号,COUNT(*),SUM(工资)FROM职工;
GROUP BY仓库号SET COUNT(*)>=4
C.SELECT仓库号,COUNT(*),SUM(工资)FROM职工;
GROUP BY仓库号HAVING COUNT(*)>=4
D.SELECT仓库号,COUNT(*),SUM(工资)FROM职工;
GROUP BY仓库号WHERE COUNT(*)>=4