【数据分析】- SQL面试50题 - 跟我一起打怪升级 一起成为数据科学家

第六题:
SELECT Student.s_id, Student.s_name
from Student
         INNER JOIN Score S on Student.s_id = S.s_id
         INNER JOIN Course C on S.c_id = C.c_id
         INNER JOIN Teacher T on C.t_id = T.t_id
where T.t_name = '张三'
group by Student.s_id
having count(1) = (SELECT COUNT(1) from Course where t_id = '01')