UPDATE "Order"
SET room_number=(SELECT "Room".room_number
                 FROM public."Room"
                 WHERE "Room".room_number=cast(? AS INT)),
status_id=(SELECT "Order_status".status_id
           FROM public."Order_status"
           WHERE "Order_status".order_status_en='confirmed'),
full_cost=coalesce((((SELECT "Order".check_out
                      FROM public."Order"
                      WHERE "Order".order_id=cast(? AS INT)) -

                     (SELECT "Order".check_in
                      FROM public."Order"
                      WHERE "Order".order_id=cast(? AS INT))) *

                     (SELECT "Room".room_price
                      FROM public."Room"
                      WHERE "Room".room_number=cast(? AS INT))), full_cost)
WHERE exists(SELECT 1 FROM public."Room" WHERE "Room".room_number=cast(? AS INT))
AND "Order".order_id=cast(? AS INT) AND "Order".status_id=(SELECT "Order_status".status_id
                                                           FROM public."Order_status"
                                                           WHERE "Order_status".order_status_en='unconfirmed');