SELECT id,
(SELECT Score FROM Table_1 WHERE KeMu='數學' AND id=a.id)as 數學,
(SELECT Score FROM Table_1 WHERE KeMu='語文' AND id=a.id)AS 語文,
(SELECT Score FROM Table_1 WHERE KeMu='英語' AND id=a.id)AS 英語
FROM Table_1 a
GROUP BY a.id