Database: flight_1
Question: Show the id and name of the aircraft with the maximum distance.
SQL:
SELECT aid ,  name FROM Aircraft ORDER BY distance DESC LIMIT 1