W3School TIY Editor

SELECT order_id, SUM(order_details.quantity * products.price) FROM order_details LEFT JOIN products on products.product_id = order_details.product_id GROUP BY order_id HAVING SUM(order_details.quantity * products.price) > 400.00;