CREATE TABLE aircraft (aid NUMBER, name CLOB, distance NUMBER)
CREATE TABLE certificate (eid NUMBER, aid NUMBER)
CREATE TABLE employee (eid NUMBER, name CLOB, salary NUMBER)
CREATE TABLE flight (flno NUMBER, origin CLOB, destination CLOB, distance NUMBER, departure_date TIME, arrival_date TIME, price NUMBER, aid NUMBER)

What is the id and name of the aircraft that can cover 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