Show the id and name for all aircraft.
select aid, name from aircraft
Order the results in descending order of distance.
select aid, name from aircraft order by distance desc
Which one has the maximum?
select aid, name from aircraft order by distance desc limit 1