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

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 NULLS LAST LIMIT 1