Can you help me with code? SQL course 12.2

Question

SELECT CONCAT (staff.firstname,' ',staff.lastname)
AS fullname
staff.salary*12+staff.expirience*500 AS total
FROM staff
ORDER BY total;
Where is uncorrected?

Answer 1

You have to compute salary*12 + 500*experience. Also, in the query it's only mentioned as firstname & lastname, so while solving you include names as mentioned in table

Corrected query while sorting:

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

Answer 2

Thank you very much 😊

Answer 3

Oh, thanks Shivani!🙏