Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Method One
Method Two
6. Method 2 – exercise
Method Three


Excellent! Let's do an additional 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.