Crew Size per Worker

For each employee return the size of their team. Return columns employee_id and team_size. Order the result by employee_id in ascending order.

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. Your answer must use the same column names as this sample — alias them with AS if needed.

employee_id	team_size
1	2
2	2
3	3

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid