Month-to-month growth is a very important metric for a company. Let’s use everything we’ve learned so far and calculate how many customers Bindle added within the first month after launch (Jan 2018).
We need to write a query that filters records in the users
table for status (we need customer-s) and signup_date (we need only Jan 2018).
Now you have a good arsenal of date filters to apply – greater than >, greater than or equals >=, less than <, less than or equals <= or BETWEEN.
SELECT
COUNT(*)
FROM users
WHERE
status = 'customer'
AND signup_date BETWEEN '2018-01-01' AND '2018-01-31'
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 and exercises (you’re looking at one atm). They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work.