ค่าโดยสารที่ถูกที่สุดจาก WASHINGTON ไปยัง SALT LAKE CITY คืออะไรไม่จำเป็นต้องใช้ตารางทั้งหมด
what are the lowest fares from WASHINGTON to SALT LAKE CITYIt is not neccessary to use all the tables.
 airport:  airport_code [ varchar]  airport_name [ text]  airport_location [ text]  state_code [ varchar]  country_name [ varchar]  time_zone_code [ varchar]  minimum_connect_time [ int] 
SELECT DISTINCT fare_id FROM fare WHERE (fare_id IN (SELECT FLIGHT_FAREalias1.fare_id FROM flight_fare AS FLIGHT_FAREalias1 WHERE FLIGHT_FAREalias1.flight_id IN (SELECT FLIGHTalias1.flight_id FROM flight AS FLIGHTalias1 WHERE (FLIGHTalias1.from_airport IN (SELECT AIRPORT_SERVICEalias2.airport_code FROM airport_service AS AIRPORT_SERVICEalias2 WHERE AIRPORT_SERVICEalias2.city_code IN (SELECT CITYalias2.city_code FROM city AS CITYalias2 WHERE (CITYalias2.city_name = 'WASHINGTON' AND CITYalias2.state_code = 'DC'))) AND FLIGHTalias1.to_airport IN (SELECT AIRPORT_SERVICEalias3.airport_code FROM airport_service AS AIRPORT_SERVICEalias3 WHERE AIRPORT_SERVICEalias3.city_code IN (SELECT CITYalias3.city_code FROM city AS CITYalias3 WHERE CITYalias3.city_name = 'SALT LAKE CITY'))))) AND one_direction_cost = (SELECT MIN(FAREalias1.one_direction_cost) FROM fare AS FAREalias1 WHERE FAREalias1.fare_id IN (SELECT FLIGHT_FARE_ID FROM flight_fare AS FLIGHT_FARE WHERE FLIGHT_FLIGHT_ID IN (SELECT FLIGHTalias0.flight_id FROM flight AS FLIGHTalias0 WHERE (FLIGHTalias0.from_airport IN (SELECT AIRPORT_SERVICEalias0.airport_code FROM airport_service AS AIRPORT_SERVICEalias0 WHERE AIRPORT_SERVICEalias0.city_code IN (SELECT CITYalias0.city_code FROM city AS CITYalias0 WHERE (CITYalias0.city_name = 'WASHINGTON' AND CITYalias0.state_code = 'DC'))) AND FLIGHTalias0.to_airport IN (SELECT AIRPORT_SERVICEalias1.airport_code FROM airport_service AS AIRPORT_SERVICEalias1 WHERE AIRPORT_SERVICEalias1.city_code IN (SELECT CITYalias1.city_code FROM city AS CITYalias1 WHERE CITYalias1.city_name = 'SALT LAKE CITY')))))))