筛选满足分数大于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;