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.