CREATE TABLE aircraft (aid DECIMAL, name TEXT, distance DECIMAL)
CREATE TABLE flight (flno DECIMAL, origin TEXT, destination TEXT, distance DECIMAL, departure_date TIME, arrival_date TIME, price DECIMAL, aid DECIMAL)
CREATE TABLE certificate (eid DECIMAL, aid DECIMAL)
CREATE TABLE employee (eid DECIMAL, name TEXT, salary DECIMAL)

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" <= 5000 AND "distance" >= 1000