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