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<>’王丽丽’;
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<>’王丽丽’;