1. SELECT * FROM 课程 2. SELECT ST.学号,
ST.姓名,
SC.成绩 FROM 学生 AS ST JOIN 成绩 AS SC ON ST.学号 = SC.学号 JOIN 课程 AS CO ON SC.课程号 = CO.课程号 WHERE CO.授课教师 = '刘老师'3. SELECT CO.课程名,
ST.COUNT(*) FROM 学生 AS ST JOIN 成绩 AS SC ON ST.学号 = SC.学号 JOIN 课程 AS CO ON SC.课程号 = CO.课程号 GROUP BY CO.课程名4. ...