Скачать или смотреть 1179. Reformat Department Table | Leetcode | Easy Problem

📊 SQL Tutorial: Transform Monthly Revenue Data for Departments 🏢

In this video, we solve an SQL challenge to reformat a table of department revenues by month into a pivoted format. You'll learn how to create a clean and structured table with each month represented as a separate column. This tutorial is perfect for anyone looking to improve their SQL skills in data manipulation and pivot table creation!

💡 What You’ll Learn in This Video:

Writing advanced SQL queries for data transformation.
Using CASE statements for conditional aggregation.
Implementing SUM() to pivot data and calculate monthly revenues.
Structuring and grouping data with GROUP BY and ORDER BY.
📊 SQL Query Covered:

sql
Copy code
SELECT id,
SUM(CASE WHEN month = 'Jan' THEN revenue ELSE NULL END) AS Jan_Revenue,
SUM(CASE WHEN month = 'Feb' THEN revenue ELSE NULL END) AS Feb_Revenue,
SUM(CASE WHEN month = 'Mar' THEN revenue ELSE NULL END) AS Mar_Revenue,
SUM(CASE WHEN month = 'Apr' THEN revenue ELSE NULL END) AS Apr_Revenue,
SUM(CASE WHEN month = 'May' THEN revenue ELSE NULL END) AS May_Revenue,
SUM(CASE WHEN month = 'Jun' THEN revenue ELSE NULL END) AS Jun_Revenue,
SUM(CASE WHEN month = 'Jul' THEN revenue ELSE NULL END) AS Jul_Revenue,
SUM(CASE WHEN month = 'Aug' THEN revenue ELSE NULL END) AS Aug_Revenue,
SUM(CASE WHEN month = 'Sep' THEN revenue ELSE NULL END) AS Sep_Revenue,
SUM(CASE WHEN month = 'Oct' THEN revenue ELSE NULL END) AS Oct_Revenue,
SUM(CASE WHEN month = 'Nov' THEN revenue ELSE NULL END) AS Nov_Revenue,
SUM(CASE WHEN month = 'Dec' THEN revenue ELSE NULL END) AS Dec_Revenue
FROM Department
GROUP BY id
ORDER BY id;
🔥 Why Watch This Video?

Master advanced SQL techniques for real-world applications.
Prepare for SQL interviews with practical examples.
Learn how to transform long-format tables into easy-to-read pivot tables.
👍 Don’t forget to Like, Share, and Subscribe for more SQL tutorials!
🔔 Click the BELL ICON to stay updated with our latest videos.

#SQL #SQLTutorial #LearnSQL #DataTransformation #PivotTableSQL #CodingChallenge #SQLQueries #SQLInterviewPreparation #DataAnalysis