create table FANS (
  admn INT PRIMARY KEY(),
  name TEXT NOT NULL(10),
  stream TEXT NOT NULL(10), 
  optional TEXT NOT NULL(10), 
  score INT(1),
);


INSERT INTO FANS VALUES (1001,"Shrishi","Science","CS",90);
INSERT INTO FANS VALUES (1002,"Ashi","Humanities","Maths",80);
INSERT INTO FANS VALUES (1003,"Aditya","Commerece","IP",60);
INSERT INTO FANS VALUES (1004,"Ritu Raj","Science","IP",65);
INSERT INTO FANS VALUES (1005,"Sonali","Commerence","Maths",60);


create table fanDB (
  admn TEXT NOT NULL(10),
  name TEXT NOT NULL(10),
  stream TEXT NOT NULL(10), 
  optional TEXT NOT NULL(10), 
  score INT(1),
);


INSERT INTO FANS VALUES ("F001","Rakesh","Mumbai",1998-10-02,"Mail");
INSERT INTO FANS VALUES ("F002","Riya","Mumbai",1997-12-12,"Letter");
INSERT INTO FANS VALUES ("F003","Anika","Delhi",2001-06-30,"Blog");
INSERT INTO FANS VALUES ("F004","Rudra","Ajmer",2005-08-22,"Mail");
INSERT INTO FANS VALUES ("F006","Miara","Kolkata","1998-11-01","Blog");