SELECT
    poll_name,
    sum(sent) AS enviados,
    sum(delivered) AS entregues,
    sum(responded) AS respondidos,
    sum(to_agents) AS passaram_a_agente,
    round(sum(delivered) * 100.0 / nullIf(sum(sent), 0), 1) AS taxa_entrega_pct
FROM client_analytics.fact_deployment_daily
WHERE day >= today() - 14
GROUP BY poll_name
ORDER BY enviados DESC