Reformat Department Table

Moderate
0/80
Average time to solve is 20m

Problem statement

Table: Department


 Column Name    Data Type  
 id  INT
 revenue  INT
 month  VARCHAR


  • The table has information about the revenue of each department per month.
  • The month has values in ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"].


Write an SQL query to reformat the table such that there is a department id column and a revenue column for each month.


The query result format is in the following example: Department table:

 id    revenue    month  
 1  8000  Jan
 2  9000  Jan
 3  10000  Feb
 1  7000  Feb
 1  6000  Mar



Result table:

Note that the result table has 13 columns (1 for the department id + 12 for the months).

Solution
(100% EXP penalty)
Reformat Department Table
Console