How many aircrafts have distance between 1000 and 5000?
CREATE TABLE Aircraft (distance INTEGER)
SELECT COUNT(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000
### Context: CREATE TABLE Aircraft (distance INTEGER) ### Question: How many aircrafts have distance between 1000 and 5000? ### Answer: SELECT COUNT(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000