drop table supplies;

create table supplies	
(partno    smallint,
 suppno    smallint, 
 qty_disp  smallint,
 date_disp date);                                                    
                                                                     
insert into supplies values (232, 53, 20, '01-APR-88');

insert into supplies values (221, 51, 10, '02-APR-88');

insert into supplies values (221, 54, 30, '03-APR-88');

insert into supplies values (241, 51, 50, '03-APR-88');

insert into supplies values (222, 61, 40, '10-APR-88');
  

