Stuck on the AS Keyword Practice Problem (Code Coach) - Please Help

Question

The salary numbers (salary + bonus) listed in the expected output does not match what I calculated on paper. Can someone confirm for me that the expected salary output matches with what the question asked?

Answer 1

Nvm ! Fixed it

Answer 2

hey its wrong this should work —
select CONCAT (firstname, ‘ ‘, lastname) as fullname; (salary*12)+(experience*500) as total from staff order by total;

Answer 3

✅ Correct Answer

SELECT CONCAT
(firstname,' ',lastname) AS fullname, (salary*12)+(experience*500) AS total

FROM staff

ORDER BY total;

Answer 4

Here is a picture of the question. https://share.icloud.com/photos/09jQPzs1G1JHW25ZFfPy7hwgA

Answer 5

Here is my code.

SELECT CONCAT
(firstname,' '.lastname) AS fullname

SELECT
salary+(experience*500) AS total

FROM staff

ORDER BY total;

Answer 6

select CONCAT (firstname,' ',lastname) as fullname, (salary*12)+(experience*500) as total from staff order by total;

for anyone who struggled like me

Answer 7

LOL! Coding late at night leads to carelessness. I had forgotten to multiple salary by 12. Now everything works. 😂

Answer 8

Mine is not working and I did the same thing!