Pivoting Data Dynamically 🔄

SELECT employee_id,
       MAX(CASE WHEN month = 'January' THEN sales END) AS january_sales,
       MAX(CASE WHEN month = 'February' THEN sales END) AS february_sales
FROM sales
GROUP BY employee_id;

• Use CASE to pivot specific rows into columns.
• MAX ensures unique values per column.