Introduction
Customer registration
Instruction
Very well done! Let's do one more exercise.
Exercise
Create a report to show the weekly counts of registration cohorts in 2017, based on the customer country. Show the following columns: registration_week, country, and registration_count. Order the results by week.
Stuck? Here's a hint!
Use the country column in the customers table. Filter for the appropriate rows:
WHERE registration_date >= '2017-01-01' AND registration_date < '2018-01-01'
