Self Joins

Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.

The problem

  • medium
  • Pro

An employees table stores each person's manager as another employee's ID. Explain how you'd list every employee alongside their manager's name, and what changes if you need the whole chain of managers up to the top.

Talk this problem through with an AI coach

This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.

Start free →