SELECT flno ,  distance FROM Flight ORDER BY price DESC LIMIT 1
What is the flight number and its distance for the one with the maximum price?
SELECT flno , distance FROM Flight ORDER BY price DESC LIMIT 1
select flno , distance from flight order by price desc limit value
What is the flight number and its distance for the one with the maximum price ?