10. There is a change in the production process of the bicycle with the product model ID 7. Due to this change, the bicycle will not be going to work center 10. You need to update this change in the database. How will you perform this task?

With
XMLNamespaces('http://schemas.microsoft.com/sqlserver/2004/07/adventure-work/productModelManulnstructions'
as pd)
Update Production.ProductModel SET
Instructions.modify('delete (/pd:root/pd:Location)[1]')
where ProductModelID = 7