You must display a salary increase of 10% for each employee plus their total compensation which includes their salary and commission. Some employees do not receive a commission
Review this SELECT statement:
SELECT sal * 1.10 "Salary", sal * 1.10 + comm "Total Compensation"
FROM emp;
What is the result of this statement?
(a) Only the new salary of all employees is displayed.
(b) The new salary and total compensation for each employee is displayed.
(c) A zero total compensation value is displayed for employees that do not receive a commission.
(d) The total compensation value is not displayed for employees that do not receive a commission.