Captain of the Biggest Squad

Problem

Table: `roster`

| Column Name | Type |
|---|---|
| player_id | int |
| player_name | varchar(50) |
| squad_id | int |
| role | varchar(30) |

`player_id` is the primary key. Each row is a player belonging to a squad, with a `role` such as 'Captain' or 'Member'. A squad has exactly one captain.

Find the captain of the squad with the most players. If two or more squads tie for the largest size, return the captain of each of them. Output `captain_name` and `squad_id`, ordered by `squad_id`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns captain_name, squad_id.

Starter code (SQL)

SELECT *
FROM roster;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium