Snap·Data Scientist·Technical Phone Screen
- Using a user_events table, write a SQL query to compute 7-day retention (inclusive) for users whose first visit was on 2023-04-01.
- Write a SQL query returning the top 3 pages ranked by distinct purchasing users over the last month.
- Find the median number of daily events per active user in April 2023 using SQL.
- Given a Pandas DataFrame matching the user_events schema, write Python code to produce an hourly time-series of clicks per page for the past 24 hours.
“Went straight for a CTE to isolate first-visit users, then joined back on the same table filtering for events within 7 days.”