Menu

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_noTEXT
destinationTEXT
priceNUMERIC(8,2)

Example input

flights
↑ Read the question

Keep going

Company names are trademarks of their respective owners, used here only to describe practice material. mahir_data is not affiliated with, endorsed by, or sponsored by any company named on this site. Terms.