SELECT column_name(s)

FROM table_name

WHERE column_name BETWEEN firstvalue AND secondvalue;

SELECT * FROM Employee

WHERE Salary BETWEEN 30000 AND 50000;

SELECT * FROM Employee

WHERE HireDate BETWEEN '12/01/2011'  AND '12/01/2012'

SELECT ELECT *

FROM Employee

WHERE Salary NOT BETWEEN 30000 AND 40000

SELECT *

FROM Employee

WHERE HireDate NOT  BETWEEN  '2011-01-11' AND '2012-01-12'

SELECT * FROM Employee

WHERE (Age BETWEEN 30 AND 35)

AND NOT DepId IN (1,3);