SELECT CONCAT (FirstName, ' , ' , LastName) AS fullname (salary*12)+(experience*500) AS total FROM staff

Question

Each employee receives a bonus once a year. The bonus for each employee is equal to their years of experience multiplied by 500.

Write a query to output the firstname and lastname columns into one column named fullname separated by space, and the total annual salary for each employee keeping in mind bonuses named 'total'. Sort by the 'total' column.

Answer 1

Select CONCAT (firstname,' ', lastname) AS fullname,
salary*12+experience*500 AS total From staff
Order by total;

Answer 2

Thank you

Answer 3

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

Answer 4

I have done all this but the first name and last name comes out as fullname without space in between the first and last name
Someone please explain further cause am new to this SQL and it's driving me nuts

Answer 5

SELECT CONCAT (firstname, ' , ' , lastname)
AS fullname
(salary*12)+(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

working

Answer 7

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