/* 010- AND, OR and NOT operators (for multiple conditions) */
-- create column
CREATE TABLE tOne(
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 'Agra'
);
-- enter the data
INSERT INTO tOne(id,name,age,gender,phone,city)
VALUES
(1,"Ram Kumar","23","M","4022155","Agra"),
(2,"Sarita Kumari","21","F","4034421","Delhi"),
(3,"Salman Khan","20","M","4056221","Agra"),
(4,"Juhi Chawla","28","F","4022156","Bhopal"),
(5,"Anil Kapoor","22","M","4025221","Agra"),
(6,"John Abraham","21","M","4056776","Delhi");
-- insert and or not commands
SELECT * FROM tOne WHERE age >= 18 AND age <= 21;
SELECT * FROM tOne WHERE age <= 20 AND gender = "M";
SELECT * FROM tOne WHERE age <= 20 OR city = "Agra";
SELECT * FROM tOne WHERE (city = "Bhopal" OR city = "Agra") AND gender = "M";
SELECT * FROM tOne WHERE NOT (city = "Bhopal" OR city = "Agra");
SELECT * FROM tOne WHERE NOT age >= 20;