รายการเที่ยวบินตรงจาก SFO ไปยัง OAK ที่ออกเดินทางช่วงบ่ายไม่จำเป็นต้องใช้ตารางทั้งหมด
list nonstop flights from SFO to OAK that depart in the afternoonIt is not neccessary to use all the tables.
 airport:  airport_code [ varchar]  airport_name [ text]  airport_location [ text]  state_code [ varchar]  country_name [ varchar]  time_zone_code [ varchar]  minimum_connect_time [ int] 
SELECT DISTINCT flight.flight_id FROM airport AS AIRPORT_0, airport AS AIRPORT_1, airport_service AS AIRPORT_SERVICE_0, airport_service AS AIRPORT_SERVICE_1, city AS CITY_0, city AS CITY_1, flight WHERE ((((AIRPORT_0.airport_code = 'SFO' AND AIRPORT_1.airport_code = 'OAK' AND flight.from_airport = AIRPORT_0.airport_code AND flight.to_airport = AIRPORT_1.airport_code) AND CITY_1.city_code = AIRPORT_SERVICE_1.city_code AND CITY_1.city_name = 'OAKLAND' AND flight.to_airport = AIRPORT_SERVICE_1.airport_code) AND CITY_0.city_code = AIRPORT_SERVICE_0.city_code AND CITY_0.city_name = 'SAN FRANCISCO' AND flight.from_airport = AIRPORT_SERVICE_0.airport_code) AND flight.departure_time BETWEEN 1200 AND 1800) AND flight.stops = 0