Database: flight_1
Question: Show ids for all aircrafts with more than 1000 distance.
SQL:
SELECT aid FROM Aircraft WHERE distance  >  1000