-- 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