SELECT DISTINCT st.s_id,st.s_name FROM Student st
INNER JOIN Score sc ON st.s_id = sc.s_id
GROUP BY st.s_id,st.s_name
WHERE sc.c_id in (SELECT c_id FROM Score WHERE s_id = 01) AND st.s_id <> 01
SELECT DISTINCT st.s_id,st.s_name FROM Student st
INNER JOIN Score sc ON st.s_id = sc.s_id
GROUP BY st.s_id,st.s_name
WHERE sc.c_id in (SELECT c_id FROM Score WHERE s_id = 01) AND st.s_id <> 01