求每个终点的平均票价的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终点
在表ticket中查询所有票价小于100元的车次、始发站和终点信息的命令是A）SELECT *FROM ticket WHERE票价＜100B）SELECT车次、始发站、终点FROM ticket WHERE票价100C）SELECT车次、始发站、终点FROM ticket WHERE票价100D）SELECT*FROM ticket WHERE票价＞100
有如下SQL语句： CREATE VIEW view ticket AS SELECT始发点AS名称，票价FROM ticket执行该语句后产生的视图含有字段名是A．始发点、票价B．名称、票价C．名称、票价、终点D．始发点、票价、终点
在表ticket中查询所有票价小于100元的车次、始发站和终点信息的命令是A．SELECT*FROM ticket WHERE票价＜100B．SELECT车次、始发站、终点FROM ticket WHERE票价＞100C．SELECT车次、始发站、终点FROM ticket WHERE票价＜100D．SELECT*FROM ticket WHERE票价＞100
有如下SQL语句： CREATE VIEW view ticket AS SELECT 始发点AS名称，票价FROM ticket 执行该语句后产生的视图含有的字段名是A．始发点、票价B．名称、票价C．名称、票价、终点D．始发点、票价、终点
求每个终点的平均票价的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 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语句：CREATE VIEW view ticket AS SELECT 始发点 AS 名称，票价 FROM ticket执行该语句后产生的视图含有的字段名是A)始发点、票价 B)名称、票价C)名称、票价、终点 D)始发点、票价、终点
求每个终点的平均票价的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终点