SQL HOMEWORK USING MICROSOFT ACCESS

. Report the minimum and maximum yield for each nation AND Report the nations where the average yield of the shares exceeds the average yield of all shares

FirmsCode FirmsName FC Quantity Dividend PE NationID Click to Add Freedonia Coo Patagonian Tea Abyssinian Rub Sri Lankan Golo Indian Lead an Burmese Eleph Bolivian Sheep Nigerian Geese Canadian Suagi Royal Ostric Fa Minnesota Gol Georigia Peach Narembeen En Queensland Di Indoorplly Rub Bombay Duck 27.5 55.25 31.82 50.37 37.75 0.07 12.75 35 52.78 33.75 53.67 2.35 12.34 6.73 15.92 25.55 55.25 12635 22010 32868 63 154713 231678 12323 4716 1.84 10 13 16 12 1.3 2.68 AR SLG ILZ BE BS NG CS ROF MG GP NE 0.01 1.78 1.68 10 15 1234923 816 25 2 387333 45619 89251 5614 167382 20 20 12 0.5 IR BD 0.5 4 FirmsCode FirmsName FC Quantity Dividend PE NationID Click to Add Freedonia Coo Patagonian Tea Abyssinian Rub Sri Lankan Golo Indian Lead an Burmese Eleph Bolivian Sheep Nigerian Geese Canadian Suagi Royal Ostric Fa Minnesota Gol Georigia Peach Narembeen En Queensland Di Indoorplly Rub Bombay Duck 27.5 55.25 31.82 50.37 37.75 0.07 12.75 35 52.78 33.75 53.67 2.35 12.34 6.73 15.92 25.55 55.25 12635 22010 32868 63 154713 231678 12323 4716 1.84 10 13 16 12 1.3 2.68 AR SLG ILZ BE BS NG CS ROF MG GP NE 0.01 1.78 1.68 10 15 1234923 816 25 2 387333 45619 89251 5614 167382 20 20 12 0.5 IR BD 0.5 4