Loading…
Select order_id and total_amount, plus a CASE expression labeling orders as 'High Value' if total_amount > 10000, 'Medium Value' if between 5000 and 10000, and 'Low Value' otherwise.
Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.