-- between operator : 
-- The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.
-- The BETWEEN operator is inclusive: begin and end values are included. 
-- BETWEEN Syntax----
-- SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;

create table employee(EmpID int, EmpFirstName varchar(255),EmpLastName varchar(255),Address varchar(255),salary int);
insert into employee(EmpID, EmpFirstName, EmpLastName, Address, Salary)
values(1,"John","Doe","Delhi",10000),
(2,"Collins","john","Chandigarh",20000),
(3,"Johny","Doey","Delhi",10000),
(4,"Collinsy","johny","Chandigarh",20000),
(5,"Harryy","Jonesy","Delhi",15000); 

select * from employee where salary between 9000 and 17000; /*syntax for between operator*/