Monthly Users SQL Query | Dataford Interview Questions

Write a SQL query to extract the total number of users per month from a given table.

Use the users table and its created_at column. Exclude users whose registration date is missing.

Output

users

Column	Type	Description
user_idPK	INT	Unique user identifier
email	VARCHAR(255)	User email address
created_at	TIMESTAMP	Timestamp when the user registered

Your question is Monthly Users SQL Query. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Write a SQL query to extract the total number of users per month from a given table.

Use the users table and its created_at column. Exclude users whose registration date is missing.

users

Column	Type	Description
user_idPK	INT	Unique user identifier
email	VARCHAR(255)	User email address
created_at	TIMESTAMP	Timestamp when the user registered

Your question is Monthly Users SQL Query. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.