SELECT
    agent_name,
    sum(chats_handled)                        AS chats,
    sum(chats_resolved)                       AS resolved,
    round(avg(avg_first_response_sec), 0)     AS avg_first_response_sec,
    round(avg(csat_avg), 2)                   AS csat,
    round(sum(available_minutes) / 60, 1)     AS available_hours
FROM fact_agent_daily
WHERE day >= today() - 7
GROUP BY agent_name
ORDER BY chats DESC

SELECT day, chats_handled, avg_first_response_sec, csat_avg
FROM fact_agent_daily
WHERE agent_id = {your_agent_id}
  AND day >= today() - 30
ORDER BY day