求每个终点的平均票价的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 终点

在表ticket中查询所有票价小于100元的车次、始发站和终点信息的命令是

A:SELECT*FROM ticket WHERE票价＜100 B:SELECT车次、始发站、终点FROM ticket WHERE票价＞100 C:SELECT车次、始发站、终点FROM ticket WHERE票价＜100 D:SELECT*FROM ticket WHERE票价＞100

求每个终点的平均票价的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 终点

在表ticket中查询所有票价小于100元的车次、始发站和终点信息的命令是

A:SELECT*FROM ticket WHERE票价＜100 B:SELECT车次、始发站、终点FROM ticket WHERE票价＞100 C:SELECT车次、始发站、终点FROM ticket WHERE票价＜100 D:SELECT*FROM ticket WHERE票价＞100

求每个终点的平均票价的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 终点