SQL Free Section Starter Challenge 30 min

5. Multi-Table INNER JOIN and LEFT JOIN

Overview: Combine related records across relational tables using INNER JOIN and LEFT JOIN with foreign key ON clauses.

Concept & Syntax Guide

Relational databases normalize data across multiple tables. An `INNER JOIN` returns rows where there is a match in both tables, allowing you to assemble enriched records like customers with their orders.

Hands-On Practice Exercise

Join Customers with Their Template Orders

Write an INNER JOIN query that selects customer name and order amount from customers joined with orders on customer_id.

Target Output: customers.name

Need a hint? Click here to reveal

Hint: Check syntax carefully and make sure your code contains: customers.name

SQL Code Editor

1
2
3
4
5
6
7
8
9
10

-- Query customers joined with orders
SELECT customers.name, orders.amount, orders.item_title
FROM customers
INNER JOIN orders ON customers.id = orders.customer_id
WHERE orders.status = 'completed';