Checking interview scores for accepted candidates

Question

Suppose your team is looking to see if there's a relationship between interview scores and on the job performance for folks who were hired at your company.

You're given the below tables, detailing candidate offer statuses ('Accepted', 'Declined', 'Rejected') as well as associated interview scores. Using these tables, write a SQL query to return the interview scores for candidates who accepted an offer.

Table: candidateStatus

candidate_name candidate_status
john_smith Accepted
sarah_daniels Declined
tim_cook Accepted
lisa_perelli Rejected
jenny_west Rejected
karl_tran Declined
tammy_turner Declined

Table: candidateInterviews

Each row represents a unique interview/candidate as well as the candidate's score (an integer from 1-5, with 5 representing the highest possible score).

candidate_name interview_score
john_smith 4
sarah_daniels 5
tim_cook 4
lisa_perelli 2
jenny_west 2
karl_tran 4
tammy_turner 3

For simplicity, these tables are small, but you can assume in practicality the tables would be way too large to export or visually search through.

You can view/query the data in an interactive SQL fiddle here.

Solution

Access restricted

Subscribe to premium account to see the solution.

Get premium now