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).

⚠ Type SQL queries in the SQL Editor ☝ to find the answer to this exercise. Do your research in the SQL Editor and then submit numeric or text answer via this form. ⚠

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

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. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type in your query here. You might want to start by listing all records: SELECT * FROM users
LIMIT 500
Loading chart... ⏳