mysql问题之行转列

最近遇到一个行专列的查询，现有数据表结果如下

现在要实现查询出来的效果如下

查询语句如下：

SELECT `name`,
sum(case `subject` when 'chinese' THEN score ELSE 0 END) as 'chinese',
sum(if (SUBJECT='math',score,0)) as 'math',
sum(if (SUBJECT='english',score,0)) as 'english'
FROM score group BY `name`