SELECT
b.beneficiary_id,
CONCAT(b.first_name,' ',b.last_name) AS beneficiary_name,
COUNT(fd.distribution_id) AS visits
FROM Food_Distributions fd
JOIN Beneficiaries b ON fd.beneficiary_id = b.beneficiary_id
WHERE fd.date >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)
GROUP BY b.beneficiary_id
ORDER BY visits DESC
LIMIT 10
| Beneficiary ID | Name | Visits |
|---|