create table kuch(SNo integer(5),ENo integer(11),SName varchar(20),DOB date,Gender char(6),MOB int(10),Email varchar(30),Address varchar(30));
INSERT into kuch values(1,40215002717,'Aayush',1999-01-25,'M',9876543210,'abc@gmail.com','msit hostel');
INSERT into kuch values(2,30215002717,'AdityaG',1986-01-25,'F',9876542310,'adityabc@gmail.com','dharavi');
INSERT into kuch values(3,40415002717,'Sarthak',1999-01-31,'M',9546543210,'sarthakbc@gmail.com','msit hostel');
INSERT into kuch values(4,03215002717,'Arnav',1999-02-25,'M',9873243210,'arnavg@gmail.com','c4 janakpuri');
INSERT into kuch values(5,32115002717,'trevor',1999-12-23,'M',9872534210,'Trev@gmail.com','Sandy Shores');
select * from kuch;
CREATE TABLE bank(empno number(2),ename char(20),street char(30),city char(10),DOJ date,desg char(15),salary number(7));
INSERT into bank(empno,ename,street,city,DOJ,desg,salary)values(1,'david','gali number 2','boston',2000-07-21,'manager',60000);
INSERT into bank values(2,'JACK',' NUMBER 55','NEWYORK',1999-11-01,' JR.manager',55000);
INSERT into bank values(3,'alesso','walstreet','london',2000-01-15,'HR executive',75000);
INSERT into bank values(4,'martin','32-linker','los angeles',1998-03-14,' Sr.manager',80000);
INSERT into bank values(5,'yellowclaw','52-biker','las vegas',2004-06-22,' CTO',51000);
INSERT into bank values(6,'nucleyA','raajghat ','mumbai',2001-10-02,'vice president ',90000);
INSERT into bank values(7,'avicii','10 downing street','new jersey',1995-12-20,' president',95000);
select *from bank;