SELECT
    poll_name,
    count() AS sent,
    countIf(timestamp_delivered > '2000-01-01') AS delivered,
    countIf(timestamp_responded > '2000-01-01') AS responded,
    round(countIf(timestamp_delivered > '2000-01-01') * 100.0 / count(), 1) AS delivery_rate_pct,
    round(countIf(timestamp_responded > '2000-01-01') * 100.0
        / nullIf(countIf(timestamp_delivered > '2000-01-01'), 0), 1) AS response_rate_pct
FROM client_analytics.fact_deployment_status
WHERE timestamps_eta >= now() - INTERVAL 30 DAY
GROUP BY poll_name
ORDER BY sent DESC