The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?
A.No change is required to achieve the desired results.
B.SELECT ename, sal, 12*(sal+100) FROM emp;
C.SELECT ename, sal, (12*sal)+100 FROM emp;
D.SELECT ename, sal+100,*12 FROM emp;
Answer:B
The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?
A.No change is required to achieve the desired results. B.SELECT ename, sal, 12*(sal+100) FROM emp; C.SELECT ename, sal, (12*sal)+100 FROM emp; D.SELECT ename, sal+100,*12 FROM emp;