– 查询平均成绩大于等于85的所有学生的学号、姓名和平均成绩
SELECT
st.s_id,
st.s_name,
AVG(sc.s_score)
FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
GROUP BY st.s_id HAVING AVG(sc.s_score)>=85
– 查询平均成绩大于等于85的所有学生的学号、姓名和平均成绩
SELECT
st.s_id,
st.s_name,
AVG(sc.s_score)
FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
GROUP BY st.s_id HAVING AVG(sc.s_score)>=85