SELECT Cno, AVG (Score. FROM SCS GROUP BY Score ORDER BY 2 ,Cno DESC SELECT Cno, AVG (Score. FROM SCS GROUP BY Cno ORDER BY 2 ,Cno DESC SELECT Cno, AVG (Score. FROM SCS WHERE Cno, DESC GROUP BY Score SELECT Cno, AVG (Score. FROM SCS
SELECT Cno,AVG(Score)FROM SCS GROUP BY Score ORDER BY 2.Cno DESC SELECT Cno,AVG(Score) FROM SCS GROUP BY Cno ORDER BY 2.Cno DESC SELECT Cno,AVG(Score) FROM SCS ORDER BY Cno DESC ORDER BY Score SELECT Cno,AVG(Score) FROM SCS GROUP BY AVG(Score) ORDER BY Cno DESC