Pivoting Data

Pivoting transforms row data into columns, making it easier to display aggregated data in a matrix format.

SELECT 
    product_id, 
    SUM(CASE WHEN month = 'January' THEN sales ELSE 0 END) AS January_Sales,
    SUM(CASE WHEN month = 'February' THEN sales ELSE 0 END) AS February_Sales
FROM 
    sales_data
GROUP BY 
    product_id;