试题详情
单项选择题 Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; 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;

  • 关注下方微信公众号，在线模考后查看

热门试题