Which vendors are you late paying — and by how much?

SELECT
  v.display_name                                     AS vendor,
  COUNT(b.id)                                       AS open_bills,
  ROUND(SUM(b.balance)::numeric, 2)                AS total_owed,
  MAX(CURRENT_DATE - b.due_date::date)             AS max_days_overdue,
  MIN(b.due_date::date)                            AS oldest_due_date,
  ROUND(AVG(b.balance)::numeric, 2)                AS avg_bill_balance,
  SUM(CASE WHEN CURRENT_DATE - b.due_date::date <= 30 THEN b.balance ELSE 0 END)::numeric AS overdue_0_30,
  SUM(CASE WHEN CURRENT_DATE - b.due_date::date BETWEEN 31 AND 60 THEN b.balance ELSE 0 END)::numeric AS overdue_31_60,
  SUM(CASE WHEN CURRENT_DATE - b.due_date::date BETWEEN 61 AND 90 THEN b.balance ELSE 0 END)::numeric AS overdue_61_90,
  SUM(CASE WHEN CURRENT_DATE - b.due_date::date > 90 THEN b.balance ELSE 0 END)::numeric AS overdue_90_plus
FROM qbo_bills b
JOIN qbo_vendors v ON v.id = b.vendor_id
WHERE b.balance > 0
  AND b.due_date::date < CURRENT_DATE
GROUP BY v.id, v.display_name
ORDER BY total_owed DESC