Compute churn with re-subscriptions

Q: How do I practice SQL interview questions?

PracHub provides an interactive SQL console where you can write and test queries against real database schemas. Get instant feedback and compare your solution with the expected output.

Q: What difficulty level is this coding question?

This is a hard difficulty Data Manipulation (SQL/Python) question, commonly asked during Technical Screen rounds at OpenAI.

Q: What role is this question designed for?

This question is commonly asked for Data Scientist candidates at OpenAI during technical interviews.

Question

Compute churn with re-subscriptions

PracHub · Accepted Answer

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.

Quick Overview

Compute churn with re-subscriptions