แสดงเที่ยวบินจากเซนต์ปีเตอร์สเบิร์ก จาก PETERSBURG ถึง TORONTO ที่มาถึงก่อน 12.00 น. ไม่จำเป็นต้องใช้ตารางทั้งหมด
show me the flights from ST. PETERSBURG to TORONTO that arrive before 1200It is not neccessary to use all the tables.
 flight:  aircraft_code_sequence [ text]  airline_code [ varchar]  airline_flight [ text]  arrival_time [ int]  connections [ int]  departure_time [ int]  dual_carrier [ text]  flight_days [ text]  flight_id [ int]  flight_number [ int]  from_airport [ varchar]  meal_code [ text]  stops [ int]  time_elapsed [ int]  to_airport [ varchar] 
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, flight WHERE (CITY_1.city_code = AIRPORT_SERVICE_1.city_code AND CITY_1.city_name = 'TORONTO' AND flight.arrival_time <= 1200 AND flight.to_airport = AIRPORT_SERVICE_1.airport_code) AND CITY_0.city_code = AIRPORT_SERVICE_0.city_code AND CITY_0.city_name = 'ST. PETERSBURG' AND flight.from_airport = AIRPORT_SERVICE_0.airport_code