SQL Proficiency Self-Rating | Dataford Interview Questions

How would you rate your SQL proficiency?

Asked in the HR Phone Screen stage. Keep your answer grounded in the data provided and return a concise result set that can be reviewed by the interviewer.

Output

One row per candidate
Columns: candidate_name, sql_proficiency_rating
Include candidates with a recorded rating only
Sort by sql_proficiency_rating from highest to lowest, then candidate_name ascending

Schema

candidate_sql_ratings

Column	Type	Description
candidate_idPK	INT	Unique candidate identifier
candidate_name	VARCHAR(255)	Candidate full name
sql_proficiency_rating	INT	Recorded SQL proficiency rating on a 1 to 5 scale
interview_stage	VARCHAR(100)	Interview stage where the rating was captured
feedback_date	DATE	Date the feedback was entered

Your question is SQL Proficiency Self-Rating. 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