单表多个字段求和SQL

筛选满足分数大于240的姓名及总分

select name,sum(score) score
from(
select name,arith_score score from student_score
union select name,en_score score from student_score
union select name,china_score score from student_score) a
group by name
having sum(score)>240;

select * from student_score;