17. The address of a vendor, Comfort Road Bicycles, has changed. You need to update the data, as shown in the following table, in the AdventureWorks database.

Update purchasing.VendorAddress
set AddressID=(select Address from Person,Address where AddressLinel='4151 Olivera'
and City='Atlanta')
from Purchasing.VendorAddress va,Purchasing.Vendor v
where va.VendorID=v.VendorID and
v.Name='Confort Road Bicycles'