Inner and Left 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

  • easy

You have a customers table and an orders table, linked by a customer ID on each order. Explain the difference between an inner join and a left join between them, and which you'd use to list every customer with their order count, including those who have never ordered.

Talk this problem through with an AI coach

Sign in with Google to start a free voice session — no credit card needed.

Start free →