【正确答案】 方法1：
SELECT Sno,Sname,Sage (１分)
FROM S (１分)
WHERE Sage BETWEEN 18 AND 22 (0.5分)
AND Ssex=‘男’ (0.5分)
方法2：
SELECT Sno,Sname,Sage (１分)
FROM S (１分)
WHERE Sage>= 18 AND Sage <=22 (0.5分)
AND Ssex=‘男’ (0.5分)
【答案解析】
问答题
检索选修了“王杰”老师所授课程的学生的学号和姓名；
【正确答案】方法1：
SELECT Sno,Sname (１分)
FROM S,SC,C (0.5分)
WHERE S.Sno=SC.Sno (0.5分)
AND SC.Cno=C.Cno (0.5分)
AND C.Cteacher=‘王杰’ (0.5分)
方法2：
SELECT Sno,Sname (１分)
FROM S
WHERE Sno IN (0.5分)
(SELECT Sno
FROM SC (0.5分)
WHERE Cno IN
(SELECT Cno
FROM C (0.5分)
WHERE Cteacher =‘王杰’)) (0.5分)
【正确答案】SELECT Sno，Sname , AVG (Grade) ，SUM (Grade) (1分)
FROM S,SC (１分)
WHERE S. Sno=SC .Sno (0.5分)
GROUP BY S.Sno (0.5分)
评分标准：AVG (Grade)，SUM (Grade)有错误，第１句仅给0.5分，WHERE 和GROUP BY语句顺序有错误，最后两句仅给0.5分。
【答案解析】
问答题
从学生表中删除选修成绩出现过0分的所有学生信息。
【正确答案】DELETE FROM S (１分)
WHERE Sno IN (１分)
(SELECT Sno
FROM SC
WHERE Grade=0) (１分)