Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

SQL Proficiency Self-Rating

EasySQL · PostgreSQL00:00
Practice interviewer
In session
5 left
00:00

Your question is SQL Proficiency Self-Rating. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

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

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

Schema

candidate_sql_ratings
ColumnTypeDescription
candidate_idPKINTUnique candidate identifier
candidate_nameVARCHAR(255)Candidate full name
sql_proficiency_ratingINTRecorded SQL proficiency rating on a 1 to 5 scale
interview_stageVARCHAR(100)Interview stage where the rating was captured
feedback_dateDATEDate the feedback was entered
Tablescandidate_sql_ratings
Your solutionPostgreSQL
You need to log in / sign up to run or submit.
Run a query to see results