SELECT
    agent_name,
    count() AS mensagens_enviadas,
    countIf(category = 'hsm') AS templates_enviados
FROM client_analytics.fact_agent_messages
WHERE created_at >= now() - INTERVAL 7 DAY
  AND sender = 'AGENT'
GROUP BY agent_name
ORDER BY mensagens_enviadas DESC

SELECT
    conversation_id,
    min(created_at) AS primeira_resposta_agente
FROM client_analytics.fact_agent_messages
WHERE sender = 'AGENT'
  AND created_at >= now() - INTERVAL 7 DAY
GROUP BY conversation_id

SELECT
    created_at,
    sender,
    agent_name,
    category,
    content
FROM client_analytics.fact_agent_messages
WHERE conversation_id = 12345
ORDER BY created_at