SQL: Candidate Over-Application | Dataford Interview Questions

Write a query to identify candidates who have applied to more than three jobs in the last 30 days, ranking them by their most recent application date.

Use the provided candidates and applications data. Treat applications with a NULL application date as outside the reporting period.

Output

One row per qualifying candidate with candidate_id, candidate_name, application_count, most_recent_application, and application_rank.
Include only candidates with more than three applications in the last 30 days.
Rank by most recent application date descending, with ties sharing a rank. Sort tied rows by candidate_id ascending.

Schema

candidates

Column	Type	Description
candidate_idPK	INT	Unique candidate identifier
candidate_name	VARCHAR(120)	Candidate's full name
email	VARCHAR(255)	Candidate email address

applications

Column	Type	Description
application_idPK	INT	Unique application identifier
candidate_id	INT	Candidate who submitted the application
job_id	INT	Job associated with the application
applied_at	TIMESTAMP	Timestamp when the application was submitted

Your question is SQL: Candidate Over-Application. 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