新手求助！！！为什么要用sum？还有其他写法吗

按平均成绩从高到低显示所有学生的所有课程的成绩以及平均成绩

select sid,
    sum(case when cid=01 then score else null end) as score_01,
    sum(case when cid=02 then score else null end) as score_02,
    sum(case when cid=03 then score else null end) as score_03,
    avg(score)
from sc group by sid
order by avg(score) desc