ค่าโดยสารที่ถูกที่สุดจากแอตแลนต้าไปซานฟรานซิสโกบนเที่ยวบิน DL 82 และ DL 139 คือเท่าใด ไม่จำเป็นต้องใช้ตารางทั้งหมด
what is the lowest price fare from ATLANTA to SAN FRANCISCO on flight DL 82 and DL 139It is not neccessary to use all the tables.
 city:  city_code [ varchar]  city_name [ varchar]  state_code [ varchar]  country_name [ varchar]  time_zone_code [ varchar] 
SELECT DISTINCT fare.fare_id FROM airport_service AS AIRPORT_SERVICE_0, airport_service AS AIRPORT_SERVICE_1, city AS CITY_0, city AS CITY_1, fare, flight AS FLIGHT_0, flight AS FLIGHT_1, flight_fare, flight_leg WHERE ((FLIGHT_1.flight_number = 139 OR FLIGHT_1.flight_number = 82) AND CITY_1.city_code = AIRPORT_SERVICE_1.city_code AND CITY_1.city_name = 'SAN FRANCISCO' AND FLIGHT_0.flight_id = flight_leg.flight_id AND FLIGHT_0.to_airport = AIRPORT_SERVICE_1.airport_code AND FLIGHT_1.airline_code = 'DL' AND FLIGHT_1.flight_id = flight_leg.leg_flight) AND CITY_0.city_code = AIRPORT_SERVICE_0.city_code AND CITY_0.city_name = 'ATLANTA' AND fare.one_direction_cost = (SELECT MIN(FAREalias1.one_direction_cost) FROM airport_service AS AIRPORT_SERVICEalias2, airport_service AS AIRPORT_SERVICEalias3, city AS CITYalias2, city AS CITYalias3, fare AS FAREalias1, flight AS FLIGHTalias2, flight AS FLIGHTalias3, flight_fare AS FLIGHT_FAREalias1, flight_leg AS FLIGHT_LEGalias1 WHERE ((FLIGHTalias3.flight_number = 139 OR FLIGHTalias3.flight_number = 82) AND CITYalias3.city_code = AIRPORT_SERVICEalias3.city_code AND CITYalias3.city_name = 'SAN FRANCISCO' AND FLIGHTalias2.flight_id = FLIGHT_LEGalias1.flight_id AND FLIGHTalias2.to_airport = AIRPORT_SERVICEalias3.airport_code AND FLIGHTalias3.airline_code = 'DL' AND FLIGHTalias3.flight_id = FLIGHT_LEGalias1.leg_flight) AND CITYalias2.city_code = AIRPORT_SERVICEalias2.city_code AND CITYalias2.city_name = 'ATLANTA' AND FLIGHT_FAREalias1.fare_id = FAREalias1.fare_id AND FLIGHTalias2.flight_id = FLIGHT_FAREalias1.flight_id AND FLIGHTalias2.from_airport = AIRPORT_SERVICEalias2.airport_code) AND flight_fare.fare_id = fare.fare_id AND FLIGHT_0.flight_id = flight_fare.flight_id AND FLIGHT_0.from_airport = AIRPORT_SERVICE_0.airport_code