The ranks convert one

Original View structure:

--------------------------

| name | Subject | Score |
--------------------------
| Zhang San | English | 88 |
| Zhang San | Math | 90 |
| Zhang San | language | 90 |
| John Doe | language | 91 |
| John Doe | English | 88 |
| John Doe | Math | 99 |
--------------------------

After conversion:

---------------------------
| name | language | Math | English |
---------------------------
| John Doe | 91 | 99 | 88 |
| Zhang San | 90 | 90 | 88 |
---------------------------

Implementation code:

Select name Name,
SUM (case subject when ' language ' then score else 0 end) language,
SUM (case subject when ' math ' then score else 0 end) Math,
SUM (case subject when ' English ' then score else 0 end) English
From score group by name;

The ranks convert one