SELECT
	Orders.id,
	(Sum(OrderItems.price) + SUM(Orders.shipping_amount)) AS amount
FROM
	Orders
INNER JOIN
	OrderItems ON
		Orders.id=OrderItems.order_id
WHERE
	Orders.date < 'June 1, 2003'
GROUP BY
	Orders.id
ORDER BY
	Orders.id DESC