แสดงเที่ยวบินทั้งหมดจากซานฟรานซิสโกไปยัง LGA ไม่หยุดหย่อน ไม่จำเป็นต้องใช้ตารางทั้งหมด
show me all flights from SAN FRANCISCO to LGA nonstopIt is not neccessary to use all the tables.
 dual_carrier:  main_airline [ varchar]  low_flight_number [ int]  high_flight_number [ int]  dual_airline [ varchar]  service_name [ text] 
SELECT DISTINCT flight.flight_id FROM airport, airport_service, city, flight WHERE (airport.airport_code = 'LGA' AND city.city_code = airport_service.city_code AND city.city_name = 'SAN FRANCISCO' AND flight.from_airport = airport_service.airport_code AND flight.to_airport = airport.airport_code) AND flight.stops = 0