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