Bindle launched ads on Facebook, targeting English speaking countries: the USA, UK, Canada, and Australia (they’ll add Ireland and New Zealand to the mix later).
The question was: how many signups did they acquire from these countries?
So far we’ve learned how to count signups from a single country:
SELECT COUNT(*) FROM users WHERE country = 'us'
We even can filter signups within a time range (to make sure we can detect an uplift in signups when marketing campaigns were live):
SELECT COUNT(*) FROM users WHERE country = 'us' AND signup_date...
Sign up and check out 36 free lessons and exercises.
About SQL Habit
Hi, it’s Anatoli, the author of SQL Habit. 
SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst
and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 