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.