[单选题]

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

[单选题]求每个终点的平均票价的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语句是

    [单选题]求每个终点的平均票价的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

    [单选题]求每个终点的平均票价的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

    [单选题]求每个终点的平均票价的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语句是()。

    [单选题]求每个单位的平均基本工资的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语句是

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

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

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

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

  • 查看答案
  • 写出求某字段最大值的SQL语句.

    [主观题]写出求某字段最大值的SQL语句.

  • 查看答案
  • 求每个终点的平均票价的SQL语句是: