CREATE TABLE Aircraft (aid VARCHAR, distance INT)

Show ids for all aircrafts with more than 1000 distance.
SELECT aid FROM Aircraft WHERE distance > 1000
SELECT "aid" FROM "Aircraft" WHERE "distance" > 1000