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