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
flight number = flno; its distance = distance; one with the maximum price refers to MAX(price);