SQL_学生-课程数据库(下)

 

第二部分

1.所有男生的姓名、年龄:

Select Sname，Sage

From student;

2.所有年龄大于20，计算机科学系学生名单:

SELECT Sname

FROM Student

WHERE Sage>20 AND Sdept='CS';

3.成绩大于60的学生学号:

SELECT Sno

FROM SC

WHERE Grade>60;

4.成绩在70到80之间的学生学号:

SELECT Sno

FROM SC

WHERE Grade>70 AND Grade<80;

SELECT Sno 学号

FROM SC

WHERE Grade BETWEEN 70 AND 80;

5.1985到1989年出生的学生姓名:

SELECT Sname 姓名

FROM Student

WHERE 2009-Sage BETWEEN 1985 AND 1989;

SELECT Sname

FROM Student

WHERE 2009-Sage>1985 AND 2009-Sage<1989;

6.查询成绩不在70到85的及格学生名单:

SELECT DISTINCT Sname

FROM Student,SC

WHERE Student.Sno=SC.Sno AND Grade NOT BETWEEN 70 AND 80 AND Grade>60;

7.查询成绩是70、80、90的学生学号:

SELECT Sno