– 10、查询学过编号为“01“但是没有学过编号为“02“的课程的同学的信息

– 10、查询学过编号为"01"但是没有学过编号为"02"的课程的同学的信息

SELECT st.* FROM student st WHERE st.s_id IN( SELECT sc.s_id FROM score sc WHERE sc.c_id='01') AND st.s_id NOT IN ( SELECT sc.s_id FROM score sc WHERE sc.c_id='02' )