รายการเที่ยวบินวันพุธจากเดนเวอร์ไปบัลติมอร์ที่มาถึงบัลติมอร์ระหว่างเวลา 11.15 น. ถึง 12.45 น. ไม่จำเป็นต้องใช้ตารางทั้งหมด
list the WEDNESDAY flights from DENVER to BALTIMORE arriving in BALTIMORE between 1115 and 1245pmIt is not neccessary to use all the tables.
 state:  state_code [ text]  state_name [ text]  country_name [ text] 
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, days, flight WHERE (((flight.arrival_time <= 1245 AND flight.arrival_time >= 1115) AND days.day_name = 'WEDNESDAY' AND flight.flight_days = days.days_code) AND CITY_1.city_code = AIRPORT_SERVICE_1.city_code AND CITY_1.city_name = 'BALTIMORE' AND flight.to_airport = AIRPORT_SERVICE_1.airport_code) AND CITY_0.city_code = AIRPORT_SERVICE_0.city_code AND CITY_0.city_name = 'DENVER' AND flight.from_airport = AIRPORT_SERVICE_0.airport_code