Intermediate sql taxes

Question

Here is my code:

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;

It failed. Can someone help me with this?

Answer 1

You had used the wrong operators in fifth line. Write it as:
>= and next is <=

Answer 2

I already solved it .thanks.