Meta·Data Scientist·Technical Phone Screen
- Given session-level data, compare engagement between users who exclusively used the 'social' category versus those who exclusively used the 'game' category over a fixed 28-day window. Define two mutually exclusive cohorts, exclude mixed-category users and anyone with neither category, then compute per cohort: user count, median active days, share of users active 10+ days, and average minutes per active day. Write a single SQL query handling nulls and non-positive durations.
“This one took me a while to even parse correctly.”