几个SELECT语句的题目 求助.. 完整的最佳答案160分答:1.找出座位数在100以上的航班(Aircraft, Noseats), 请列出其航班号(Flight, FlightNo), 飞机型号描述(Aircraft, Adescription), 起飞机场(Flight, FromAirport)及目的地机场(Flight,ToAirport)答:select flightono,aircrafttype,fromairport,toairport from flight where AircraftType in (select aircraft...