求每个终点的平均票价的SQL语句是A.SELECT终点,avg(票价)FROM ti
题型:单项选择题
问题:
求每个终点的平均票价的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终点