-- 12、查询至少有一门课与学号为“01“的同学所学相同的同学的信息

SELECT 
DISTINCT st.*
FROM student st 
LEFT JOIN score sc ON sc.s_id=st.s_id
WHERE sc.c_id IN (
SELECT 
sc2.c_id 
FROM student st2
LEFT JOIN score sc2 ON sc2.s_id=st2.s_id
WHERE st2.s_id ='01'
)