Snapchat Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Monitor Friend-Request System for Quality and Abuse
Friendship +--------------+-------------+---------------------+---------------------+ | requester_id | approver_id | request_ts | approval_ts...
Compute User Group Stories and Aggregate Story Engagement
user_story_engagement +---------+----------+------------+------------+-------+-------+ | user_id | story_id | story_type | created_at | views | likes ...
Compute User Retention and Analyze Event Data
user_events +---------+---------------------+------------+-------+ | user_id | event_time | event_type | page | +---------+-----------------...
Compute same-day acceptance metrics last week
Assume today is 2025-09-01; interpret 'last week' as 2025-08-25 through 2025-08-31 inclusive, using UTC dates. You have the following schema and sampl...
Compute CTR and metrics with pandas
Using pandas only, compute banner and story metrics. Assume today is 2025-09-01 and 'last 7 days' means 2025-08-26 to 2025-09-01 inclusive. You are gi...