LISTING 1: Code to Return Rows 1–10

SELECT
	TOP 10
	o.OrderId,
	SUM(UnitPrice * Quantity) OrderAmount
FROM
	orders o inner  join [order details] od
		on o.OrderId = od.OrderId
GROUP BY
	o.OrderId
ORDER BY
	o.OrderAmount,
	o.OrderId