What are the ids of all aircrafts that can cover a distance of more than 1000?
SELECT aid FROM Aircraft WHERE distance  >  1000
ids of all aircrafts = aid; can cover a distance of more than 1000 refers to distance > 1000;