Help me with this problem in sql

Question

I was coding for an SQL intermediate code coach thing, but then when I try to run it, there's an error that goes something along the line of " error WHEN salary >= 0 AND salary <= 1500
∆
Can someone pls help me out idk that <= is illegal, thank you

Code (P.S I just realized there's no sql thing on the code sandbox)

https://code.sololearn.com/cDrJTzSmtwR1/?ref=app

Answer 1

Missing 'salary' after the 'AND' operator perhaps?

Or maybe try to use BETWEEN() in place of <expression> AND <expreasion>

Answer 2

Ipang looks like the answer is that I forgot to add the salary after AND, thank you!