reforestation_query.sql

SELECT
  'letter' AS resource,
  CASE
    WHEN size = 'A5' THEN '5.8x8.3'
    ELSE size
  END AS size,
  COUNT(*) AS page_count
FROM lob.letters l
WHERE
  l.send_date >= date_trunc('month', current_date - interval '1 month')
  AND l.send_date < date_trunc('month', current_date)
GROUP BY 1, 2

UNION ...

-- similar queries for other types of mailpieces below