yes
select distance from aircraft where name = 'Boeing 747-400'
What is the distance of the aircraft with the name Boeing 737-800?
select distance from aircraft where name = 'Boeing 737-800'
What is the name of the aircraft with distance 7120?
select name from aircraft where distance = 7120
What is the id of the aircraft with the maximum distance?
select aid from aircraft order by distance desc limit 1
yes
select name from aircraft order by distance desc limit 1