求出里面的第一道sql语句。。。
select name , sum(case subject when '语文' then score else '' end) as 语文,sum(case subject when '数学' then score else '' end) as 数学,sum(case subject when '英语' then score else '' end) as 英语from T_table group by name