SQL for Monthly Active Uploaders | Dataford Interview Questions

Given a schema of user logins and project uploads, write a SQL query to find the monthly active users who uploaded more than five sheets.

Use the provided tables and count each row in project_uploads as one uploaded sheet. A user is active in a month only if they have at least one login during that month.

Output

Return one row per qualifying user and calendar month.
Include activity_month, user_id, and sheets_uploaded.
Sort by month ascending, then user_id ascending.

Schema

user_logins

Column	Type	Description
login_idPK	INT	Unique identifier for the login event
user_id	INT	Identifier of the user who logged in
login_at	TIMESTAMP	Timestamp when the login occurred

project_uploads

Column	Type	Description
upload_idPK	INT	Unique identifier for the uploaded sheet
user_id	INT	Identifier of the user who uploaded the sheet
uploaded_at	TIMESTAMP	Timestamp when the sheet was uploaded
sheet_name	VARCHAR(100)	Name assigned to the uploaded sheet

Your question is SQL for Monthly Active Uploaders. Start with the requirements and the two tables 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.

Problem