CREATE TABLE Flight (flno VARCHAR2, distance VARCHAR2, price VARCHAR2)

Show the flight number and distance of the flight with maximum price.
SELECT flno, distance FROM Flight ORDER BY price DESC LIMIT 1
SELECT "flno", "distance" FROM "Flight" ORDER BY "price" DESC FETCH FIRST 1 ROWS ONLY