เที่ยวบินแรกสุดจากบอสตันไป BWI เที่ยวบินใดที่ให้บริการ LUNCHI ไม่จำเป็นต้องใช้ตารางทั้งหมด
what 's the earliest flight from BOSTON to BWI that serves LUNCHIt 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, airport_service, city, flight, food_service WHERE ((airport.airport_code = 'BWI' AND flight.to_airport = airport.airport_code AND food_service.meal_code = flight.meal_code AND food_service.meal_description = 'LUNCH') AND city.city_code = airport_service.city_code AND city.city_name = 'BOSTON' AND flight.from_airport = airport_service.airport_code) AND flight.departure_time = (SELECT MIN(FLIGHTalias1.departure_time) FROM airport AS AIRPORTalias1, airport_service AS AIRPORT_SERVICEalias1, city AS CITYalias1, flight AS FLIGHTalias1, food_service AS FOOD_SERVICEalias1 WHERE (AIRPORTalias1.airport_code = 'BWI' AND FLIGHTalias1.to_airport = AIRPORTalias1.airport_code AND FOOD_SERVICEalias1.meal_code = FLIGHTalias1.meal_code AND FOOD_SERVICEalias1.meal_description = 'LUNCH') AND CITYalias1.city_code = AIRPORT_SERVICEalias1.city_code AND CITYalias1.city_name = 'BOSTON' AND FLIGHTalias1.from_airport = AIRPORT_SERVICEalias1.airport_code)