SELECT
    agent_name,
    sum(chats_handled) AS total_chats,
    sum(messages_sent) AS total_messages,
    round(avg(avg_first_response_sec), 0) AS first_response_sec,
    round(avg(service_level_pct) * 100, 1) AS service_level_pct,
    round(sum(available_minutes) / 60, 1) AS available_hours
FROM client_analytics.fact_agent_daily
WHERE day >= today() - 7
GROUP BY agent_name
ORDER BY total_chats DESC

SELECT
    at.team_name,
    sum(ad.chats_handled) AS total_chats,
    round(avg(ad.csat_avg), 2) AS avg_csat
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 total_chats DESC