SQL for Candidate Scores | Dataford Interview Questions

Write a SQL query to retrieve candidate test scores above a specific threshold, joined with their respective company accounts.

Use a score threshold of 70. Return only candidates whose score is greater than the threshold and whose company account exists.

Output

One row per qualifying test score, with candidate_id, candidate_name, test_name, score, company_id, and company_name.
Sort by score descending, then candidate_id ascending.

candidate_test_scores

Column	Type	Description
score_idPK	INT	Unique identifier for a candidate test score
candidate_id	INT	Identifier of the candidate
candidate_name	VARCHAR(150)	Candidate's display name
test_name	VARCHAR(150)	Name of the completed test
score	INT	Candidate's test score
company_id	INT	Company account associated with the test

company_accounts

Column	Type	Description
company_idPK	INT	Unique identifier for a company account
company_name	VARCHAR(200)	Company account name
account_status	VARCHAR(30)	Current account status

Your question is SQL for Candidate Scores. 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.