select b.name as 年级,
sum(case when a.type='语文' then a.score else 0 end) as 语文总分数,
sum(case when a.type='数学' then a.score else 0 end) as 数学总分数
from a,b where a.gradeid=b.id
group by b.name
select sum(score) from A group by gradeid,type
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024