Practice Interview Questions
| Question | Status |
|---|---|
Identify the top 5 longest US flights by distance.
Output includes the corresponding origin, destination, and distance. Sort the flights from longest to shortest.
us_flights table:
| Column Name | Description |
|---|---|
| flight_num | Flight number |
| origin | Origin name |
| dest | Destination name |
| distance | Distance value |
Example output:
| origin | dest |
|---|
Identify the top 5 longest US flights by distance.
Output includes the corresponding origin, destination, and distance. Sort the flights from longest to shortest.
us_flights table:
| Column Name | Description |
|---|---|
| flight_num | Flight number |
| origin | Origin name |
| dest | Destination name |
| distance | Distance value |
Example output:
| origin | dest |
|---|
| distance |
|---|
| SFO | MIA | 2585 |
| JFK | SMF | 2521 |
| distance |
|---|
| SFO | MIA | 2585 |
| JFK | SMF | 2521 |