Which change must be made to the below syntax to calculate the annual - ProProfs Discuss

# 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.

Asked by Kabirkhanna, Last updated: May 03, 2023

#### Danny R. Glover

Danny R. Glover, Editor, New York City

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.

#### kabirkhanna

Kabirkhanna

No change is required to achieve the desired results.