0

Help me with this problem in sql

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

29th Mar 2023, 11:37 AM
RayZ
RayZ - avatar
2 Respostas
+ 6
Missing 'salary' after the 'AND' operator perhaps? Or maybe try to use BETWEEN() in place of <expression> AND <expreasion>
29th Mar 2023, 12:24 PM
Ipang
+ 1
Ipang looks like the answer is that I forgot to add the salary after AND, thank you!
29th Mar 2023, 9:20 PM
RayZ
RayZ - avatar