Verify Order Totals with SQL | Dataford Interview Questions

Given a database schema for an e-commerce platform, write a SQL query to verify that order totals match the sum of individual line items. Return every order, including orders without line items, and identify whether its stored total matches the calculated amount.

Output

One row per order with order_id, order_total, line_items_total, difference, and verification_status
Use MATCH or MISMATCH for the verification status
Sort by order_id ascending

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
order_total	NUMERIC(10,2)	Stored total amount for the order
order_status	VARCHAR(20)	Current order status

order_items

Column	Type	Description
order_item_idPK	INT	Unique line item identifier
order_id	INT	Order containing the line item
product_name	VARCHAR(100)	Product name
quantity	INT	Number of units purchased
unit_price	NUMERIC(10,2)	Price per unit

Your question is Verify Order Totals with SQL. 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.

Problem