How many aircrafts have distance between 1000 and 5000?
SELECT count(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000
SELECT count(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000
[{'count(*)': 9}]