CASE

1
SELECT
2
  product_name,
3
  price,
4
  CASE
5
    WHEN price < 100 THEN 'Budget'
6
    WHEN price < 500 THEN 'Mid-range'
7
    WHEN price < 1000 THEN 'Premium'
8
    ELSE 'Luxury'
9
  END as category
10
FROM products;

1
SELECT
2
  status,
3
  CASE status
4
    WHEN 'A' THEN 'Active'
5
    WHEN 'I' THEN 'Inactive'
6
    WHEN 'P' THEN 'Pending'
7
    ELSE 'Unknown'
8
  END as status_label
9
FROM accounts;