Veedha Investimentos interview question
Define primary key, foreign key, and unique key.
Interview Answer
Anonymous
16 Aug 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;