create table employee (
  fname varchar(255),
  minit varchar(255),
  lname varchar(255),
  pan integer,
  bdate date,
  address varchar(255),
  sex varchar(255),
  salary integer,
  supepan integer,
  dno integer
);

insert into employee values ('Ritesh','P','Tiwari','12345678','1965-01-09','20, Sheh Nagar, Indore','M',30000,333225555,5);
insert into employee values ('Shishir','K','Agrawal','334455555','1955-12-08','30, Cloth Market, Jaipur','M',40000,888665555,5);
insert into employee values ('Alicia','J','Beck','999887777','1968-07-19','92, Andheri(W), Mumbai','F',25000,987654321,4);
insert into employee values ('Rameshwar','K','Narayan','66881111','1941-06-20','100, Usha Nagar, Indore','F',43000,888665555,4);
insert into employee values ('Ahmed','V','Jabbar','4534534','1962-09-15','125, Mahavir Nagar, Lucknow','M',38000,333445555,5);
insert into employee values ('Jayav','E','Jain','98798776','1972-07-31','256, Hans Marg, Jaipur','F',25000,333445555,5);
insert into employee values ('Mahavir','K','Mital','88665555','1969-03-29','290, Chandni Chowk, Delhi','M',25000,98765432,4);
insert into employee values ('Arpit','M','Mital','98765432','1937-11-10','Ranchi Basti, Jabalpur','M',55000,null,1);

select * from employee;