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

检索最少有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


相关考题:

检索至少有一名职工信息的“仓库号”及仓库的“所在地”和“人数”,正确的SQL命令是( )。A.SELECT 仓库号,所在地,人数 FROM 仓库 WHERE IN; (SELECT 仓库号 FROM 职工 WHERE 仓库号=职工.仓库号)B.SELECT 仓库号,所在地,人数 FROM 仓库 WHERE 仓库号 IN; SELECT 仓库号 FROM 职工 WHERE 仓库号=仓库.仓库号)C.SELECT 仓库号,所在地,人数 FROM 仓库 WHERE NOT EXISTS; (SELECT 仓库号 FROM 职工 WHERE 仓库号=仓库.仓库号)D.SELECT 仓库号,所在地,人数 FROM 仓库 WHERE EXISTS; (SELECT 仓库号 FROM 职工 WHERE 仓库号=仓库.仓库号)

求至少有两个职工的每个仓库的平均工资A.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表; HAVING COUNT(*)=2B.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表; GROUP BY 仓库号 HAVING COUNT(*)=2C.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表; GROUP BY 仓库号 SET COUNT(*)=2D.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表; GROUP BY 仓库号 WHERE COUNT(*)=2

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

第下列各题使用下列数据表。 “仓库”表 仓库号所在地WH2北京WH2上海WH3广州WH4天津“职工”表职工号仓库号工资E1WHl2100E2WH21 500E3WH31350E4WHl1850E5WH31900E6WHl2000E7WH41450E8WH21200E9WHl1600求至少有4个职工的每个仓库的工资总和( )。A.SELECT仓库号,COUNT(*),SUM(工资)FROM 职工 WHERE COUNT(*)=4B.SELECT仓库号,COUNT(*),SUM(工资)FROM 职工 GROUP BY仓库号SET COUNT(*)=4C.SELECT仓库号,COUNT(*).SUM(工资)FROM 职工 GROUP BY仓库号HAVING COUNT(*)=4D.SELECT仓库号,COUNT(*),SUM(工资)FROM 职工 GROUP BY仓库号WHERE cOUNT(*)=4

求至少有两个职工的每个仓库的平均工资______。A.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表; HAVINGCOUNT(*)>=2B.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表; GROUPBY仓库号HAVING COUNT(*)>=2C.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表; GROUPBY仓库号SET COUNT(*)>=2D.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表; GROUPBY仓库号WHERE COUNT(*)>=2

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

求至少有两个职工的每个仓库的平均工资A.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;HAVING COUNT(*)=2B.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;GROUP BY 仓库号 HAVING COUNT(*)=2C.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;GROUP BY 仓库号 SET COUNT(*)=2D.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;GROUP BY 仓库号 WHERE COUNT(*)=2

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

假设有职工表(职工号,仓库号,工资),将下面的SQL语句补充完整,求至少有两个职工的每个仓库的平均工资。SELECT仓库号,COUNT(﹡),AVG(工资)FROM职工;GROUP BY仓库号__________COUNT(﹡)=2