Stabilize recursive org chart
Medium SQL arena: recursive CTEs, depth limits, and cycle safety
Log in and clear the lower tiers to unlock this mission.
Missing prerequisites: sql-easy-recursive-cte
HR imported a reporting tree and one accidental cycle is breaking the org browser. You are working inside an analytics warehouse, and the arena only clears when the result is safe, deterministic, and explainable.
Learn to apply recursive CTEs, depth limits, and cycle safety in an analytics warehouse while explaining the invariant, safety constraints, and hidden edge cases.
- Demonstrates recursive CTEs, depth limits, and cycle safety
- 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