In a real-world application this operation would support more complex modifications, including addition and deletion of order lines in the order.

Using queries as the target of a data change operation allows deletion or updates of rows determined by complex SQL including ORDER by.