MAT5335 Project 6 due Friday 3 March

1. Read Intro and Ch 1 from Weapons of Math Destruction.

The rest of the homework will involve the entire itcont.txt file in the MySQL server in the virtual desktop.  Recall this is the individual contributions 2015-2016 file.

Hillary Clinton's committee number is C00575795 and committee name is HILLARY FOR AMERICA
Donald Trump's committee number is C00580100 and committee name is DONALD J. TRUMP FOR PRESIDENT, INC.

2. Find the total amount donated for each candidate.  Restrict each query to the committee number.

3. Find the top ten donations for each candidate.  

4. Find the top ten professions that made the largest number of donations.  

5. Find the top ten professions that donated the most amount of money.

6a. How many distinct entities donated to each candidate?  
b. For each candidate, find the average per entity and list the (top) 25.
c. For each candidate, find the sum per entity and list the (top) 25.
d. Optional.  For each candidate, find the sum and average over all donations.

7. Restrict your data to employer EASTERN ILLINOIS UNIVERSITY.  How many total donations were there?  Per individual, how many donations did they make?  What was the sum per person?  

8. For each zip code, find the sum for each candidate.  This can be done in two queries.
Zip codes: 62033, 62428, 60181, 62510, 62447, 61920, 60611.

9. Recall in itcont, NAME=LAST, FIRST, and then possibly a middle initial.  For this problem, use regexp.
a. Find people whose name has two or more z's.
b. Find people whose name has a q but not followed by a u.
c. Find people that have double consecutive vowels.

10. The last debate occurred October 19, 2016 and the election was on November 8, 2016.  Find the amount donated to each candidate, from (including) Oct 19 to Nov 7.