SELECT
    agent_name,
    created_at,
    if(new_status, 'online', 'offline') AS estado
FROM client_analytics.fact_agent_status_changes
WHERE created_at >= today()
ORDER BY agent_name, created_at

SELECT
    agent_name,
    toDate(created_at) AS dia,
    round(sum(if(new_status = true,
        dateDiff('minute', created_at,
            leadInFrame(created_at) OVER (PARTITION BY agent_id ORDER BY created_at)
        ), 0)) / 60, 1) AS horas_online
FROM client_analytics.fact_agent_status_changes
WHERE created_at >= now() - INTERVAL 7 DAY
GROUP BY agent_name, dia
ORDER BY dia DESC, agent_name