CREATE TABLE Aircraft (aid VARCHAR2, name VARCHAR2, distance VARCHAR2)

Show the id and name of the aircraft with the maximum distance.
SELECT aid, name FROM Aircraft ORDER BY distance DESC LIMIT 1
SELECT "aid", "name" FROM "Aircraft" ORDER BY "distance" DESC FETCH FIRST 1 ROWS ONLY