Exercise: Exclude Range
Find students with marks NOT between 60 and 80.
Solution
sql
1SELECT * FROM students
2WHERE marks NOT BETWEEN 60 AND 80;Returns students with marks below 60 or above 80.

Find students with marks NOT between 60 and 80.
1SELECT * FROM students
2WHERE marks NOT BETWEEN 60 AND 80;Returns students with marks below 60 or above 80.