求至少有两个职工的每个仓库的平均工资
A.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表;
HAVING COUNT(*)>=2
B.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表;
GROUP BY仓库号HAVING COUNT(*)>=2
C.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表;
GROUP BY仓库号SET COUNT(*)>=2
D.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表;
GROUP BY仓库号WHERE COUNT(*)>=2