– 9、查询学过编号为“01“并且也学过编号为“02“的课程的同学的信息

– 9、查询学过编号为"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 IN ( SELECT sc.s_id FROM score sc WHERE sc.c_id='02' )