Compute total revenue per order (sum of quantity × unit_price). Columns: id, revenue. Order by id.

Answer

SELECT o.id, SUM(oi.quantity * oi.unit_price) AS revenue FROM orders o JOIN order_items oi ON oi.order_id = o.id GROUP BY o.id ORDER BY o.id;