Count active headcount by department

#1 · 1 of 5Free sample

Exercises (5)

Instructions

HR needs current headcount by department. An employee is active when employment_status = active.

Return two columns: department_name and active_headcount. Order by active_headcount from highest to lowest, then by .

department_name

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 →