Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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: full_price_count and discounted_price_count.

Stuck? Here's a hint!

You need to join two tables: orders and order_items.