检索全部课程的学生姓名

1、 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='程军‘))如果还有问题，请追问。