Pergunta de entrevista da empresa Veedha Investimentos
Define primary key, foreign key, and unique key.
Resposta da entrevista
Sigiloso
16 de ago. de 2025
SELECT event_date, COUNT(DISTINCT user_id) AS daily_active_users FROM user_events WHERE event_date >= CURRENT_DATE - INTERVAL '30 days' GROUP BY event_date ORDER BY event_date;