Pending Requests Older Than 7 Days
SQL Query:
SELECT
fp.pantry_name,
rl.request_id,
b.first_name,
b.last_name,
rl.request_date,
DATEDIFF(CURDATE(), rl.request_date) AS days_outstanding
FROM Request_Log rl
JOIN Food_Pantries fp ON rl.pantry_id = fp.pantry_id
JOIN Beneficiaries b ON rl.beneficiary_id = b.beneficiary_id
WHERE rl.status = 'Pending'
AND rl.request_date < DATE_SUB(CURDATE(), INTERVAL 7 DAY)
ORDER BY days_outstanding DESC
Executing query… 0s
| Pantry | Request ID | Beneficiary | Request Date | Days Outstanding |
|---|
| Downtown Pantry TEST |
301 |
Samantha Sims |
2025-04-09 |
83 |