What is the outcome?

View the Exhibit and examine the structures of the employees and departments tables.

You want to update the 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 iocation_id 2100 to 1.1 times the average
salary of their department. -Set the employees’ commission in iocation_id 2100 to 1.5 times
the average commission of their department.
You issue the following command:

What is the outcome?

A.
It executes successfully and gives the correct result.

B.
It executes successfully but does not give the correct result.

C.
It generates an error because a subquery cannot have a join condition in an update
statement.

D.
It generates an error because multiple columns (SALARY, COMMISSION) cannot be
specified together in an update statement.