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