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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!