Summary - Pivot

Write a monthly sales pivot with CASE.

Pivot turns rows into columns. Done with CASE and SUM, FILTER is more readable.

SELECT
  SUM(CASE WHEN category = 'Kitap' THEN amount ELSE 0 END) AS Kitap
FROM sales;

Summary pivot query.

SUM(CASE WHEN category = 'Kitap' THEN amount ELSE 0 END) … is selected from sales.

Exercise Summary - Pivot

Summary: pivot with SUM(CASE WHEN category = 'Kitap' THEN amount ELSE 0 END).

Show example solution

SELECT
  SUM(CASE WHEN category = 'Kitap' THEN amount ELSE 0 END) AS Kitap
FROM sales;