Compare voluntary attrition by commute distance

#3 · 3 of 5Free sample

Exercises (5)

Instructions

Does commute distance relate to employees choosing to leave? Calculate voluntary attrition (termination_type = voluntary) by commute_band.

Return three columns: commute_band, , and rounded to 1 decimal. Order by .

employees

voluntary_attrition_pct

commute_band

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 →