Your question is SQL Joins and Window Functions. Start with the requirements and the three tables 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.
Steven Douglas Associates wants a recruiter-facing view of candidate applications and interview performance. Applications without scored feedback must remain visible so recruiters can identify records needing review.
Write a PostgreSQL query that joins candidates, applications, and interview feedback to rank each candidate's qualifying applications.
ROW_NUMBER().Recommended, Review, or Needs review with CASE.| Column | Type | Description |
|---|---|---|
| candidate_idPK | INT | Unique candidate identifier |
| candidate_name | VARCHAR(100) | Candidate's full name |
| VARCHAR(150) | Candidate email address |
| Column | Type | Description |
|---|---|---|
| application_idPK | INT | Unique application identifier |
| candidate_id | INT | References candidates.candidate_id |
| position_title | VARCHAR(150) | Position associated with the application |
| submitted_at | DATE | Date the application was submitted |
| status | VARCHAR(30) | Application workflow status |
| Column | Type | Description |
|---|---|---|
| feedback_idPK | INT | Unique feedback identifier |
| application_id | INT | References applications.application_id |
| interviewer_name | VARCHAR(100) | Interviewer providing feedback |
| score | NUMERIC(5,2) | Interview score from 0 to 100 |
| recommendation | VARCHAR(30) | Interviewer's recommendation |