SELECT
u.user_id,
CONCAT(u.first_name,' ',u.last_name) AS donor_name,
SUM(d.amount) AS total_donated
FROM Donations d
JOIN Users u ON d.donor_id = u.user_id
WHERE d.date >= DATE_SUB(CURDATE(), INTERVAL 1 YEAR)
GROUP BY u.user_id
ORDER BY total_donated DESC
LIMIT 10
| Donor ID | Name | Total Donated |
|---|---|---|
| 4 | Dan Donor | 580.00 |
| 5 | Eve Donor | 520.00 |