Inner Join Orders and Customers | Dataford Interview Questions

Given two tables, Orders and Customers, write a query using an inner join to list all orders along with customer names.

Use the provided tables and return only orders with a matching customer. Sort the results by order ID in ascending order.

Output

One row per matched order.
Columns: order_id, order_date, customer_id, order_total, and customer_name.
Exclude orders without a matching customer and sort by order_id ascending.

orders

Column	Type	Description
order_idPK	INT	Unique identifier for the order
order_date	DATE	Date the order was placed
customer_id	INT	Customer associated with the order
order_total	DECIMAL(10,2)	Total value of the order

customers

Column	Type	Description
customer_idPK	INT	Unique identifier for the customer
customer_name	VARCHAR(100)	Customer's full name

Your question is Inner Join Orders and Customers. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.