SQL Database Question:

Political season is upon us. For this challenge, pretend that you are working for your candidate of choice, trying to help them determine which voters to spend the most time on fundraising.

Given the tables below, write a SQL query that returns:

• Name
• Date of most recent donation (if any)
• Political Party guess as: R, D, or U, where:
  • R = Likely Republican (more republican donations than other donations)
  • D = Likely Democrat (more democrat donations than other donations)
  • U = Undtermined (no donations on record, or R and D are tied for first place.
• Address

Tables:

• People
  • ID
  • Name
  • Address
• Donations
  • ID
  • People_ID
  • Donation_Date
  • Party (1 = Republican, -1 = Democrat)