23. Number of customers in a month
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).
Hint
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. 
Solution
SELECT
COUNT(*)
FROM users
WHERE
status = 'customer'
AND signup_date BETWEEN '2018-01-01' AND '2018-01-31'
![Anatoli Makarevich, author of SQL Habit]()
About SQL Habit
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 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.
Fluent in SQL in a month
