Regarding practise question 'Annual bonuses ' in sql. Would like to know how to resolve the same using "Where" condition?

Question

The code with which I got the correct result:
SELECT CONCAT (firstname, ' ' ,lastname) AS fullname ,salary*12+(experience*500) as total FROM staff ORDER BY total

I tried using
SELECT CONCAT (firstname, ' ' ,lastname) AS fullname ,salary as total FROM staff WHERE salary= salary*12+(experience*500) ORDER BY total; got an error at the where statement

Answer 1

I can't see the specific issue, though I do know WHERE can be quite picky about what it accepts, I do notice that your SQL will return the original value for salary, whereas there's returns a modified value, so even had it not errored it still wouldn't have been correct