Pantry Usage Heatmap by Day

SQL Query:


SELECT
  fp.pantry_name,
  DAYOFWEEK(fd.date) AS day_of_week,
  COUNT(fd.distribution_id) AS visits
FROM Food_Distributions fd
JOIN Food_Pantries fp ON fd.pantry_id = fp.pantry_id
WHERE fd.date >= DATE_SUB(CURDATE(),INTERVAL 30 DAY)
GROUP BY fp.pantry_name, DAYOFWEEK(fd.date)
ORDER BY fp.pantry_name, day_of_week

Executing query… 0s

Pantry Usage Heatmap by Day (Last 30 Days)