Largest Projects by Headcount
The IT department maintains a registry of projects and employees. The Employee table gives each employee a UUID id, years of experience, a hire moment (joined_at TIMESTAMPTZ), tenure as an INTERVAL, a remote-work flag, a JSONB skill map and a tag array. The Project table links projects to employees: one row per (project, employee) pair.\n\nFind the projects with the largest number of employees. If several projects tie for the maximum, return all of them.\n\nResult column: project_id, sorted ascending.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| project_id |
|---|
| 2 |
| 4 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in