SELECT stu.* FROM course c,student stu,score s WHERE stu.s_id =s.s_id AND c.c_id=s.c_id AND c.c_name IN (SELECT c.c_name FROM course c,student stu,score s WHERE stu.s_id=s.s_id AND s.c_id=c.c_id AND stu.s_id=‘01’)GROUP BY s.s_id
