SQL · Meta · Medium
You have two relations that record Oculus app activity: users and events. A UTC calendar date counts as an active day for a user when that user has at least one row in events with an event_time on that date. Only events whose UTC timestamp falls in the inclusive range 2025-07-01 through 2025-08-31 are considered. A user belongs to exactly one of these cohorts: social_only — every considered event for the user has category = 'social'. game_only — every considered event for…
Checking your access…