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