delete order query changed

query has been updated so the room/ row will not get deleted upon
deleting the order.