select student.* from student where not exists （select sc.sid from sc where student.sid=sc.sid group by sc.sid having count（*）= （select count（*）from course））；