【简答题】A.Select C#,AVG(Score)From学生成绩表 Group by score Order by 2,C# Desc B.Select C#,AVG(Score)From学生成绩表 Group by C# Order by 2,C# Desc C.Select C#,AVG(Score)From学生成绩表 Vyhere C# Desc Group by Score D.Select ...
【简答题】A.SELECT Cno, AVG(Score) FROM SCS GROUP BY Score ORDER BY 2 ,Cno DESC B.SELECT Cno, AVG(Score)FROM SCS GROUP BY Cno ORDER BY 2 ,Cno DESC C.SELECT Cno, AVG(Score) FROM SCS WHERE Cno, DESC GROUP BY Scor...
【简答题】求每个终点的平均票价的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终点
【简答题】A.SELECT Cno, AVG(Score) FROM SCS GROUP BY Score ORDER BY 2, Cno Desc B.SELECT Cno, AVG(Score) FROM SCS GROUP BY Cno ORDER BY 2, Cno Desc C.SELECT Cno, AVG(Score) FROM SCS WHERE Cno, Desc GROUP BY Sco...