create table University(
    ID int(4),
    FName varchar(20),
    Sal int(10),
    Hiredata Date,
    PRIMARY KEY (ID)
); 

Insert into University(ID, FName,Hiredata) values(101,"Akshu","1880-10-12");
Insert into University values(102,"Aman",340000,"1900-02-10");
Insert into University values(103,"Sumit",450000,"1933-07-23");
Insert into University values(104,"Suman",220000,"1997-09-19");
Insert into University(ID, Sal, Hiredata) values (105,50000,"1900-07-09");

select * from University; 

-- IS NULL 

select Id, Sal from University
where Fname IS NULL;

-- IS NOT NULL 
select ID, Sal from University 
where FName IS NOT NULL; 

-- LIKE OPERATOR 

-- % 
select * from University 
where FName Like "A%"; 

select * from University 
where FName Like "%n"; 


select * from University
where FName Like "_u%"; 


create table Student(
    ID int(4),
    Name varchar(15),
    stipend int(10),
    stream varchar(15),
    avgmark decimal(5,2),
    grade varchar(3),
    class varchar(5)
);

Insert into Student values (1,"Bob",50000,"medical",97.5,"A","12A");
Insert into Student values (2,"Amisha",50000,"medical",92.5,"A","15A");
Insert into Student values (1,"Bob",50000,"medical",97.5,"A","12A");

select * from Student 
where Name Like "A"; 

select * from Student 
where stream = "medical"; 

create table Customer(
    ID varchar(15),
    CName varchar(15),
    c_add varchar(35),
    c_city varchar(15)
);

Insert into Customer values("C101","Mr.ram","201 Dayandand Vidar","New Dheli");
Insert into Customer values("C102","Anu","Apartment 102","New york");
Insert into Customer values("C103","Chloe","Apartment 103",NULL);

select * from Customer 
where c_city = NULL;