求每个交易所的平均单价的SQL语句是

A．SELECT交易所，avg(单价)FROM stock GROUP BY单价

B．SELECT 交易所，avg(单价) FROM stock ORDER BY单价

C．SELECT 交易所，avg(单价) FROM stock ORDER BY交易所

D．SELECT 交易所，avg(单价) FROM stock GROUP BY交易所

[单选题]求每个交易所的平均单价的SQL语句是______。A．SELECT 交易所,avg(单价)FROM stock GROUP BY 单价B．SELECT 交易所,avg(单价)FROM stock ORDER BY 单价C．SELECT 交易所,avg(单价)FROM stock ORDER BY 交易所D．SELECT 交易所,avg(单价)FROM stock GROUP BY 交易所

[单选题]求每个交易所的平均单价的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交易所

[单选题]求每个交易所的平均单价的SL语句是

[单选题]求每个终点的平均票价的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 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语句是( )。A．SELECT 单位,avg(基本工资) FROM zg GROUP BY基本工资B．SELECT 单位,avg(基本工资) FROM zg ORDER BY基本工资C．SELECT 单位,avg(基本工资) FROM zg ORDER BY单位D．SELECT 单位,avg(基本工资) FROM zg 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终点