SELECT stu.* FROM student stu WHERE stu.s_id NOT IN (SELECT stu.s_id FROM student stu,score s WHERE stu.s_id=s.s_id GROUP BY s.s_id HAVING COUNT(s.c_id)=3 )
