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.

Answer 3

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 ;

Answer 4

Working with taxes can be tricky, especially when you’re trying to make sense of numbers in SQL or just figuring out deductions. Seeing real examples of calculations in forums like Sololearn really highlights how attention to detail matters. I’ve also checked Liberty Tax reviews https://liberty-tax.pissedconsumer.com/review.htmland reading about other people’s experiences shows which locations handle things efficiently and which ones can be a bit slow or confusing. Combining that insight with some practical learning makes filing taxes a lot less stressful, and you get a better idea of what to expect from a tax service