SELECT
    toDate(created_at) AS dia,
    inbound_outbound,
    count() AS total,
    countIf(is_valid) AS validos
FROM client_analytics.fact_sessions
WHERE created_at >= now() - INTERVAL 30 DAY
GROUP BY dia, inbound_outbound
ORDER BY dia DESC

SELECT
    poll_name,
    inbound_outbound,
    count() AS fluxos,
    countIf(status = 'HumanHandover') AS passaram_a_agente
FROM client_analytics.fact_sessions
WHERE created_at >= now() - INTERVAL 30 DAY
GROUP BY poll_name, inbound_outbound
ORDER BY fluxos DESC
LIMIT 20