【數(shù)據(jù)分析】- SQL面試50題 - 跟我一起打怪升級(jí) 一起成為數(shù)據(jù)科學(xué)家
2022-05-20 23:58 作者:XiaKaLa_BOOM | 我要投稿
第六題:
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')
標(biāo)簽：
