正确答案：【1】
select sno,sname
from student
where sno in 【
select sno
from sc
where cno = 【
select cno
from course
where cname= 计算机原理
】
】
【2】
select cname
from course
where cno in 【
select cno
from sc
where sno =
【
select sno
from student
where sname= 周星驰
】
】
【3】
select sno,sname
From student
Where sno in 【
select sno
from scgroup by sno having count【sno】=5
】 答案解析：暂无解析
发表于