SELECT Cno, AVG(Scor FROM SCS GROUP BY Score ORDER BY 2, Cno Desc SELECT Cno, AVG(Scor FROM SCS GROUP BY Cno ORDER BY 2, Cno Desc SELECT Cno, AVG(Scor FROM SCS WHERE Cno, Desc GROUP BY Score SELECT Cno, AVG(Scor FROM SCS GROUP BY, AVG(Scor ORDER BY, Cno Desc