![](https://cos-cdn.shuashuati.com/pipixue-web/2020-1231-2005-12/ti_inject-812ce.png)
检索最4名职工的仓库的职工平均工资( )。 A)SELECT仓库号,COUNT(﹡)AS人数,AVG(工资)AS平均工资FROM职工; GROUP BY仓库号WHERE COUNT(﹡)>=4 B)SELECT仓库号,COUNT(﹡)AS人数,AVG(1资)AS平均工资FROM职工; GROUP BY仓库号HAVING COUNT(﹡)>=4 C)SELECT仓库号,COUNT(木)AS人数,AVG(工资)AS平均工资FROM职工; GROUP BY职工号WHERE COUNT(﹡)>=4 D)SELECT仓库号,COUNT(﹡)AS人数,AVG(工资)AS平均工资FROM职工; GROUP BY职工号HAVING COUNT(﹡)>=4