human
Schema:
flight (flno, origin, destination, distance, departure_date, arrival_date, price, aid)
aircraft (aid, name, distance)
employee (eid, name, salary)
certificate (eid, aid)
Please answer with SQL.
assistant
Sure, I understand.
human
Show the flight number and distance of all the flights.
assistant
SELECT flno , distance FROM Flight;
human
List them in the descending order of the price.
assistant
SELECT flno , distance FROM Flight ORDER BY price DESC;
human
Which has the maximum price?
assistant
SELECT flno , distance FROM Flight ORDER BY price DESC LIMIT 1 ;