แสดงเที่ยวบินเที่ยวเดียวจากแทมปาไปเซนต์ LOUIS ออกเดินทางก่อน 1,000 FIRST class ไม่จำเป็นต้องใช้ตารางทั้งหมด
show me one way flights from TAMPA to ST. LOUIS departing before 1000 FIRST classIt is not neccessary to use all the tables.
 month:  month_number [ int]  month_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, fare, fare_basis, flight, flight_fare WHERE (((fare.round_trip_required = 'NO') AND fare_basis.class_type = 'FIRST' AND fare.fare_basis_code = fare_basis.fare_basis_code AND flight_fare.fare_id = fare.fare_id AND flight.departure_time < 1000 AND flight.flight_id = flight_fare.flight_id) AND CITY_1.city_code = AIRPORT_SERVICE_1.city_code AND CITY_1.city_name = 'ST. LOUIS' AND flight.to_airport = AIRPORT_SERVICE_1.airport_code) AND CITY_0.city_code = AIRPORT_SERVICE_0.city_code AND CITY_0.city_name = 'TAMPA' AND flight.from_airport = AIRPORT_SERVICE_0.airport_code