Sql Microsoft Access List Charter Trip Number Charter Distance Charter Flights Average Dis Q37298966

SQL – Microsoft Access

————————————————————————–

List the charter trip number and charter distance of allcharter flights of below average distance.

(Hint: This question needs a subquery, which is simple in thiscase: the condition for selecting the rows to display is: thoserows whose distance is lower than [a subquerywhich selects the average distance from the wholetable])

——————————————————————————

CHAR PLOT CHAR COPILOT AC NUMBER CHAR DESTINATION CHAR DISTANCE CHAR HOURS FLOWN CHAR HOURS AT CHAR FUEL GALLONS CHAR OL QTS CUS COOE

OR

 

OR