Meussdorffer

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')