Database SQL:

You can download the table from this link:

https://drive.google.com/file/d/0B0kVn308bqFuZkFULTBSU1lzdEk/view?usp=sharing

1. For each of the local zip codes, and each of the candidates, show the number of contributions (if at least one contribution was made). Order by zip code and then number of contributions.

........................................

2. Who are the top 10 local contributors in terms of total amount contributed? Show the contributor names and the amount they spent.

........................................

3. Show date and amount for all contributions from 'BATTS, ERIC'. Order by amount, decreasing.

........................................

4. On average, how many contributions did each contributor make? Give a single number, rounded to one digit to the right of the decimal point.

........................................