I am doing intermediate Sql. Does any one know what is wrong with code below

Question

Select firstname,lastname,salary
CASE
WHEN salary>=0 and salary <=1500
Then Salary*0.1

WHEN salary >= 1501 and salary <=2000
Then salary*0.2
Else salary*0.3
End as tax from Employees

Answer 1

I cannot see this course yet, but you have a syntax error, you need to put a comma before the CASE block

Answer 2

Please, do not write any code in post tags, it's better to use the post tags to specify relevant language name or lesson subject

https://code.sololearn.com/W3uiji9X28C1/?ref=app

Answer 3

Add the task description clearly..
If iam at the right task description of this code, then along with syntax error ( camma is missing after salary,), task also says "output should be sorted by last name column in ascending order."
So sort is missing in query.

Answer 4

Correct :Answer

SELECT firstname, lastname, salary,
CASE
WHEN salary >= 0 AND salary <= 1500 THEN salary * 0.1
WHEN salary >= 1501 AND salary <= 2000 THEN salary * 0.2
ELSE salary * 0.3
END AS tax
FROM Employees
ORDER BY lastname ASC;

Answer 5

SELECT firstname, lastname, salary,
CASE
WHEN salary >= 0 and salary<=1500 then salary * 0.1
WHEN salary >= 1501 and salary<=2000 then salary * 0.2
WHEN salary >= 2001 then salary * 0.3
END as tax

FROM Employees
ORDER BY lastname ASC ;