Simple SQL Query | Dataford Interview Questions

Blackstone Talent Group needs a simple view of active Software Engineer candidates submitted during the current recruiting period. Write a PostgreSQL query that returns the selected candidate details from the candidate_submissions table.

Requirements

Return candidates whose role_title is Software Engineer, whose status is Submitted, and whose submitted_at is on or after January 1, 2025.
Return candidate_name, role_title, and submitted_at in ascending submission-date order. Use candidate name as a tie-breaker.

Schema

candidate_submissions

Column	Type	Description
submission_idPK	INT	Unique submission identifier
candidate_name	VARCHAR(100)	Candidate's full name
role_title	VARCHAR(100)	Role associated with the submission
status	VARCHAR(30)	Current recruiting status
submitted_at	DATE	Date the candidate was submitted

Your question is Simple 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.

Problem

Requirements

Return candidates whose role_title is Software Engineer, whose status is Submitted, and whose submitted_at is on or after January 1, 2025.
Return candidate_name, role_title, and submitted_at in ascending submission-date order. Use candidate name as a tie-breaker.

Schema

candidate_submissions

Column	Type	Description
submission_idPK	INT	Unique submission identifier
candidate_name	VARCHAR(100)	Candidate's full name
role_title	VARCHAR(100)	Role associated with the submission
status	VARCHAR(30)	Current recruiting status
submitted_at	DATE	Date the candidate was submitted

Your question is Simple 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.