SELECT name FROM Aircraft ORDER BY distance LIMIT 3
Show the name of aircrafts with top three lowest distances.
SELECT name FROM Aircraft ORDER BY distance LIMIT 3
select name from aircraft order by distance limit value
Show the name of aircrafts with top three lowest distances .