Domanda di colloquio di Veedha Investimentos
Define primary key, foreign key, and unique key.
Risposta di colloquio
Anonimo
16 ago 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;