#297

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

Your query result will appear here