Your question is Top Candidates with Complex Joins. 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.
Phenom's recruiting analytics team wants to identify top-performing candidates across its candidate experience and recruiting workflows. Write a PostgreSQL query that ranks eligible candidates using application outcomes and completed interview scores.
advanced or hired.| Column | Type | Description |
|---|---|---|
| candidate_idPK | INT | Unique candidate identifier |
| full_name | VARCHAR(100) | Candidate full name |
| VARCHAR(150) | Candidate email address | |
| current_title | VARCHAR(120) | Candidate's current job title |
| Column | Type | Description |
|---|---|---|
| application_idPK | INT | Unique application identifier |
| candidate_id | INT | References candidates.candidate_id |
| applied_at | DATE | Date the application was submitted |
| status | VARCHAR(30) | Current application status |
| source | VARCHAR(50) | Application source |
| Column | Type | Description |
|---|---|---|
| interview_idPK | INT | Unique interview identifier |
| application_id | INT | References applications.application_id |
| interview_status | VARCHAR(30) | Interview completion status |
| score | INT | Interview score from 0 to 100 |
| interviewer | VARCHAR(100) | Interviewer name |