– 11、查询没有学全所有课程的同学的信息
SELECT st.*
FROM student st
LEFT JOIN score sc1 ON sc1.s_id=st.s_id AND sc1.c_id='01'
LEFT JOIN score sc2 ON sc2.s_id=st.s_id AND sc2.c_id='02'
LEFT JOIN score sc3 ON sc3.s_id=st.s_id AND sc3.c_id='03'
WHERE sc1.s_score IS NULL OR sc2.s_score IS NULL OR sc3.s_score IS NULL