【简答题】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...
【简答题】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...