--table
create table date_event(
ename varchar2(50),
edate   date);
-----
insert into date_event values ('jones','1/1/2009');
insert into date_event values ('jones','3/1/2009');
insert into date_event values ('jones','9/1/2009');
insert into date_event values ('jones','15/1/2009');
insert into date_event values ('jones','19/1/2009');
insert into date_event values ('jones','23/1/2009');
insert into date_event values ('jones','30/1/2009');
-- 
insert into date_event values ('jones','3/2/2009');
insert into date_event values ('jones','7/2/2009');
insert into date_event values ('jones','18/2/2009');
-----smith
insert into date_event values ('smith','4/1/2009');
insert into date_event values ('smith','9/1/2009');
insert into date_event values ('smith','15/1/2009');
insert into date_event values ('smith','20/1/2009');
insert into date_event values ('smith','24/1/2009');
insert into date_event values ('smith','28/1/2009');
--
insert into date_event values ('smith','1/2/2009');
insert into date_event values ('smith','6/2/2009');
insert into date_event values ('smith','12/2/2009');
---ford
insert into date_event values ('ford','2/1/2009');
insert into date_event values ('ford','4/1/2009');
insert into date_event values ('ford','16/1/2009');