[单选题]求每个终点的平均票价的SQL语句是A)SELECT终点,avg(票价)FROM ticket GROUP BY票价B)SELECT终点,avg(票价)FROM ticket ORDER BY票价C)SELECT终点,avg(票价)FROM ticket ORDER BY终点D)SELECT终点,avg(票价)FROM ticket GROUP BY终点
[单选题]求每个终点的平均票价的SQL语句是A.SELECT终点,avg(票价)FROM ticket GROUP BY票价B.SELECT终点,avg(票价)FROM ticket ORDER BY票价C.SELECT终点,avg(票价)FROM ticket ORDER BY终点D.SELECT终点,avg(票价)FROM ticket GROUP BY终点
[单选题]求每个终点的平均票价的SQL语句是A.SELECT终点,avg (票价) FROM ticket GROUP BY 票价B.SELECT终点,avg (票价) FROM ticket ORDER BY 票价C.SELECT终点,avg (票价) FROM ticket ORDER BY 终点D.SELECT终点,avg (票价) FROM ticket GROUP BY 终点
[单选题]求每个终点的平均票价的SQL语句是:A.SELECT终点,avg (票价) FROM ticket GROUP BY 票价B.SELECT终点,avg (票价) FROM ticket ORDER BY 票价C.SELECT终点,avg (票价) FROM ticket ORDER BY 终点D.SELECT终点,avg (票价) FROM ticket GROUP BY 终点
[单选题]有如下SQL语句: SELECT账号,avg(账户金额)as平均金额FROM kh; GROUP BY职业INTO DBF temp 执行该语句后temp表中第2条记录的“平均金额”字段的内容是( )。A.40000B.50000C.60000D.70000
[单选题]求每个交易所的平均单价的SQL语句是A.)SELECT交易所,avg(单价)FROM stock GRDER BY单价B.)SELECT交易所,avg(单价)FROM stock ORDER BY单价C.)SELECT交易所,avg(单价)FROM stock ORDER BY交易所D.)SELECT交易所,avg(单价)FROM stock GROUP BY交易所
[单选题]有如下SQL语句SELECT 股票代码,avg(单价)as 均价 FROM stock;GROUP BY 交易所 INTO DBF temp执行该语句后,temp表中第二条记录的“均价”字段用SQL语句A)7.48 B)9.99 C)11.73 D)15.20
[单选题]有如下SQL语句 SELECT交易所,avg(单价)as均价FROM stock; GROUP BY交易所INTO DBT temp 执行该语句后temp表中第2条记录的“均价”字段的内容是_______。
[单选题]有如下SQL语句 SELECT交易所,avg(单价)as均价FROM stock; GROUP BY 交易所 INTO DBF temp 执行该语句后temp表中第2条记录的“均价”字段的内容是______。A.7.48B.9.99C.11.73D.15.20
[单选题]有如下SQL语句 SELECT 股票代码,avg(单价) as 均价FROM stock; GROUP BY交易所INTO DBF temp 执行该语句后,temp表中第二条记录的“均价”字段的内容是A.7.48B.9.99C.11.73D.15.20