gitGood.dev
← SQL Playground

Headcount Per Department

Easy
For every department, return its 'name' and the number of employees as 'headcount'. Include departments even if reasoning about empty ones - here all have staff.
Schema
departments (id, name)
employees (id, name, department_id, salary, hire_date)
Loading editor…
Hints