123123, Sql Server

Language: Layout:

CREATE TABLE SampleData (Grade INT,  TimeInterval INT, SubjectName VARCHAR(100))

INSERT SampleData
(
    Grade,
    TimeInterval,
    SubjectName
)
VALUES
    (1,        0,               'History    '),
    (1,        1,               'Chemistry  '),
    (1,        3,               'Biology    '),
    (2,        0,               'Maths      '),
    (2,        2,               'Biology    '),
    (2,        3,               'History    '),
    (3,        0,               'Biology    '),
    (3,        1,               'History    '),
    (3,        2,               'Chemistry  '),
    (3,        3,               'Maths      ');

DECLARE @cols nvarchar(max)

SELECT @cols = STUFF(
                    (SELECT DISTINCT CONCAT(',[', t.TimeInterval, ']') FROM SampleData t FOR XML PATH (''))
                   ,1,1,'')

DECLARE @headers nvarchar(max)

SELECT @headers = STUFF(
                    (SELECT DISTINCT CONCAT(', [' , t.TimeInterval , '] AS [TimeInterval' , t.TimeInterval, ']') FROM SampleData t FOR XML PATH (''))
                   ,1,1,'')

DECLARE @query nvarchar(max) = N'Select [Grade],  ' + @headers + 
        ' FROM 
         (
            SELECT Grade, TimeInterval, SubjectName FROM  SampleData
         ) src
         PIVOT
         (
            MAX(SubjectName) FOR TimeInterval IN ('+ @cols+ ')
         ) pvt
        '
PRINT @query

EXEC (@query)

DROP TABLE SampleData

View schema
Execution time: 0,03 sec, rows selected: 6, rows affected: 10, absolute service time: 0,2 sec