create table IF NOT EXISTS College(
    ID int(1),
    Name text(20),
    Stipend text(8), 
    Subject text(17),
    Percentage int(2),
    Position text(2)
    );

Insert into College values(1,"Anuj",4000,"English",65,"P1"); 
Insert into College values(2,"Ashu",4500,"History",60,"P2"); 
Insert into College values(3,"Ruby",3500,"English",55,"P2"); 
Insert into College values(4,"Raman",3800,"Math",58,"P3"); 

select * from College; 

-- DISTINCT
select distinct Position from College; 

-- QUESTION 1 

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; 

-- QUESTION `` 

create table Records(
    ID int(6),
    FName text(10),
    LName text(10),
    Hiredata Date,
    Salary int(10)
);

Insert into Records values(102,"Amit","Sethi", "1998-12-10",120000);
Insert into Records values(103,"Suman","Vyas","1994-12-24",100000);
Insert into Records values(102,"Rhaki","Sinha","2001-1-04",12000);
Insert into Records values(105,"Rashmi","Mal","2004-11-09",170000);
Insert into Records values(106,"Suelkha","Sriva","2006-05-06",10000);

select * from Records;

-- QUESTION 1

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

Insert into University values(101,"Akshu",250000,"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 values(105,"Sumati",50000,"1900-07-09");

select * from University; 

-- QUESTION 2 

create table Supermarket(
    ID int(2),
    P_name varchar(5),
    Price int(2),
    Qty int(5),
    PRIMARY KEY (ID)
);

Insert into Supermarket values(1,"P1",240,23);
Insert into Supermarket values(2,"P2",300,24);
Insert into Supermarket values(3,"P3",320,43);
Insert into Supermarket values(4,"P4",130,32);
Insert into Supermarket values(5,"P5",100,17);

select * from Supermarket; 

-- QUESTION 3 

create table Students(
    RollNo int(5),
    Name varchar(20),
    Class varchar(5),
    Fee int(7),
    Percentage int(5),
    PRIMARY KEY (RollNo)
); 

Insert into Students values(1,"Amit","X",3400,78);
Insert into Students values(2,"Sumit","XI",2800,45);
Insert into Students values(3,"Suman","X",3700,84);
Insert into Students values(4,"Pushkar","X",2500,60);

select * from Students; 

-- QUESTION 4 

create table Faculty(
    ID int(3),
    Name varchar(20),
    Sal int(8),
    Joining Date,
    PRIMARY KEY (ID)
); 

Insert into Faculty values(101,"Anjali",250000,"2018-10-12");
Insert into Faculty values(102,"Arman",340000,"2019-02-10");
Insert into Faculty values(103,"Shelly",450000,"2020-07-23");

select * from Faculty;