Donation Source Diversity

SQL Query:


SELECT
  fp.pantry_name,
  COUNT(DISTINCT d.donor_id) AS unique_donors,
  COUNT(d.donation_id)       AS total_donations,
  COUNT(d.donation_id)/GREATEST(COUNT(DISTINCT d.donor_id),1) AS avg_per_donor
FROM Donations d
JOIN Food_Pantries fp ON d.pantry_id = fp.pantry_id
WHERE d.date >= DATE_SUB(CURDATE(), INTERVAL 1 YEAR)
GROUP BY fp.pantry_id
ORDER BY unique_donors DESC

Executing query… 0s

Pantry	Unique Donors	Total Donations	Avg per Donor
Downtown Pantry TEST	2	2	1.0
West End Pantry	1	1	1.0
Eastside Pantry	1	2	2.0

Donation Source Diversity by Pantry