求助各位大神这种SQL语句应该这么写

Question

求教一下这种sql应该怎么写呀，想了好久没想出来

Answer 1

select student,
sum(case course when '语文' then score end) as '语文',
sum(case course when '数学' then score end) as '数学',
sum(case course when '英语' then score end) as '英语'
from 分数表
group by 学生表

Answer 2

学习了 ，SQL 行转列

Answer 3

https://www.cnblogs.com/WangShuaishuai/p/9407917.html