Compute churn with re-subscriptions
Company: OpenAI
Role: Data Scientist
Category: Data Manipulation (SQL/Python)
Difficulty: hard
Interview Round: Technical Screen
Overview: This question evaluates proficiency in event-time data manipulation, temporal aggregation, and subscription-state logic for computing conversion and retention metrics using SQL or Python; it falls under the Data Manipulation (SQL/Python) domain and targets practical application rather than pure conceptual theory.
Read the full OpenAI Data Scientist interview experience this question came from