← All practice problems

Flatten the order model into a line-grain report

foundation · sql🔒Walkthroughs

NEW

Flatten the order model into a line-grain report

Produce a fully denormalized report at order-line grain: one row per order item, with the customer and product attributes joined in.

Columns: order_id, customer_name (the customer's full_name), country, product_id, category, qty, line_revenue (qty * unit_price). Sort by order_id, then product_id.

Tables & sample data

orders

Loading preview…

customers

Loading preview…

order_items

Loading preview…

products

Loading preview…

query.sql

Loading…

Loading editor…