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

The ELSE clause must be written in uppercase. also i would suggest you write all every SQL keywords in UPPERCASE LETTERS

Answer 2

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

Answer 3

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 4

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.