如果结果不匹配，请 
更多“AVG材质以()最多见。”相关的问题
检索最少有4名职工仓库的职工平均工资的语句为()。
A．SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 仓库号 WHERE COUNT(*)＞=4
B．SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 仓库号 HAVING COUNT(*)＞=4
C．SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 职工号 WHERE COUNT(*)＞=4
D．SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 职工号 HAVING COUNT(*)＞=4
检索最少有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
A.SELECT所在系，AVG(工资)FROM教师表 WHERE AVG(工资)＞(SELECT AVG(工资)FEOM教师表)
B.SELECT所在系，AVG(工资)FROM教师表 WHERE AVG(工资)＞(SELECT AVG(工资)FEOM教师表) GROUP BY所在系
C.SELECT所在系，AVG(工资)FROM教师表 GROUP BY所在系 HAVING AVG(工资)＞(SELECT AVG(工资)FEOM教师表)
D.SELECT所在系，AVG(工资)FROM教师表 GROUP BY所在系 WHERE AVG(工资)＞(SELECT AVG(工资)FEOM教师表)
