Fatma Amer
Last answered:

13 Sept 2023

 Posted on:

05 Sept 2023
0

Resolved: salary was raised by more than $20000 and less than $30000

in SQL / The CASE Statement

why 'salary was raised by more than $20000 and less than $30000' option do not appear in the result?

1 answers ( 1 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

13 Sept 2023
0

Hi Fatma!
Thanks for reaching out.

Please, use BETWEEN 20000 and 30000 instead of BETWEEN 30000 and 20000. The syntax is:

BETWEEN low_value AND high_value



Hope this helps.
Best,
Tsvetelin

Helpful answer

Submit an answer

related questions

Islam Elkhateeb
3
26
Resolved: can't add row, I do may trail and it all back with errors
Alessandro Imbrìaco
2
26
Resolved: Explanations to questions 15 and 29
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
Archisman Das
0
8
Resolved: SQL Task- getting the names of all the managers who have an AVG salary of 85k+
Nourhan Osama Ahmad
0
8
how to upload the assignment and remark on it 
Maxime Darbouze
0
8
I wrote the same command that is the sql file and it did not work
Maxime Darbouze
0
8
1681 Integer display width is deprecated and will be removed in a future release.
Kiran B
0
8
Resolved: Queries with LIKE('Mar%') and LIKE('Mar_') are returning the output with 1000 rows each