Question: use the following to develop sql database in the design above a. List the phone numbers of donors Hays and Jefts. b. How many donors
use the following to develop sql database in the design above
a. List the phone numbers of donors Hays and Jefts.
b. How many donors are there in the donor table?
c. How many people made donations in 1999?
d. What is the name of the person who made the largest donation in 1999?
e. What was the total amount donated in 2000?
f. List the donors who have made a donation every year.
g. List the donors whose average donation is more than twice the average donation of all donors.
h. List the total amount given by each person across all years; sort the report by the donors name.
i. Report the total donations in 2001 by state.
j. In which years did the total donated exceed the goal for the year?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
