Stabilize retention cohort matrix
Medium SQL arena: date bucketing, joins, and cohort aggregation
Log in and clear the lower tiers to unlock this mission.
Missing prerequisites: sql-easy-retention-cohorts
Product wants week-one and week-four retention without double counting returning users. You are working inside an analytics warehouse, and the arena only clears when the result is safe, deterministic, and explainable.
Learn to apply date bucketing, joins, and cohort aggregation in an analytics warehouse while explaining the invariant, safety constraints, and hidden edge cases.
- Demonstrates date bucketing, joins, and cohort aggregation
- Handles the visible sample and hidden edge cases
- Keeps output deterministic and explainable
- Stays read-only
Clear the route first
You can read the mission brief, but the editor, hints, tests, and submit flow stay locked until progression or plan access catches up.
Test Results
Run the visible checks when your first pass is ready.
Clear Protocol
Rewards
Mission Route
Hints
Hints are metered and logged for No Hint Hero runs.
Genie Mentor Core
Hint protocol / contextual guardrails active