←TrainerTask 7 / 217
Ticket #7
Price segments
Task
Management wants price segments. Add a segment column: Budget for prices below $500, Mid-range — from $500 to $999, Premium — from $1000. Output name, price and segment.
You'll need:Conditional logic: CASE WHEN(opens in a new tab)
SQL query
Query results will appear here
Preparing the lesson database…