第26题: [单项选择]求每个终点的平均票价的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 终点 参考答案:D 答案解析:[解析] 根据题目的要求,求每个终点的平均票价,则按不同的终点分组查询,用AVG()函数计算每组的平均票价值,故正确的 SQL语句应该是: SELECT终点,avg (票价) FROM ti