SELECT
    agent_name,
    sum(chats_handled) AS chats_totais,
    sum(messages_sent) AS mensagens_totais,
    round(avg(avg_first_response_sec), 0) AS primeira_resposta_seg,
    round(avg(service_level_pct) * 100, 1) AS nivel_servico_pct,
    round(sum(available_minutes) / 60, 1) AS horas_disponivel
FROM client_analytics.fact_agent_daily
WHERE day >= today() - 7
GROUP BY agent_name
ORDER BY chats_totais DESC

SELECT
    at.team_name,
    sum(ad.chats_handled) AS chats_totais,
    round(avg(ad.csat_avg), 2) AS csat_medio
FROM client_analytics.fact_agent_daily ad
INNER JOIN client_analytics.dim_agent_tags at ON at.agent_id = ad.agent_id
WHERE ad.day >= today() - 30
GROUP BY at.team_name
ORDER BY chats_totais DESC