查询选修某课程的同学人数多于5人的教师姓名。

24、查询选修某课程的同学人数多于5人的教师姓名。

答案:

select tname  from TEACHERS
    where tno in (select tno from COURSES where cno in (
        select cno from SCORES sc  group by cno having count(sc.sno)>5));