数据库分组查询

SELECT Cname ,Grade
FROM SC,Courses
WHERE SC.Cno=Courses.Cno  AND Sno=’2011247’;
SELECT  Students.Sno,Grade
FROM SC,Students
WHERE  Students.Sno=SC.Sno AND  Cno=’CS202’AND Grade>90;
SELECT  Students.Sno,Sname,Grade
FROM Students ,SC,Courses
WHERE Students.Sno=SC.Sno  AND  SC.Cno=Courses.Cno;
SELECT Students.Sno,Sname,AVG(Grade)
FROM Students,SC
WHERE  Students.Sno=SC.Sno 
GROUP BY Students.Sno,Sname
HAVING AVG>85;
SELECT S2.Sname
FROM Students S1,Students S2
WHERE S1.Birthday=S2.Birthday  AND S1.Sname=’王丽丽’ AND S2.Sname<>’王丽丽’;