select s.sname as 姓名,sc.grade as 分数
from s,sc
where s.sno=sc.sno --内链接
and s.sno in
(
select distinct(sc.cno)
from sc
where sc.cno in ( select s.no --所学的课程中一定要有程军老师教的课程
from s
where s.teacher='程军'
)
group by sc.sno
having count(sc.cno)>=(select count ( distinct s.no)--课程数大于等于程军老师所教课程数
from s
where s.teacher='程军‘
)
)
如果还有问题,请追问。
望采纳!
追问![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a1ec08fa513d26970982dcb854fbb2fb4216d886?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追答我就直接打的,没用管理器。可能是有点问题吧,能帮助到你,我很开心。谢谢采纳!