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
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