);?
43>查询没学过“叶平”老师讲授的任何一门课程的学生姓名
SELECT Sname FROM Student
WHERE S# NOT IN(
SELECT S# FROM Course,Teacher,SC WHERE Course.T#=Teacher.T# AND Tname='叶平' AND SC.C#=Course.C#?
44>查询两门以上不及格课程的同学的学号及其平均成绩
SELECT S#,AVG(isnull(score,0)) FROM SC WHERE S# IN(
SELECT S# FROM SC WHERE score<60 GROUP BY S# HAVING COUNT(*)>2
)
GROUP BY S#;?
45>检索“004”课程分数小于60，按分数降序排列的同学号
SELECT S# FROM SC WHERE C#=‘004’ AND score <60
ORDER BY S# DESC;
46>删除“002”同学的“001”课程的成绩
DELETE FROM SC WHERE S#=‘002’ AND C#=‘001’;