-- Database schema
| flight : flno [ INT ] primary_key , origin [ TEXT ] , destination [ TEXT ] , distance [ INT ] , departure_date [ TEXT ] , arrival_date [ TEXT ] , price [ INT ] , aid [ INT ] flight.aid = aircraft.aid | aircraft : aid [ INT ] primary_key , name [ TEXT ] , distance [ INT ] | employee : eid [ INT ] primary_key , name [ TEXT ] , salary [ INT ] | certificate : eid [ INT ] primary_key certificate.eid = employee.eid , aid [ INT ] certificate.aid = aircraft.aid |
-- -- What is the count of aircrafts that have a distance between 1000 and 5000?

SELECT count(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000;