sql server查询选修课程多于2门的学生的信息以及他们所选修的课程信息

Question

查询问题，选修课程多于2门的学生的信息以及他们所选修的课程信息

Answer 1

题主要的代码如下，有帮助麻烦点个采纳【本回答右上角】，谢谢~~有其他问题可以继续交流~

select student.*,course.*,sc.*
from student
left join
(select sno,cno,grade from sc where sno in(select sno from sc group by sno having  COUNT(sno)>2)) sc
on sc.sno=student.sno
left join course on course.cno=sc.cno
where student.sno=sc.sno