SQL

Query product retention cohorts

A SQL preview for converting messy product analytics questions into trustworthy cohort queries.

Practice in the app
Scenario

Prompt preview

Given users, sessions, and subscription events, compute weekly retention by signup cohort.

Skills this rep trains

Cohort windowsDate truncationJoinsAggregationMetric 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.

Start a free rep