Home / SQL / Practice problems / Medium

Orders with customer names

Medium

Show order_id, order_date and the customer's name for every order.

Tables: customers(customer_id, name, city, country, joined) · products(product_id, name, category, price) · orders(order_id, customer_id, order_date, status) · order_items(order_id, product_id, quantity, unit_price)

Your query
Show the expected result
order_idorder_datename
12025-06-10Aarav Sharma
22025-05-17Aarav Sharma
32025-03-25Aarav Sharma
42025-10-26Aarav Sharma
52025-02-27Aarav Sharma
62025-12-10Mia Chen
72025-08-02Liam Walker
82025-07-28Liam Walker
92025-07-12Sita Gurung
102025-10-06Sita Gurung
112025-06-05Sita Gurung
122025-07-13Sita Gurung
132025-08-06Sita Gurung
142025-10-05Priya Patel
152025-04-20Olivia Smith
162025-08-16Bikash Thapa
172025-03-17Ava Wilson
182025-12-18Ava Wilson
192025-11-28Ava Wilson
202025-03-12Ava Wilson
212025-04-26Ethan Nguyen
222025-08-12Ethan Nguyen
232025-12-20Isla Taylor
242025-04-16Isla Taylor
252025-10-27Isla Taylor

51 rows (showing 25)

Show a solution
SELECT o.order_id, o.order_date, c.name FROM orders o JOIN customers c ON c.customer_id = o.customer_id;

SQL used

New to SQL? The free SQL course teaches everything these problems use, with a self-checking exercise in every lesson.