Learn AI Create the Future — with Pranay
Main site

LeetCode solutions

1301. Reformat Department Table

My accepted SQL solution to LeetCode problem 1301, Reformat Department Table, running in 486ms.

  • Difficulty: Easy
  • SQL
  • Runtime 486ms
  • Memory 0.0B

Read the problem on LeetCode View on GitHub

The problem statement is LeetCode’s and stays on their site. What follows is my accepted solution.

SQL

Accepted on LeetCode — runtime 486ms, memory 0.0B, accepted 2025-12-29.

sql
SELECT id,
    SUM(CASE WHEN month = 'Jan' THEN revenue END) AS Jan_Revenue,
        SUM(CASE WHEN month = 'Feb' THEN revenue END) AS Feb_Revenue,
            SUM(CASE WHEN month = 'Mar' THEN revenue END) AS Mar_Revenue,
                SUM(CASE WHEN month = 'Apr' THEN revenue END) AS Apr_Revenue,
                    SUM(CASE WHEN month = 'May' THEN revenue END) AS May_Revenue,
                        SUM(CASE WHEN month = 'Jun' THEN revenue END) AS Jun_Revenue,
                            SUM(CASE WHEN month = 'Jul' THEN revenue END) AS Jul_Revenue,
                                SUM(CASE WHEN month = 'Aug' THEN revenue END) AS Aug_Revenue,
                                    SUM(CASE WHEN month = 'Sep' THEN revenue END) AS Sep_Revenue,
                                        SUM(CASE WHEN month = 'Oct' THEN revenue END) AS Oct_Revenue,
                                            SUM(CASE WHEN month = 'Nov' THEN revenue END) AS Nov_Revenue,
                                                SUM(CASE WHEN month = 'Dec' THEN revenue END) AS Dec_Revenue
                                                FROM Department
                                                GROUP BY id

Source