SQL · Meta · Medium
Given two tables users and sessions, compare engagement between users who exclusively performed social activities and users who exclusively performed game activities during a fixed 28-day analysis window from 2025-09-08 through 2025-10-05 inclusive, based on the date part of session_start. Define two mutually exclusive cohorts after applying data-quality rules: social_only: the user has at least one valid social session and zero valid game sessions in the window. game_only:…
Checking your access…