Count Users Whose First Daily Event Is App Launch
Company: Snapchat
Role: Data Scientist
Category: Data Manipulation (SQL/Python)
Difficulty: medium
Interview Round: Technical Screen
Overview: Write PostgreSQL to count users whose first event of each day is an app launch, grouped by operating system and device. Practice deterministic window ranking and date-level aggregation.
Read the full Snapchat Data Scientist interview experience this question came from