Second-Best Pilot by Passengers
Aviation analytics is finding the flight with the second-highest passenger count. Among all flights, locate the one whose passengers is the second-largest after the maximum, and output the pilot's name and the flight's passengers.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| name | passengers |
|---|---|
| Brown | 250 |
T-Bank
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid