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
Method One
Method Two
6. Method 2 – exercise
Method Three
Summary

Instruction

Excellent! Let's do an additional exercise.

Exercise

Count the total number of line items from orders shipped to Canada that were 1) sold at full price or 2) sold at a discounted price. Show two columns: FullPriceCount and DiscountedPriceCount.

Stuck? Here's a hint!

You need to join two tables: Orders and OrderItems.