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)