SQL - CONCAT & AS

Question

Hello world, can someone help understanding whats wrong with my code? The error message is that apparently the «salary» column doesn't exist but it exist in the problem. See for yourself.

The problem :

The AS Keyword

You are given the following staff table:contentImageThe salary shown in the table is monthly.
Each employee receives a bonus once a year. The bonus for each employee is equal to their years of experience multiplied by 500.

***I can't copy/past the image but here are the 5 columns : «fisrtname», «lastname», «salary», «department», «experience»

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.
Use the AS keyword and the CONCAT function!

Here's my code :

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

Answer 1

I think your calculation is correct, but as I understand it, CONCAT was meant to glue string values together. Therefore I don't think you need to use CONCAT for the annual bonus calculation result, as it is a numeric calculation

...
(salary * 12 + (experience * 500))
AS total
...
ORDER BY total;

I'd probably try something like that

Answer 2

That was it. Thank you so muchIpang!

The new and correct code :

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

Answer 3

My solution:

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

Answer 4

May I ask why you use CONCAT for calculated annual bonus? guessing by the field name 'salary', I would assume it contains numeric value.

Answer 5

Ipang, I want to merge the 2 columns by adding both columns values into 1 columns name «total». Here's my new code :

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

You're right I shouldn't CONCAT the «salary» and «experience», but how do I merge the to columns values into 1 columns 1 value?

Answer 6

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