Netflix·Data Scientist·Technical Phone Screen
- Given a transaction table, write a SQL query that returns each user's first transaction date and the count of transactions they made within 7 days of that first purchase.
- Write a SQL query that computes the overall Day-7 retention rate across all users.
- Write a Python function that takes a list of n integers and returns the two numbers whose sum is closest to zero. Assume the list has at least two elements.
“Used a window function to get the first date per user, then joined back on the same table filtering where the date difference was within 7 days.”