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

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