What is the count of aircrafts that have a distance between 1000 and 5000?
SELECT count(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000
count of aircrafts with a distance between 1000 and 5000 refers to COUNT(*) WHERE distance BETWEEN 1000 AND 5000;