SELECT
    hsm_name,
    count() AS total_respostas,
    count(DISTINCT survey_user_id) AS usuarios_unicos
FROM client_analytics.fact_hsm_responses
WHERE response_date >= now() - INTERVAL 30 DAY
GROUP BY hsm_name
ORDER BY total_respostas DESC

SELECT
    response_date,
    cellphone,
    answer_text
FROM client_analytics.fact_hsm_responses
WHERE hsm_name = 'meu_template'
  AND response_date >= now() - INTERVAL 7 DAY
ORDER BY response_date DESC
LIMIT 100