Avisos a clientes

lo que veían         = no-reintentado
lo que ahora ven     = no-reintentado + reintentado
la subida            = reintentado / no-reintentado

SELECT account_id,
       count(*)                                                             AS messages,
       count(*) FILTER (WHERE retry_count > 0)                              AS were_retried,
       round(100.0 * count(*) FILTER (WHERE retry_count > 0)
             / nullif(count(*), 0), 1)                                      AS pct_of_traffic,
       round(100.0 * count(*) FILTER (WHERE retry_count > 0)
             / nullif(count(*) FILTER (WHERE retry_count = 0), 0), 1)       AS pct_count_rises,
       round(100.0 * COALESCE(sum(price) FILTER (WHERE retry_count > 0), 0)
             / nullif(sum(price) FILTER (WHERE retry_count = 0), 0), 1)     AS pct_spend_rises
  FROM cdr_submit
 WHERE part_no = 1 AND submitted_at >= now() - interval '30 days'
 GROUP BY account_id ORDER BY pct_count_rises DESC NULLS LAST;