Third Highest Number Query | Dataford Interview Questions

Recro's technical assessment pipeline needs to identify the third highest distinct integer score across submitted assessments. Write a PostgreSQL query that validates submitted scores against registered candidates and reports how many candidates achieved that score.

Requirements

Rank non-null scores from highest to lowest using distinct-score semantics.
Return the third highest distinct score, not the third row after sorting.
Count candidates who achieved that score, including ties.
Exclude assessment rows that do not match a registered candidate.

Schema

candidates

Column	Type	Description
candidate_idPK	INT	Unique candidate identifier
candidate_name	VARCHAR(100)	Candidate's full name
application_stage	VARCHAR(30)	Current recruitment stage

assessment_scores

Column	Type	Description
assessment_idPK	INT	Unique assessment submission identifier
candidate_id	INT	Candidate associated with the submission
score	INT	Integer assessment score

Your question is Third Highest Number Query. 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