Which Veteran and Rookie Pilots Fit the Payroll

Problem

Table: `pilots`

| Column Name | Type |
|---|---|
| pilot_id | int |
| rank | enum |
| wage | int |

`pilot_id` is the primary key. `rank` is one of `('Veteran', 'Rookie')`. `wage` is the pilot's annual wage.

An airline has a hiring budget of `50000`. It first hires `Veteran` pilots, cheapest wage first (ties broken by smaller `pilot_id`), taking each while the running total of veteran wages stays within budget. With the leftover budget it then hires `Rookie` pilots under the same cheapest-first rule. Return the `pilot_id` of every pilot actually hired, in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns pilot_id.

Starter code (SQL)

SELECT *
FROM pilots;

Related SQL questions

• 3-Consecutive-Week Marketing StreakHard
• 30-Day Rolling Average Trading VolumeHard
• 7-Day Active User Rolling MetricHard
• 7-Day Revenue Moving AverageHard
• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard