CREATE TABLE Scores(	StudentID UNIQUEIDENTIFIER PRIMARY KEY,	StudentName NVARCHAR(50),	Title NVARCHAR(50),	Score INT,)INSERT INTO Scores(StudentID,StudentName,Title,Score)VALUES(NEWID(),'張三','語文',90);INSERT INTO Scores(StudentID,StudentName,Title,Score)VALUES(NEWID(),'張三','數學',80);INSERT INTO Scores(StudentID,StudentName,Title,Score)VALUES(NEWID(),'張三','英語',70);INSERT INTO Scores(StudentID,StudentName,Title,Score)VALUES(NEWID(),'李四','語文',60);INSERT INTO Scores(StudentID,StudentName,Title,Score)VALUES(NEWID(),'李四','數學',50);INSERT INTO Scores(StudentID,StudentName,Title,Score)VALUES(NEWID(),'王五','語文',40);SELECT * FROM Scores--DROP TABLE ScoresSELECT StudentName,MAX(CASE Title WHEN '語文' THEN Score ELSE 0 END) AS '語文' ,MAX(CASE Title WHEN '數學' THEN Score ELSE 0 END) AS '數學' ,MAX(CASE Title WHEN '英語' THEN Score ELSE 0 END) AS '英語' FROM ScoresGROUP BY StudentNameORDER BY StudentName