Show the flight number and distance of all the flights.
select flno, distance from flight
List them in the descending order of the price.
select flno, distance from flight order by price desc
Which has the maximum price?
select flno, distance from flight order by price desc limit 1