Sql Between operator

The BETWEEN operator is used to select values within range of values in the parenthesis with values separated by AND operator.
Syntax is as:
SELECT * FROM table_name WHERE column_name BETWEEN 'value1' AND 'value2' 
As in example we have table employees
id first_name last_name salary city
1 Johan Sumith 200000 Delhi
2 Ansh Kumar 300000 Mumbai
3 Sameer Seth 100000 Delhi
4 Pyush 250000 Kolkata
5 Rajeev Khatri 450000 Chennai


We want to find employees whose salary is between 100000 and 250000.
SELECT * FROM employees WHERE salary BETWEEN  '100000' AND '250000'

We get
id first_name last_name salary city
1 Johan Sumith 200000 Delhi
3 Sameer Seth 100000 Delhi
4 Pyush 250000 Kolkata