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
The ELSE clause must be written in uppercase. also i would suggest you write all every SQL keywords in UPPERCASE LETTERS
I cannot see this course yet, but you have a syntax error, you need to put a comma before the CASE block
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
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.