How it works Skills Methodology Pricing Sign In / Up

← All patterns

Pattern

Recursive & hierarchical

5 problemsin this pattern, climbing easy → medium → hard. Pick wherever you're calibrated.

MD

Medium

0 / 2 solved

Each employee with their manager's name
SQL · ~7 min
NEW
Depth of each employee in the org tree
SQL · ~10 min
NEW

HD

Hard

0 / 3 solved

Everyone under a given manager
SQL · ~12 min
NEW
Build the path from root to each employee
SQL · ~13 min
NEW
Total reports (direct + indirect) per manager
SQL · ~14 min
NEW