How many aircraft are there?
select count(*) from aircraft
How many of them have a distance between 1000 and 5000?
select count(*) from aircraft where distance between 1000 and 5000