create table Senders(
    ID int(4),
    Name varchar(20),
    City text(20),
    Address varchar(100)
);

Insert into Senders values(5101,"Mr.Ram", "New Delhi","201 DayanandVihar");
Insert into Senders values(5102,"Mr.Kumar", "Mumbal","125 Townhall");
Insert into Senders values(5103,"Ms. Soni", "Mumbai","20 New Hall");
Insert into Senders values(5106,"Mr. Sinha", "Kerela","105 K Aptt");

select * from Senders; 

-- Where 
select Name, City from Senders 
where Name = "Mr.Sinha"; 

select * from Senders
where Name = "Mr.Sinha";

-- && operator
select * from Senders
where Name = "Mr.Sinha" && City = "Kerela";

-- || operator
select * from Senders
where Name = "Mr.Sinha" || City = "Kerela";

-- BETWEEN 
select ID from Senders 
where ID BETWEEN 1501 and 5102; 

-- IN OPERATOR 
select * from Senders
where Name IN ("Mr.Kumar","Ram","Pooja","Ms. Soni"); 

-- NOT IN OPERATOR 
select * from Senders
where Name IN ("Mr.Kumar","Ram","Pooja","Ms. Soni"); 

-- <> = not equal 


create table Data(
    ID int(4),
    Fname varchar(20),
    Lname varchar(20),
    Hiredata Date,
    Salary int(6)
);

Insert into Data values(101,"Ankit","Anand","2016-11-15",16000); 
Insert into Data values(102,"Abshiek","Khanna","2015-01-21",10000);
Insert into Data values(103,"Mohita","Singh","2017-05-18",150000);
Insert into Data values(104,"Ashriti","Bartpa","2019-09-11",NULL);
Insert into Data values(105,"Aparna","Gupta","2020-06-05",10000);

select * from Data; 

select Salary from Data 
where Salary >= 120000; 

select HireData from Data 
where HireData >= "2017-01-01"; 

select Fname, ID from Data 
where Fname = "Ashriti" && ID = 104; 

select Fname, Lname from Data
where Salary BETWEEN 12000 and 17000; 

create table Teachers(
    ID int(20),
    Tname varchar(20),
    Subject varchar(20),
    DOJ Date,
    Salary int(20),
    Workload int(20),
    Gender varchar(2)
); 

Insert into Teachers values(201,"Akshita","English","2015-03-12",50000,20,"F");
Insert into Teachers values(202,"Rahul","History","2017-06-12",60000,22,"M");
Insert into Teachers values(203,"Bijoy","Computer","2018-02-07",750000,21,"M");
Insert into Teachers values(204,"Tina","English","2019-06-06",30000,NULL,"F");

select * from Teachers; 

select ID, Tname from Teachers
where Gender = "F"; 

select * from Teachers 
where Tname IN ("Pooja","Raj","Bijoy"); 

select Workload from Teachers 
where Workload >= 20; 

select Gender from Teachers 
where Salary >= 60000;