A:SELECT Sno,MAX(Grade) FROM SC WHERE MAX(Grade)≥91 GROUP BY Sno B:SELECT Sno,MAX(Grade) FROM SC GROUP BY Sno HAVING MAX(Grade)≥91 C:SELECT Sno,MAX(Grade) FROM SC WHERE MAX(Grade)≥91 ORDER BY Sno D:SELECT Sno,MAX(Grade) FROM SC GROUP BY Cno HAVING MAX(Grade)≥91
A:SELECT Sno,MAX(Grade) FROM SC WHERE MAX(Grade)>=91 GROUP BY Sno B:SELECT Sno,MAX(Grade) FROM SC GROUP RY Sno HAVING MAX(Grade)>=91 C:SELECT Sno,MAX(Grade) FROM SC WHERE MAX(Grade)>=91 ORDER BY Sno D:SELECT Sno,MAX(Grade) FROM SC GROUP BY Cno HAVING MAX(Grade)>=91