SELECT st.* FROM student st LEFT JOIN score sc ON st.s_id=sc.s_id GROUP BY st.s_id HAVING COUNT(sc.s_score)<3