三元表达式

select 
student.sid,
student.sname,
-- if (sum(num),sun(num),0)
(case when sum(num) then sum(num) else 'aa' end ) as "总分"
from student left join score on student.sid = score.student_id 
group bu student.sid;