Calculate Average Camera Switches per Session
Company: Snapchat
Role: Data Scientist
Category: Data Manipulation (SQL/Python)
Difficulty: medium
Interview Round: Technical Screen
Overview: Calculate average front-to-rear camera switches per session in PostgreSQL. Use LAG, preserve one-event sessions in the denominator, and avoid integer-division errors.
Read the full Snapchat Data Scientist interview experience this question came from