ฉันต้องการเที่ยวบินในวันอังคาร ซึ่งออกเดินทางจากซานดิเอโกไปยังอินเดียนาโพลิส อินเดียนา และออกเดินทางช่วงบ่าย ไม่จำเป็นที่จะต้องใช้โต๊ะทั้งหมด
i would like a flight on tuesday which leaves from SAN DIEGO to INDIANAPOLIS INDIANA and that leaves in the afternoonIt 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 flight_id FROM flight WHERE (((flight_days IN (SELECT DAYSalias0.days_code FROM days AS DAYSalias0 WHERE DAYSalias0.day_name IN (SELECT DATE_DAYalias0.day_name FROM date_day AS DATE_DAYalias0 WHERE DATE_DAYalias0.day_number = 22 AND DATE_DAYalias0.month_number = 3 AND DATE_DAYalias0.year = 1991)) AND 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 = 'INDIANAPOLIS' AND CITYalias1.state_code IN (SELECT STATEalias0.state_code FROM state AS STATEalias0 WHERE STATEalias0.state_name = 'INDIANA'))))) AND 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 = 'SAN DIEGO'))) AND departure_time BETWEEN 1200 AND 1800)