Skip to content
RED SAGSkills
easy5 pts · first answer countssqlcase-expressions

Bucketing with CASE WHEN

An order has amount = 500. Which label does this expression give it?

CASE
  WHEN amount >= 1000 THEN 'High'
  WHEN amount >= 500  THEN 'Medium'
  ELSE 'Low'
END
Choose one answer