create table foobulations
 (name varchar not null, 
  foodate date, 
  foobs integer); 

insert into foobulations (name, foodate, foobs) values ('Mandy','04/01/02',300);
insert into foobulations (name, foodate, foobs) values ('Mandy','04/02/02',402);
insert into foobulations (name, foodate, foobs) values ('Mandy','04/03/02',1000);
insert into foobulations (name, foodate, foobs) values ('Mandy','04/04/02',3301);
insert into foobulations (name, foodate, foobs) values ('Candy','04/01/02',35);
insert into foobulations (name, foodate, foobs) values ('Candy','04/02/02',43);
insert into foobulations (name, foodate, foobs) values ('Candy','04/03/02',63);
insert into foobulations (name, foodate, foobs) values ('Sandy','04/03/02',-203);