How Many 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 as long as the running total of veteran wages stays within budget. With whatever budget remains, it then hires `Rookie` pilots under the same cheapest-first rule. Report two rows with columns `rank` and `hired_count`: the number of veterans hired and the number of rookies hired. Return the veteran row first.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns rank, hired_count.

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