Players Whose Coach Left the Roster

Problem

Table: `roster`

| Column Name | Type |
|---|---|
| player_id | int |
| full_name | varchar |
| coach_id | int |
| stipend | int |

`player_id` is the primary key. Each row gives a player, their monthly stipend, and the `player_id` of their coach (a coach is also listed as a player). Some players have no coach (`coach_id` is NULL).

Return the `player_id` of every player whose stipend is strictly below `2000` and whose coach is no longer on the roster. A coach is no longer on the roster when their id does not appear as any `player_id`. Order the result by `player_id` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns player_id.

Starter code (SQL)

SELECT *
FROM roster;

Related SQL questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• App Ad Click-Through RateEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy