Which change must be made to the below syntax to calculate the annual compensation as monthly salary plus a monthly bonus of $100, multiplied by 12?
Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee.
I don’t know databases well, but this looks like the right equation to me. I would be inclined to agree with the previous answer, which suggests that no changes be made. So, I would tentatively say answer A is the correct answer.
The reason I say this is simply because I have no idea what any of the other options would do, and sometimes the best thing to do is leave it alone when you’re unsure of what’ll happen.
That said, I would suggest you all do your own research. Since I am not well-versed in this kind of equation, my answer is not as accurate as it could be or as accurate as I would like it to be, since the research was not easy to do.