easyAirAsia · basics
Cheapest flights to a destination
AirAsia wants to show the cheapest fares to Kota Kinabalu first.
From the flights table, return the flight_no and price for every flight whose destination is 'Kota Kinabalu', ordered from cheapest to most expensive.
Schema
▸flights
| flight_no | TEXT |
| destination | TEXT |
| price | NUMERIC(8,2) |
Example input
▸flights