A.SELECT Cno, AVG(Scor FROM SCS GROUP BY Score ORDER BY 2, Cno DescB.SELECT Cno, AVG(Scor FROM SCS GROUP BY Cno ORDER BY 2, Cno DescC.SELECT Cno, AVG(Scor FROM SCS WHERE Cno, Desc GROUP BY ScoreD.SELECT Cno, AVG(Scor FROM SCS GROUP BY, AVG(Scor ORDER BY, Cno Desc
A.SELECT Cno, AVG(Scor FROM SCS GROUP BY Score ORDER BY 2, Cno Desc
B.SELECT Cno, AVG(Scor FROM SCS GROUP BY Cno ORDER BY 2, Cno Desc
C.SELECT Cno, AVG(Scor FROM SCS WHERE Cno, Desc GROUP BY Score
D.SELECT Cno, AVG(Scor FROM SCS GROUP BY, AVG(Scor ORDER BY, Cno Desc