Summary - CASE

Write a conditional total report with CASE and SUM.

CASE produces conditional expressions. Forms include searched and simple, with ELSE defaults and aggregate use.

SELECT name,
  CASE WHEN price > 100 THEN 'pahalı' ELSE 'ucuz' END AS tier
FROM products;

Summary CASE query.

name, CASE WHEN price > 100 THEN 'pahalı' ELSE 'ucuz' END … is selected from products.

Exercise Summary - CASE

Summary: tag each product with CASE WHEN price > 100 THEN 'pahalı' ELSE 'ucuz' END.

Show example solution

SELECT name,
  CASE WHEN price > 100 THEN 'pahalı'
       ELSE 'ucuz' END AS tier
FROM products;