Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Custom classifications of business objects
Custom grouping of business objects
Custom counting of business objects
17. Question 2


Good job! We have two more questions for you.


We would like to categorize all orders based on their total price (before any discount). For each order, show the following columns:

  1. order_id
  2. total_price (calculated before discount)
  3. price_group, which should have the following values:
    • 'high' for a total price over $2 000.
    • 'average' for a total price between $600 and $2 000, both inclusive.
    • 'low' for a total price under $600.