一看需要查出学号,姓名,学院名称,还涉及到高等数学这门课程,那么需要四个表相关联,
这个条件既要满足我选择了高等数学,又要满足我只选择这一门课。
select s.sNo,s.sName,d.dName from student s
join sc on sc.sNo=s.sNo
join course c on sc.cNo=c.cNo
join department d on d.dNo=s.dNo
where s.sNo in(select sNo from sc group by sNo having count(*)=1) and c.cName='高等数学';