Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Basic SQL Reports in SQL Server

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!