So far we’ve been using the signup_date
column in the users
table to filter data:
SELECT COUNT(*) FROM users WHERE signup_date BETWEEN '2018-01-01' AND '2018-01-07'
As you remember, signup_date
is simply a date when a user signed up (in other words, when a record in the users table was created). The signup timestamp is stored inside the created_at
column which has type datetime. We can use the created_at
column for our filter the same way:
SELECT COUNT(*) FROM users WHERE created_at BETWEEN '2018-01-01' AND '2018-01-07'
SQL will figure out that...
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. 