SELECT aid ,  name FROM Aircraft ORDER BY distance DESC LIMIT 1
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 limit value
Show the id and name of the aircraft with the maximum distance .