-- 4、查询平均成绩小于60分的同学的学生编号和学生姓名和平均成绩 -- (包括有成绩的和无成绩的)

SELECT
st.s_id,
st.s_name,
CASE WHEN AVG(sc.s_score) IS  NULL  THEN '无' ELSE ROUND (AVG(sc.s_score) ,2) END AS '平均分'
FROM  student st
LEFT JOIN score sc ON sc.s_id=st.s_id
GROUP BY st.s_id 
HAVING AVG(sc.s_score)<60  OR  AVG(sc.s_score) IS NULL
版权声明：本文为Ele_sorriu原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。