sql分组和聚集

select st.name na,co.NAME name,sc.score from scores sc
left join students st on sc.sid = st.id
left join courses co on co.id=sc.cid

共9门课程，获取成绩未填满的学生：

select t.na,count(*) from

(select st.name na,co.NAME name,sc.score from scores sc
left join students st on sc.sid = st.id
left join courses co on co.id=sc.cid) t

group by t.na having count(*)<9;

sql分组和聚集

原文：https://www.cnblogs.com/mryangbo/p/10905242.html