SQL - CASE Expressions
You want to categorize sales amounts into 'Low', 'Medium', and 'High' using Simple CASE. Which query correctly assigns:
- 'Low' for 0
- 'Medium' for 1
- 'High' for 2 or more (default)?
- 'Low' for 0
- 'Medium' for 1
- 'High' for 2 or more (default)?
SELECT SaleID,
CASE SaleAmount
WHEN 0 THEN 'Low'
WHEN 1 THEN 'Medium'
ELSE 'High'
END AS SaleCategory
FROM Sales;
