题目内容:
检索最少有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
参考答案:
答案解析: