New University Questions

1. What is the preferred payment method of all donors?
2. How many donors have a doctorate level of education
3. How many events have occurred at a given address
4. What is the average pledge of all donors?
5. Which graduation year has the largest amount of donors in the top donor circle
6. Which ZIP code has the highest amount of donors
7. Which ZIP code has pledged the highest amount?
8. Which year had the most events?
9. How much money did each event this year generate?
10. Who attended a given event?
11. What is the maximum price of a gift in the database currently?
12. What is the minimum price of a gift in the database currently?
13. What is the average amount of donations per year?
14. What was John Smith’s donation from the year 2000?
15. What are the names of people who did hot pay their pledge payment for January 2000?
16. What is the name and phone number of the class coordinator for the class of 1998?
17. Who attended the last fundraiser/event?
18. For how many years was Roy Jenkins in the Presidents Circle of the donor circle category?
19. When was the last time John Smith donated?
20. What is the address of Roy Jenkins’ classmate John Smith?
21. How much money was donated in January this year?
22. What is the average amount of money pledged?
23. Print out a list of all of the addresses of those who have donated?
24. Which graduation years have averaged of $100 per donor?
25. Which class coordinator’s graduation class has donated the most?
26. What is the average graduation year of each donor circle?
27. How many matching gift companies are there?
28. What is the average amount of money still owed from pledges?
29. How many pledges were received at the alumni event last year?
30. How many potential donors are there in the class of 2002?
31. What percentage of donations have been received in cash since 1950?
32. What percentage of donations have been received in cash in the past 12 months?
33. How many graduates from the class of (this year – 10) haven’t mae a pledge yetA?
34. What state has hosted the majority of fundraising events in the past 12 months?
35. What is the total amount of pledges that have been maid (paid or unpaid) in the past 12 months?
36. How many donors broke their pledge into multiple payments in 1990?
37. How many donors gave more than 100,000 in 1990?
38. What percentage of the donors in 1990 was from that year’s graduating class?
39. How many events were held in 1990?
40. How many potential donors have become actual donors since 1990?