对于图书管理数据库,求电子工业出版社出版图书的最高单价、最低单价和平均单价,下面SQL语句正确的是______。 SELECT______FROM 图书; WHERE 出版单位=“电子工业出版社”
A.MAX(单价),MIN(单价),AVG(单价)
B.MAX(单价),MIN(单价),AVERAGE(单价)
C.MAX(单价),MIX(单价),AVG(单价)
D.MAX(单价),SUM(单价),AVG(单价)
A.MAX(单价),MIN(单价),AVG(单价)
B.MAX(单价),MIN(单价),AVERAGE(单价)
C.MAX(单价),MIX(单价),AVG(单价)
D.MAX(单价),SUM(单价),AVG(单价)
第1题
A.MAX(单价),MIN(单价),AVG(单价)
B.MAX(单价),MIN(单价),AVERAGE(单价)
C.MAX(单价),MIX(单价),AVG(单价)
D.MAX(单价),SUM(单价),AVG(单价)
第2题
A.MAX(单价),MIN(单价),AVG(单价)
B.MAX(单价),MIN(单价),AVERAGE(单价)
C.MAX(单价),MIX(单价),AVG(单价)
D.MAX(单价),SUM(单价),AVG(单价)
第3题
SELECT FROM 图书;
WHERE 出版单位="人民邮电出版社"
设有图书管理数据库中包含以下表:
图书(总编号C(6),分类号C(8),书名C(16),作者C(6),出版单位C(20),单价N(6,2))
A.MAX(单价),MIN(单价),AVG(单价)
B.MAX(单价),MIN(单价),AVERAGE(单价)
C.MAX(单价),MIX(单价),SUM(单价)
D.MAX(单价),SUM(单价),AVG(单价)
第4题
A.GROUP BY 单价 DESC
B.ORDER BY 单价 DESC
C.ORDER BY 单价 ASC
D.GROUP 单价 ASC
第5题
A.GROUP BY单价DESC
B.ORDER BY单价DESC
C.ORDER BY单价ASC
D.GROUP单价ASC
第7题
A.MIN(单价)AVGAGE(单价)COUNT(*)GROUP BY
B.MAX(单价)AVG(单价)COUNT(*)ORDER BY
C.MAX(单价)AVG(单价)SUM(*)ORDER BY
D.MAX(单价)AVG(单价)COUNT(*)GROUP BY
第8题
A.MIN(单价) AVGAGE(单价) COUNT(*) GROUPBY
B.MAX(单价) AVG(单价) COUNT(*) ORDERBY
C.MAX(单价) AVG(单价) SUM(*) ORDERBY
D.MAX(单价) AVG(单价) COUNT(*) GROUPBY
第9题
A.MIN(单价) AVGAGE(单价) COUNT(*) GROUP BY
B.MAX(单价) AVG(单价) COUNT(*) ORDER BY
C.MAX(单价) AVG(单价) SUM(*) ORDER BY
D.MAX(单价) AVG(单价) COUNT(*) GROUP BY
第10题
A.SELECT出版社,MIN(单价),AVERAGE(单价),COUNT(*)FROM 图书 GROUP BY 出版社
B.SELECT出版社,MAX(单价),AVG(单价),COUNT(*)FROM 图书 ORDER BY 出版社
C.SELECT出版社,MIN(单价),AVERAGE(单价),SUM(*)FROM 图书 GROUPBY 出版社
D.SELECT出版社,MAX(单价),AVG(单价),COUNT(*)FROM 图书 GROUP BY 出版社
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!