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

Instruction

Good job! We have two more questions for you.

Exercise

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

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

Stuck? Here's a hint!