SELECT aid ,  name FROM Aircraft ORDER BY distance DESC LIMIT 1
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 limit value
What is the id and name of the aircraft that can cover the maximum distance ?