Relate attrition to each employee's latest review

#5 · 5 of 5Free sample

Exercises (5)

Instructions

Employees can have several performance reviews. Using only each employee's most recent review, calculate attrition by review_outcome.

Return three columns: review_outcome, employees, and attrition_pct rounded to 1 decimal. Order by from highest to lowest.

attrition_pct

Loading the practice editor and dataset…

Tables

5 tables · 29 columns

departments4 cols

department_idTEXT PRIMARY KEY
department_nameTEXT NOT NULL
business_unitTEXT NOT NULL
regionTEXT NOT NULL

job_roles6 cols

role_idTEXT PRIMARY KEY
role_titleTEXT NOT NULL
job_familyTEXT NOT NULL
job_levelTEXT NOT NULL
salary_band_minREAL NOT NULL
salary_band_maxREAL NOT NULL

employees5 cols

employee_idTEXT PRIMARY KEY
hire_dateTEXT NOT NULL
age_bandTEXT NOT NULL
education_levelTEXT NOT NULL
commute_bandTEXT NOT NULL

employment_records9 cols

employment_record_idTEXT PRIMARY KEY
employee_idTEXT NOT NULL
department_idTEXT NOT NULL
role_idTEXT NOT NULL
started_atTEXT NOT NULL
ended_atTEXT
employment_statusTEXT NOT NULL
termination_typeTEXT
base_salaryREAL NOT NULL

performance_reviews5 cols

review_idTEXT PRIMARY KEY
employee_idTEXT NOT NULL
review_dateTEXT NOT NULL
review_scoreINTEGER NOT NULL
review_outcomeTEXT NOT NULL

Sign up to unlock

The reference answer is one attempt away.

Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.

Save attempts and completed exercises
Reveal this free exercise's answer after an attempt
Return to your progress from any device
Free forever — no credit card

Create free account →Already a member? Log in →