SQL · Meta · Medium
Given the tables users, events, and calls, compute the share of French daily active users (DAU) on 2025-08-31 (UTC) who took part in at least one video call on that same day. Definitions: A user is French when users.country_code = 'FR'. A user is a DAU for 2025-08-31 if they appear at least once in events with event_ts inside the half-open interval $$[2025-08-31 00:00:00, 2025-09-01 00:00:00)$$ UTC. A user took part in a video call if they appear as either caller_id or…
Checking your access…