select
  id,
  name,
  category,
  price,
  case
    when category = 5 then 'Premium'
    when category = 4 then 'Gold'
    when category = 3 then 'Standard'
    when category <= 2 then 'Basic'
    else 'unknown'
  end as quality_level
from products;