1179. Reformat Department Table.ms sql server

select
    id
    ,[Jan] as Jan_Revenue
    ,[Feb] as Feb_Revenue
    ,[Mar] as Mar_Revenue
    ,[Apr] as Apr_Revenue
    ,[May] as May_Revenue
    ,[Jun] as Jun_Revenue
    ,[Jul] as Jul_Revenue
    ,[Aug] as Aug_Revenue
    ,[Sep] as Sep_Revenue
    ,[Oct] as Oct_Revenue
    ,[Nov] as Nov_Revenue
    ,[Dec] as Dec_Revenue
from (
        select d.id, d.revenue, d.month from dbo.Department as d
) as sq
pivot (sum(sq.revenue) for month in([Jan],[Feb],[Mar],[Apr],[May],[Jun],[Jul],[Aug],[Sep],[Oct],[Nov],[Dec])) as pvt;