How many aircrafts have distance between 1000 and 5000?
CREATE TABLE Aircraft (distance INTEGER)
SELECT COUNT(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Aircraft (distance INTEGER) Question: How many aircrafts have distance between 1000 and 5000? [/INST] SELECT COUNT(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000 </s>