Assignment 3

Aggregate Functions

Instructions

Read the following and write the SQL that would provide the data to answer the question. Turn in the SQL. For the following questions also turn in the answer.


1. How many persons are contained in the Person table?

2. What is the total amount of all donations?

3. What is the largest donation?

4. What is the smallest donation?

5. What is the average grant amount?

5. How many grants were given for service 2?.

6. What is the total amount of donations per month

7. How many grants did employee 3 work on?

8. What is the count of grants by month?

9. What is the total amount given for service 2?

10. List all the grants that are greater than the average grant amount.

an