SELECT order_details.order_id, SUM(products.price)
FROM order_details
LEFT JOIN products ON order_details.product_id = products.product_id
GROUP BY order_id
HAVING SUM(products.price) > 400.00;
order_id | sum ----------+-------- 10360 | 460.34 11077 | 574.35 10372 | 413.30 (3 rows)
categories customers products orders order_details testproducts