Everyone Under the Squadron Commander

Problem

Table: `Officers`

```text
+--------------+---------+
| Column | Type |
+--------------+---------+
| officer_id | int |
| officer_name | varchar |
| superior_id | int |
+--------------+---------+
officer_id is the primary key. Each row says the officer reports to the
officer whose id is superior_id. The squadron commander is officer_id = 1
(the commander's superior_id is their own id).
```

Find the `officer_id` of every officer who reports to the squadron commander (id = 1) **directly or indirectly**. Indirect means a chain: A reports to B, B reports to C, and C reports to the commander. The chain of command is at most 3 levels deep below the commander.

Do not include the commander themself. Return `officer_id` in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns officer_id.

Starter code (SQL)

SELECT *
FROM Officers;

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