SQL Arena
#289

Crew Size per Worker

For each employee return the size of their team. Return columns employee_id and team_size.

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.

team_sizeemployee_id
21
22
33
Sign in to submit

Your query result will appear here