SELECT
    poll_name,
    count() AS enviados,
    countIf(timestamp_delivered > '2000-01-01') AS entregues,
    countIf(timestamp_responded > '2000-01-01') AS respondidos,
    round(countIf(timestamp_delivered > '2000-01-01') * 100.0 / count(), 1) AS taxa_entrega_pct,
    round(countIf(timestamp_responded > '2000-01-01') * 100.0
        / nullIf(countIf(timestamp_delivered > '2000-01-01'), 0), 1) AS taxa_resposta_pct
FROM client_analytics.fact_deployment_status
WHERE timestamps_eta >= now() - INTERVAL 30 DAY
GROUP BY poll_name
ORDER BY enviados DESC