MySql Between & Not Between

How to work Select Data Between & Not Between Operator:

Example:

Between & Not Between Syntax:

Code:
CREATE TABLE student( id INT NOT NULL UNIQUE, name VARCHAR(50) NOT NULL, age INT NOT NULL CHECK(age >= 18), gender VARCHAR(1) NOT NULL, phone VARCHAR(10) NOT NULL UNIQUE, city VARCHAR(15) NOT NULL DEFAULT 'MUL' );

Insert Records

INSERT INTO student(id,name,age,gender,phone,city)
VALUES
(1,"Asif","13","M","4022155","BHW"),
(2,"Saqib","21","M","4034421","Mul"),
(3,"Salman Khan","20","M","4056221","Mul"),
(4,"Maryam","18","F","4022155","DG Khan"),
(5,"Hamza","22","M","4025221","Mul"),
(6,"Anela","21","F","4056776","LHR");

BETWEEN & NOT BETWEEN
SELECT * FROM student WHERE age BETWEEN 18 AND 20;

SELECT * FROM student WHERE age NOT BETWEEN 18 AND 20;

SELECT * FROM student WHERE id BETWEEN 2 AND 5;

SELECT * FROM student WHERE id NOT BETWEEN 2 AND 5;

SELECT * FROM student WHERE name BETWEEN "a" AND "k";

SELECT * FROM student WHERE name BETWEEN "Aqib" AND "Saqib";

SELECT * FROM student WHERE date BETWEEN "a" AND "k";
SQL

Create new database "test" for use BETWEEN with date EXAMPLE

Create table "persons" under "test" database
CREATE TABLE persons(
	id INT NOT NULL UNIQUE,
	name VARCHAR(50) NOT NULL,
	birth_date DATE NOT NULL
);
SQL

insert records in "persons" table
INSERT INTO persons(id,name,birth_date)
VALUES
(1,"Aqib","1995-02-10"),
(2,"Asif","1995-11-03"),
(3,"Salman","1996-06-12"),
(4,"Shoiab","1995-04-21"),
(5,"Anela","1996-09-25");
SQL

BETWEEN & NOT BETWEEN with date
SELECT * FROM persons WHERE birth_date BETWEEN "1995-01-01" AND "1995-06-30";