SQL annual bonus salary challenge

Question

I am having trouble getting the $500 bonus to multiply by the number years. I keep getting the correct results as far as columns and I get an output but it’s only adding 500 to salary and creating the “total” string based on that. It’s not multiplying by number of years experience. Here has what I have:

SELECT CONCAT (firstname, ' ', lastname) AS fullname, salary + experience * 500 AS total FROM staff ORDER by total;

Answer 1

Karsa9Fingers

Here should be

(salary * 12) + 500 * experience

Answer 2

ok in reviewing it seems like the math is incorrect on the part of sololearns solution - anyone else encounger this?

Answer 3

I Am AJ !

just solved it with the following code:

SELECT CONCAT (firstname, ' ', lastname) AS fullname, salary*12+500*experience AS total FROM staff ORDER by total;

thank you kindly good sir.

Answer 4

ohhh so salary column is monthly? did i miss that in the instructions?

Answer 5

SELECT CONCAT (firstname, ' ' ,lastname) AS fullname,
(salary*12)+(experience*500) AS total
FROM staff
ORDER BY total ;

Answer 6

Karsa9Fingers jumping in here 2 months late because there was nothing on here that said this was a monthly salary. ive been stuck on this for like 15 minutes.