Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
3. The customers table – recap
Customer activity
Finding good customers


Good! The other table we'll need in this part is customers. We've used it before, but this time we'll especially need the last_order_date column.


Count the number of customers who placed their most recent order in 2018. Name the column: count_2018_customers.

Stuck? Here's a hint!

Use the following WHERE clause:

WHERE last_order_date >= '2018-01-01'
  AND last_order_date <  '2019-01-01'