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 locationid 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?
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