create table student1 ( stuid number(7) primary key, status varchar2(30),name varchar2(100),class varchar2(40),doa date); insert into student1 (stuid,status,name,class,doa) values (1,'PRESENT','AHA','PREP','01-JAN-17'); insert into student1 (stuid,status,name,class,doa) values (4,'PRESENT','A','ONE','01-FEB-16'); insert into student1 (stuid,status,name,class,doa) values (3,'PRESENT','AQ','ONE','11-JAN-17'); insert into student1 (stuid,status,name,class,doa) values (2,'PRESENT','AER','PREP','11-JAN-17'); insert into student1 (stuid,status,name,class,doa) values (29,'PRESENT','AERRRRRJ','P.G','13-JAN-16'); insert into student1 (stuid,status,name,class,doa) values (28,'PRESENT','AQRRRRH','P.G','13-JAN-16'); insert into student1 (stuid,status,name,class,doa) values (27,'PRESENT','AARAG','P.G','09-FEB-16'); insert into student1 (stuid,status,name,class,doa) values (26,'PRESENT','AEARRTAA','P.G','11-FEB-16'); insert into student1 (stuid,status,name,class,doa) values (30,'PRESENT','AER44RRJ','P.G','13-JAN-16'); insert into student1 (stuid,status,name,class,doa) values (31,'PRESENT','AQR3RH','P.G','13-JAN-16'); insert into student1 (stuid,status,name,class,doa) values (32,'PRESENT','AAAG','P.G','19-FEB-16'); insert into student1 (stuid,status,name,class,doa,LEAV_DATE) values (33,'N_PRESENT','AEAAA','P.G','16-FEB-16','19-SEP-16'); insert into student1 (stuid,status,name,class,doa,LEAVE_DATE) values (40,'N_PRESENT','AEARRTAA','P.G','11-FEB-16','20-OCT-16'); insert into student1 (stuid,status,name,class,doa,LEAV_DATE) values (36,'N_PRESENT','AER44RRJ','P.G','13-JAN-16','23-JUN-16'); insert into student1 (stuid,status,name,class,doa) values (37,'PRESENT','AQR3RH','P.G','13-JAN-16'); insert into student1 (stuid,status,name,class,doa) values (38,'PRESENT','AAAG','P.G','19-FEB-16'); insert into student1 (stuid,status,name,class,doa) values (39,'PRESENT','AEAAA','P.G','16-FEB-16'); insert into student1 (stuid,status,name,class,doa) values (41,'PRESENT','AERRERRRRJ','P.G','20-JAN-16'); insert into student1 (stuid,status,name,class,doa) values (42,'PRESENT','AQRWERWERRRRH','P.G','20-JAN-17'); insert into student1 (stuid,status,name,class,doa) values (43,'PRESENT','AARAEEWG','P.G','13-FEB-17'); insert into student1 (stuid,status,name,class,doa) values (44,'PRESENT','AEAWERRTAA','P.G','13-FEB-17'); insert into student1 (stuid,status,name,class,doa) values (45,'PRESENT','AEREWEW44RRJ','P.G','13-MAR-17'); insert into student1 (stuid,status,name,class,doa) values (46,'PRESENT','AQEWTYTRYR3RH','P.G','01-APR-17'); insert into student1 (stuid,status,name,class,doa) values (47,'PRESENT','AATYRTYAG','P.G','19-FEB-17'); insert into student1 (stuid,status,name,class,doa,LEAV_DATE) values (48,'N_PRESENT','AERWERAAA','P.G','16-FEB-17','10-SEP-16'); insert into student1 (stuid,status,name,class,doa,LEAV_DATE) values (49,'N_PRESENT','AEARTYTRYRRTAA','P.G','11-FEB-17','10-OCT-16'); insert into student1 (stuid,status,name,class,doa,LEAV_DATE) values (17,'N_PRESENT','AER4TRYR4RRJ','P.G','13-JAN-16','23-JUN-16'); insert into student1 (stuid,status,name,class,doa,LEAV_DATE) values (19,'N_PRESENT','AEARTYTRYRRTAA','P.G','11-FEB-17','10-OCT-16'); insert into student1 (stuid,status,name,class,doa,LEAV_DATE) values (16,'N_PRESENT','AER4TRYR4RRJ','P.G','13-JAN-16','23-JUN-16'); COMMIT;