use below syntax for pivot table in sql

SELECT <non-pivoted column>,

[first pivoted column] AS <column name>,

[second pivoted column] AS <column name>,

.............................

FROM

(<SELECT query that produces the data>)

AS <alias for the source...