检索最少有3名职工仓库的职工的平均工资
A.SELECT仓库号,COUNT( * )AS人数,AVG(工资)AS平均工资FROM职工;
GROUP BY仓库号WHERE COUNT( * )>=3
B.SELECT仓库号,COUNT( * )AS人数,AVG(工资)AS平均工资FROM职工;
GROUP BY仓库号HAVING COUNT( * )>=3
C.SELECT仓库号,COUNT( * )AS人数,COUNT(工资)AS平均工资FROM职工;
GROUP BY仓库号WHERE COUNT( * )>=3
D.SELECT仓库号,COUNT( * )AS人数,COUNT(工资)AS平均工资FROM职工;
GROUP BY仓库号HAVING COUNT( * )>=3