1)The charity name, number of gifts (renamed to GIFTS), the total amount of gifts (renamed to TOTAL), smallest gift (renamed to SMALLEST), largest gift (renamed to LARGEST), and average gift size (renamed to AVERAGE). Order your results from the charity with the highest average gift size to the charity with the lowest average gift size.

2)Retrieve the charity name and the number of donations for any charity that has received more than three donations. Order your solution from the charity with the greatest number of donations to the charity with the least number of donations.

3)just the donations table columns for all those donations of $1000 or more made to Feed the Children or Habitat for Humanity.

4)The charity name, number of gifts (renamed to GIFTS), the total amount of gifts (renamed to TOTAL), smallest gift (renamed to SMALLEST), largest gift (renamed to LARGEST), and average gift size (renamed to AVERAGE). Order your results from the charity with the highest average gift size to the charity with the lowest average gift size.

 

Transcribed Image Text:

Donors PK DonorID Name Address HO City State Zip Phone Donations PK OFK2 DonorlD FK1 Charity GiftDate Amount DonationID -OH Charities PK Name Founded Phone Donors PK DonorID Name Address HO City State Zip Phone Donations PK OFK2 DonorlD FK1 Charity GiftDate Amount DonationID -OH Charities PK Name Founded Phone

Answer rating: 100% (QA)

1The charity name number of gifts renamed to GIFTS the total amount of gifts renamed to TOTAL smalle... View the full answer