What is CASE?

Use CASE for conditional output.

CASE lets you write conditional expressions. It produces different results based on a column value.

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

This query tags each product as expensive or cheap.

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

What is CASE? — details

CASE WHEN sets the condition, THEN the result. ELSE is the default, END closes it.

For example, CASE WHEN price > 100 THEN 'pahalı' ELSE 'ucuz' END labels each product by its price.

Tag each product by price 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;

Add END

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

Show answer

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