SQL for Early Multi-Job Applicants | Dataford Interview Questions

Write a SQL query to find the monthly active student users who applied to at least two jobs in their first week of registration.

Use the users and job_applications tables. Treat the first week as the interval from registration time, inclusive, through seven days later, exclusive. A user is active in a month when they submitted at least one application during that calendar month.

Output

One row per active month and student user.
Columns: activity_month, user_id, and monthly_applications.
Include only qualifying users, ordered by activity_month ascending and user_id ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_type	VARCHAR(30)	User classification, such as student or employer
registered_at	TIMESTAMP	Timestamp when the user registered

job_applications

Column	Type	Description
application_idPK	INT	Unique application identifier
user_id	INT	User who submitted the application
job_id	INT	Job targeted by the application
applied_at	TIMESTAMP	Timestamp when the application was submitted

Your question is SQL for Early Multi-Job Applicants. 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