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

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: Mar 29, 2024

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

Danny R. Glover

Danny R. Glover

Danny R. Glover
Danny R. Glover, Editor, New York City

Answered Jan 03, 2019

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.

upvote downvote
Reply 

kabirkhanna

kabirkhanna

kabirkhanna
Kabirkhanna

Answered Sep 19, 2017

No change is required to achieve the desired results.
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.