请问从学生表中查出每个学生的成绩的sql语句怎么写？

Question

请问从学生表中查出每个学生的成绩的sql语句怎么写？
按照图上的要求怎么编写sql，麻烦大神提供一下思路

Answer 1

select name '姓名',
sum(case subject when '语文' then score else 0 end) as '语文',
sum(case subject when '数学' then score else 0 end) as '数学',
sum(case subject when '英语' then score else 0 end) as '英语'
from first.tb group by name

MySQL