SQL Top 10 Candidates Query | Dataford Interview Questions

Write a SQL query to retrieve the top 10 candidates based on performance metrics.

Use the provided candidate and performance metric data. Calculate each candidate's average non-null performance score and include only candidates with at least one score.

Output

Return one row per candidate with candidate_id, candidate_name, average_score, and metric_count.
Return at most 10 candidates, ordered by average score descending, metric count descending, and candidate ID ascending for ties.

Schema

candidates

Column	Type	Description
candidate_idPK	INT	Unique candidate identifier
candidate_name	VARCHAR(100)	Candidate's full name
is_active	BOOLEAN	Whether the candidate is currently active

performance_metrics

Column	Type	Description
metric_idPK	INT	Unique performance metric identifier
candidate_id	INT	Candidate associated with the metric
metric_name	VARCHAR(80)	Name of the measured performance dimension
score	DECIMAL(5,2)	Performance score, where higher values indicate stronger performance

Your question is SQL Top 10 Candidates 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