View the exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables. 

You want to update EMPLOYEES table as follows: ✑ Update only those employees who work in Boston or Seattle (locations 2900 and 2700). ✑ Set department_id for these employees to the department_id corresponding to London (location_id 2100). ✑ Set the employees` salary in location_id 2100 to 1.1 times the average salary of their department. ✑ Set the employees` commission in location_id 2100 to 1.5 times the average commission of their department. You issue the following command: 

What is outcome? 

Answer options:

A. It generates an error because multiple columns (SALARY, COMMISSION) cannot be specified together in an UPDATE statement.
B. It generates an error because a subquery cannot have a join condition in a UPDATE statement.
C. It executes successfully and gives the desired update
D. It executes successfully but does not give the desired update

D