Homework 3 - SQL
No need to turn in this homework. We will go over the answers on Tuesday March 3 in preparation for Quiz 3.

Based on the following schema, use SQL to answer the queries below.

Donors(ssn,name,address,city,stateAbrev,phone)
Employees(ssn,name,salary,dob)
Donations(did,value,date,dnrssn,empssn)
Volunteers(did,what,when,where)
Articles(did,name,number,notes)
States(stateAbrev,name,donationTax)

Key: PrimaryKey ForeignKey

[Note that the "donationTax" attribute in States refers to the percentage that must be paid in taxes for donations coming from donors of that state]

1. List the names of donors that have made both volunteer, and article donations. 

2. List the names of employees that have never brought in any donations.

3. List the name and phone number of donors that have not made any donations since January 1st, 2008.

4. List the donor name, the what, and the when date for all volunteer donations that haven't occurred yet (when date is in the future, assume current_date is a function that gives you today's date).

5. For every donor, list their name, the total number of donations given, the total value of their donations, and the average value of their donations.

6. Similar to (4) above, but only take into account Article donations.

7. Similar to (4) and (5) above, but only take into account monetary donations. Remember that a monetary donation will not appear on either of the Articles or Volunteers relations.

8. List for every state the state abbreviation, the total value of donations that came in from that state, and the amount to pay in taxes to that state for donations that came in during 2008.