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

SELECT
    conversation_id,
    min(created_at) AS first_agent_response
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