将行数据转换为列显示

SELECT a.id,
(SELECT Score FROM Table_1 WHERE Subject = '数学' AND a.id = Table_1.id) AS Math,
(SELECT Score FROM Table_1 WHERE Subject = '语文' AND a.id = Table_1.id) AS Chinese,
(SELECT Score FROM Table_1 WHERE Subject = '英语' AND a.id = Table_1.id) AS English
FROM Table_1 a
GROUP BY a.id;