รายการเที่ยวบินจาก PITTSBURGH ไปยัง LOS ANGELES ซึ่งออกเดินทางในวันพฤหัสบดีหลัง 17.00 น. ไม่จำเป็นต้องใช้ตารางทั้งหมด
list flights from PITTSBURGH to LOS ANGELES which leave on thursday after 1700It is not neccessary to use all the tables.
 airport_service:  city_code [ varchar]  airport_code [ varchar]  miles_distant [ int]  direction [ varchar]  minutes_distant [ 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, date_day, days, flight WHERE ((date_day.day_number = 24 AND date_day.month_number = 5 AND date_day.year = 1991 AND days.day_name = date_day.day_name AND flight.departure_time > 1700 AND flight.flight_days = days.days_code) AND CITY_1.city_code = AIRPORT_SERVICE_1.city_code AND CITY_1.city_name = 'LOS ANGELES' 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