SQL · Meta · Medium
Two tables are provided. The first, user_activity, stores one row per user for each day they appear in the activity log, with columns user_id, activity_date, country, and dau_flag. A dau_flag of 1 marks the user as a daily active user on that date. The second table, composer, stores event records with columns user_id, event, and event_date. The event column can be either 'enter', 'post', or 'cancel'. For the fixed date '2025-09-01', a Daily Active User (DAU) is any user_id…
Checking your access…