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

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

1st Feb 2023, 10:48 PM
4 Answers
+ 3
The ELSE clause must be written in uppercase. also i would suggest you write all every SQL keywords in UPPERCASE LETTERS
2nd Feb 2023, 5:57 AM
Mirielle - avatar
+ 4
I cannot see this course yet, but you have a syntax error, you need to put a comma before the CASE block
2nd Feb 2023, 5:49 AM
Tibor Santa
Tibor Santa - avatar
+ 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
2nd Feb 2023, 6:29 AM
+ 2
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.
2nd Feb 2023, 10:39 AM
Jayakrishna 🇮🇳