MySQL

1# Runtime: 449 ms, faster than 61.35%
2# Memory Usage: 0B, less than 100.00%
3
4# Write your MySQL query statement below
5SELECT id,
6    SUM(CASE WHEN month = 'Jan' THEN revenue END) as Jan_Revenue,
7    SUM(CASE WHEN month = 'Feb' THEN revenue END) as Feb_Revenue,
8    SUM(CASE WHEN month = 'Mar' THEN revenue END) as Mar_Revenue,
9    SUM(CASE WHEN month = 'Apr' THEN revenue END) as Apr_Revenue,
10    SUM(CASE WHEN month = 'May' THEN revenue END) as May_Revenue,
11    SUM(CASE WHEN month = 'Jun' THEN revenue END) as Jun_Revenue,
12    SUM(CASE WHEN month = 'Jul' THEN revenue END) as Jul_Revenue,
13    SUM(CASE WHEN month = 'Aug' THEN revenue END) as Aug_Revenue,
14    SUM(CASE WHEN month = 'Sep' THEN revenue END) as Sep_Revenue,
15    SUM(CASE WHEN month = 'Oct' THEN revenue END) as Oct_Revenue,
16    SUM(CASE WHEN month = 'Nov' THEN revenue END) as Nov_Revenue,
17    SUM(CASE WHEN month = 'Dec' THEN revenue END) as Dec_Revenue
18FROM Department
19GROUP BY ide