create table employees (
  eno     number(4) primary key, 
  ename   varchar(30),
  zip     number(5), 
  hdate   date);   


insert into employees values 
(1000, 'Jones',67226,'12-DEC-00'); 

insert into employees values 
(1001, 'Brown',67226,'12-DEC-00'); 

insert into employees values 
(1002, 'Green',67200,'12-DEC-00'); 

insert into employees values 
(1010, 'Clark',67200,'01-JAN-01'); 

insert into employees values 
(1011, 'Black',67225,'01-JAN-01'); 

insert into employees values 
(1012, 'Kent',67206,'12-FEB-01'); 

insert into employees values 
(1020, 'Jones',67216,'26-FEB-01'); 

insert into employees values 
(1021, 'Smith',67225,'28-MAR-01'); 

insert into employees values 
(1022, 'Laney',67225,'28-MAR-01'); 

insert into employees values 
(1025, 'Marsh',67226,'24-MAY-01');