Find Customers With Their Orders
Easy
joins
Amazon
Google
Stripe
You have two tables: customers and orders. Return each order alongside the customer's name.
Expected Output
| order_id | name | amount |
|---|---|---|
| 101 | Alice | 50.0 |
| 102 | Bob | 75.0 |
| 103 | Alice | 30.0 |
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...