SELECT count(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000
What is the count of aircrafts that have a distance between 1000 and 5000?
SELECT count ( * ) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000
select count ( * ) from aircraft where distance between value and value
What is the count of aircrafts that have a distance between 1000 and 5000 ?