SELECT
st.s_id,
st.s_name,
COUNT(sc.c_id),
CASE WHEN SUM(sc.s_score) IS NULL THEN 0.00 ELSE ROUND(SUM(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
转载请注明原文地址:https://blackberry.8miu.com/read-10084.html