求写一条sql语句，图片中是题目

Question

求出里面的第一道sql语句。。。

Answer 1

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