มีเที่ยวบินใดบ้างระหว่าง 1000 ถึง 1500 ระหว่าง PITTSBURGH และ FORT WORTH ไม่จำเป็นต้องใช้ตารางทั้งหมด
what are the flights available between 1000 and 1500 between PITTSBURGH and FORT WORTHIt is not neccessary to use all the tables.
 flight_stop:  flight_id [ int]  stop_number [ int]  stop_days [ text]  stop_airport [ text]  arrival_time [ int]  arrival_airline [ text]  arrival_flight_number [ int]  departure_time [ int]  departure_airline [ text]  departure_flight_number [ int]  stop_time [ int] 
SELECT DISTINCT flight.flight_id FROM airport_service AS AIRPORT_SERVICE_0, airport_service AS AIRPORT_SERVICE_1, city AS CITY_0, city AS CITY_1, flight WHERE ((flight.departure_time <= 1500 AND flight.departure_time >= 1000) AND CITY_1.city_code = AIRPORT_SERVICE_1.city_code AND CITY_1.city_name = 'FORT WORTH' AND flight.to_airport = AIRPORT_SERVICE_1.airport_code) AND CITY_0.city_code = AIRPORT_SERVICE_0.city_code AND CITY_0.city_name = 'PITTSBURGH' AND flight.from_airport = AIRPORT_SERVICE_0.airport_code