-- 11、查询没有学全所有课程的同学的信息

科技2022-07-20 135

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

Processed: 0.012, SQL: 8