SQL
Query product retention cohorts
A SQL preview for converting messy product analytics questions into trustworthy cohort queries.
Scenario
Prompt preview
Given users, sessions, and subscription events, compute weekly retention by signup cohort.
Skills
Skills this rep trains
- Cohort windows
- Date truncation
- Joins
- Aggregation
- Metric explanation
Rubric preview
How FLOW will score the full answer
The public preview shows what good evidence looks like. The app scores your actual answer and stores the receipt.
Frame: defines retained, signup cohort, and time window before writing SQL.
Optimize: handles joins, duplicate sessions, and null subscription states.
Win: explains the result as a product decision, not just a table.
Follow-ups
Hatch-style coaching prompts
What counts as retained?
How do you handle users with multiple sessions?
How would you explain the result to a PM?
Locked workspace
What unlocks after sign in
Answer workspace with timers, notes, schema or code context where relevant.
Hatch follow-ups that adapt to your weak move instead of giving generic hints.
FLOW score receipts across Frame, List, Optimize, and Win.
Next-drill routing into the career goal you are training for.
Open the full workspace to answer, run, and get scored.
Public previews show the map. The app gives you reps, Hatch follow-ups, FLOW feedback, weak-move drills, and saved proof of progress.