1)在表STUDENTS中,查询学号SID为“850955252”所在年级的所有学生记录,写出SQL语句并粘贴执行输出结果的截图:
SELECT *
FROM STUDENTS
WHERE grade IN
(
select grade
from STUDENTS
where sid = ‘850955252’
)
2)在表STUDENTS中,查询有选修课程的学生记录,写出SQL语句并粘贴执行输出结果的截图:
SELECT *
from STUDENTS,CHOICES,COURSES
where STUDENTS.sid = CHOICES.sid AND
CHOICES.cid=COURSES.cid
3)在表STUDENTS中,查询有选修课程的学生记录,写出SQL语句并粘贴执行输出结果的截图:
SELECT *
from STUDENTS,CHOICES,COURSES
where STUDENTS.sid = CHOICES.sid AND
CHOICES.cid=COURSES.cid
4)查询表COURSES中没有学生选修的课程名称,写出SQL语句并粘贴执行输出结果的截图:
SELECT cname
FROM COURSES
WHERE cid NOT IN
(
select cid
from CHOICES
)
5)查询选修了课程为“c++”的所有学生的学号和姓名,写出SQL语句并粘贴执行输出结果的截图:
SELECT STUDENTS.sid,STUDENTS.sname
FROM STUDENTS
WHERE sid IN
(
select CHOICES.sid
from CHOICES
where CHOICES.cid IN
(
select cid
from COURSES
where cname=‘c++’
)
)
6)在表COURSES中查询和课程“uml”或“c++”课时数相同的课程名称,写出SQL语句并粘贴执行输出结果的截图:
SELECT COURSES.cname
FROM COURSES
WHERE hour IN
(
select hour
from COURSES
where COURSES.cname = 'c++'or COURSES.cname = ‘uml’
)
7)查询选修了课程号为“10001”的所有学生姓名,写出SQL语句并粘贴执行输出结果的截图:
SELECT sname
FROM STUDENTS
WHERE sid IN
(
select sid
from CHOICES
where CHOICES.cid=‘10001’
)
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200508175712715.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3p6bDg4ODg4ODg=,size_16,color_FFFFFF,t_70)