--------------------------------------------------------
--  File created - Friday-December-09-2016   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table SALES
--------------------------------------------------------

  CREATE TABLE "SALES" 
   (	"PROD_ID" NUMBER(6,0), 
	"CUST_ID" NUMBER, 
	"TIME_ID" DATE, 
	"CHANNEL_ID" CHAR(1), 
	"PROMO_ID" NUMBER(6,0), 
	"QUANTITY_SOLD" NUMBER(3,0), 
	"AMOUNT_SOLD" NUMBER(10,2)
   ) 
  PARTITION BY RANGE ("TIME_ID") 
 (PARTITION "SALES_1995"  VALUES LESS THAN (TO_DATE(' 1996-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_1996"  VALUES LESS THAN (TO_DATE(' 1997-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_H1_1997"  VALUES LESS THAN (TO_DATE(' 1997-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_H2_1997"  VALUES LESS THAN (TO_DATE(' 1998-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q1_1998"  VALUES LESS THAN (TO_DATE(' 1998-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q2_1998"  VALUES LESS THAN (TO_DATE(' 1998-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q3_1998"  VALUES LESS THAN (TO_DATE(' 1998-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q4_1998"  VALUES LESS THAN (TO_DATE(' 1999-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q1_1999"  VALUES LESS THAN (TO_DATE(' 1999-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q2_1999"  VALUES LESS THAN (TO_DATE(' 1999-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q3_1999"  VALUES LESS THAN (TO_DATE(' 1999-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q4_1999"  VALUES LESS THAN (TO_DATE(' 2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q1_2000"  VALUES LESS THAN (TO_DATE(' 2000-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q2_2000"  VALUES LESS THAN (TO_DATE(' 2000-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q3_2000"  VALUES LESS THAN (TO_DATE(' 2000-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) , 
 PARTITION "SALES_Q4_2000"  VALUES LESS THAN (TO_DATE(' 2001-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ) ;

REM INSERTING into SALES
SET DEFINE OFF;
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11160,17450,to_date('02-JAN-98','DD-MON-RR'),'I',9999,19,798);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1340,33710,to_date('03-JAN-98','DD-MON-RR'),'S',9999,16,1264);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (25270,65880,to_date('05-JAN-98','DD-MON-RR'),'I',9999,5,210);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1615,73480,to_date('05-JAN-98','DD-MON-RR'),'I',9999,8,96);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1900,84910,to_date('06-JAN-98','DD-MON-RR'),'I',9999,42,378);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8085,37900,to_date('09-JAN-98','DD-MON-RR'),'S',9999,1,68);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (755,26590,to_date('09-JAN-98','DD-MON-RR'),'I',9999,11,132);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10,68060,to_date('09-JAN-98','DD-MON-RR'),'P',9999,28,4900);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13425,109310,to_date('10-JAN-98','DD-MON-RR'),'I',9999,1,68);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1955,65190,to_date('10-JAN-98','DD-MON-RR'),'S',9999,28,1512);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (970,68530,to_date('12-JAN-98','DD-MON-RR'),'P',9999,28,1092);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3150,65930,to_date('14-JAN-98','DD-MON-RR'),'S',9999,28,1456);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (23105,32910,to_date('14-JAN-98','DD-MON-RR'),'P',9999,2,290);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (530,136270,to_date('16-JAN-98','DD-MON-RR'),'P',9999,11,308);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3130,41720,to_date('20-JAN-98','DD-MON-RR'),'S',9999,1,22);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16515,12290,to_date('20-JAN-98','DD-MON-RR'),'S',9999,20,720);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9225,19400,to_date('23-JAN-98','DD-MON-RR'),'S',9999,4,312);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2655,80960,to_date('28-JAN-98','DD-MON-RR'),'S',9999,24,4680);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10600,24410,to_date('29-JAN-98','DD-MON-RR'),'P',9999,14,546);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2510,6950,to_date('01-FEB-98','DD-MON-RR'),'S',9999,2,78);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2725,11110,to_date('01-FEB-98','DD-MON-RR'),'S',9999,2,116);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16440,145950,to_date('02-FEB-98','DD-MON-RR'),'P',9999,8,320);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1845,72380,to_date('04-FEB-98','DD-MON-RR'),'S',9999,9,432);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9845,9700,to_date('04-FEB-98','DD-MON-RR'),'C',9999,17,561);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11525,145950,to_date('05-FEB-98','DD-MON-RR'),'I',9999,1,19);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3770,32800,to_date('06-FEB-98','DD-MON-RR'),'S',9999,14,1316);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3445,33530,to_date('07-FEB-98','DD-MON-RR'),'T',9999,2,170);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4255,46380,to_date('08-FEB-98','DD-MON-RR'),'P',9999,8,368);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4540,17920,to_date('09-FEB-98','DD-MON-RR'),'I',9999,29,1537);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8045,49620,to_date('09-FEB-98','DD-MON-RR'),'S',9999,3,567);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18080,47430,to_date('13-FEB-98','DD-MON-RR'),'I',9999,41,1968);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2560,18510,to_date('14-FEB-98','DD-MON-RR'),'C',9999,12,1176);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4105,18250,to_date('14-FEB-98','DD-MON-RR'),'T',9999,2,158);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (410,161560,to_date('16-FEB-98','DD-MON-RR'),'I',9999,5,695);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5380,34340,to_date('19-FEB-98','DD-MON-RR'),'I',9999,12,984);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16060,60420,to_date('22-FEB-98','DD-MON-RR'),'P',9999,10,2750);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7810,27430,to_date('26-FEB-98','DD-MON-RR'),'T',9999,2,62);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3160,103400,to_date('27-FEB-98','DD-MON-RR'),'S',9999,14,728);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (22670,33600,to_date('01-MAR-98','DD-MON-RR'),'S',9999,4,312);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6345,71610,to_date('02-MAR-98','DD-MON-RR'),'S',9999,24,408);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1240,35170,to_date('03-MAR-98','DD-MON-RR'),'P',9999,18,1422);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (38920,128020,to_date('04-MAR-98','DD-MON-RR'),'T',9999,7,133);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2435,28810,to_date('10-MAR-98','DD-MON-RR'),'I',9999,27,135);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5120,26450,to_date('11-MAR-98','DD-MON-RR'),'S',9999,21,1449);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12605,61720,to_date('17-MAR-98','DD-MON-RR'),'S',9999,14,1386);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2205,188200,to_date('18-MAR-98','DD-MON-RR'),'P',9999,5,35);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1050,52860,to_date('18-MAR-98','DD-MON-RR'),'I',9999,21,525);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10660,7720,to_date('20-MAR-98','DD-MON-RR'),'T',9999,7,294);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1465,31590,to_date('20-MAR-98','DD-MON-RR'),'I',9999,19,2375);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7135,49360,to_date('20-MAR-98','DD-MON-RR'),'S',9999,2,58);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4945,2470,to_date('21-MAR-98','DD-MON-RR'),'T',9999,2,84);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12390,20000,to_date('22-MAR-98','DD-MON-RR'),'C',9999,5,230);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (385,37240,to_date('22-MAR-98','DD-MON-RR'),'I',9999,12,1416);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2275,66800,to_date('23-MAR-98','DD-MON-RR'),'C',9999,22,1408);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1825,111050,to_date('23-MAR-98','DD-MON-RR'),'C',9999,6,288);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (160,37280,to_date('24-MAR-98','DD-MON-RR'),'I',9999,12,660);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9235,13000,to_date('24-MAR-98','DD-MON-RR'),'S',9999,9,621);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6245,43400,to_date('26-MAR-98','DD-MON-RR'),'C',9999,13,702);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (920,62650,to_date('27-MAR-98','DD-MON-RR'),'S',9999,11,88);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (34235,49390,to_date('28-MAR-98','DD-MON-RR'),'S',9999,1,125);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1720,109850,to_date('29-MAR-98','DD-MON-RR'),'P',9999,17,561);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5255,101520,to_date('29-MAR-98','DD-MON-RR'),'S',9999,10,690);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8295,19400,to_date('02-APR-98','DD-MON-RR'),'T',9999,2,18);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9305,16490,to_date('02-APR-98','DD-MON-RR'),'I',9999,14,1484);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2155,74070,to_date('04-APR-98','DD-MON-RR'),'P',9999,8,880);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2975,30720,to_date('07-APR-98','DD-MON-RR'),'T',9999,2,24);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (530,29140,to_date('08-APR-98','DD-MON-RR'),'P',9999,8,224);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3475,3910,to_date('10-APR-98','DD-MON-RR'),'I',9999,1,32);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12845,84700,to_date('11-APR-98','DD-MON-RR'),'S',9999,2,24);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1485,37310,to_date('12-APR-98','DD-MON-RR'),'S',9999,9,81);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3040,19520,to_date('12-APR-98','DD-MON-RR'),'S',9999,34,1326);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (410,161560,to_date('13-APR-98','DD-MON-RR'),'I',9999,5,695);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5295,3320,to_date('13-APR-98','DD-MON-RR'),'P',9999,3,204);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2070,98380,to_date('14-APR-98','DD-MON-RR'),'T',9999,2,216);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9605,8370,to_date('15-APR-98','DD-MON-RR'),'C',9999,20,1560);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1505,22760,to_date('16-APR-98','DD-MON-RR'),'S',9999,5,225);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7125,85570,to_date('16-APR-98','DD-MON-RR'),'I',9999,18,1170);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1465,22540,to_date('16-APR-98','DD-MON-RR'),'I',9999,8,1000);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2075,58670,to_date('17-APR-98','DD-MON-RR'),'S',9999,2,168);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12210,46080,to_date('19-APR-98','DD-MON-RR'),'P',9999,18,234);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6965,6910,to_date('22-APR-98','DD-MON-RR'),'I',9999,19,2565);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2070,132610,to_date('23-APR-98','DD-MON-RR'),'I',9999,4,432);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7810,27430,to_date('23-APR-98','DD-MON-RR'),'T',9999,2,62);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (19265,139220,to_date('26-APR-98','DD-MON-RR'),'S',9999,4,168);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1505,22760,to_date('28-APR-98','DD-MON-RR'),'S',9999,5,225);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2040,80400,to_date('28-APR-98','DD-MON-RR'),'I',9999,5,185);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8930,11430,to_date('01-MAY-98','DD-MON-RR'),'S',9999,2,108);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4245,14680,to_date('04-MAY-98','DD-MON-RR'),'T',9999,5,195);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9745,24410,to_date('04-MAY-98','DD-MON-RR'),'C',9999,10,1450);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4395,22300,to_date('04-MAY-98','DD-MON-RR'),'S',9999,15,735);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4985,71950,to_date('05-MAY-98','DD-MON-RR'),'I',9999,4,32);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3450,33600,to_date('06-MAY-98','DD-MON-RR'),'T',9999,13,624);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3740,6750,to_date('06-MAY-98','DD-MON-RR'),'S',9999,11,638);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4545,37820,to_date('09-MAY-98','DD-MON-RR'),'S',9999,24,3168);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (945,46380,to_date('11-MAY-98','DD-MON-RR'),'T',9999,2,330);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8745,2870,to_date('12-MAY-98','DD-MON-RR'),'T',9999,7,756);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4485,40620,to_date('13-MAY-98','DD-MON-RR'),'C',9999,20,2780);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1580,2080,to_date('13-MAY-98','DD-MON-RR'),'T',9999,2,28);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9585,31560,to_date('14-MAY-98','DD-MON-RR'),'S',9999,2,76);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6940,158430,to_date('17-MAY-98','DD-MON-RR'),'S',9999,4,540);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (795,9580,to_date('17-MAY-98','DD-MON-RR'),'I',9999,11,649);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (125,58940,to_date('18-MAY-98','DD-MON-RR'),'T',9999,7,903);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1355,118900,to_date('19-MAY-98','DD-MON-RR'),'T',9999,10,330);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (205,22810,to_date('19-MAY-98','DD-MON-RR'),'I',9999,12,792);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (845,26380,to_date('19-MAY-98','DD-MON-RR'),'T',9999,2,118);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1675,133370,to_date('20-MAY-98','DD-MON-RR'),'I',9999,1,59);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5250,101520,to_date('24-MAY-98','DD-MON-RR'),'S',9999,3,444);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (45,11600,to_date('25-MAY-98','DD-MON-RR'),'S',9999,2,158);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (570,30350,to_date('26-MAY-98','DD-MON-RR'),'C',9999,11,1320);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7560,46280,to_date('27-MAY-98','DD-MON-RR'),'S',9999,6,294);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1520,7450,to_date('27-MAY-98','DD-MON-RR'),'T',9999,2,32);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9680,8950,to_date('27-MAY-98','DD-MON-RR'),'T',9999,10,30);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7580,3910,to_date('30-MAY-98','DD-MON-RR'),'C',9999,17,153);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (840,59960,to_date('01-JUN-98','DD-MON-RR'),'S',9999,29,1566);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1640,23030,to_date('02-JUN-98','DD-MON-RR'),'S',9999,1,36);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17920,42780,to_date('03-JUN-98','DD-MON-RR'),'I',9999,13,182);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (975,73340,to_date('04-JUN-98','DD-MON-RR'),'T',9999,2,20);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4230,37240,to_date('06-JUN-98','DD-MON-RR'),'S',9999,4,220);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3360,39820,to_date('06-JUN-98','DD-MON-RR'),'S',9999,39,1287);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7535,5900,to_date('07-JUN-98','DD-MON-RR'),'C',9999,28,784);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18460,11470,to_date('09-JUN-98','DD-MON-RR'),'P',9999,8,576);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (35785,89870,to_date('09-JUN-98','DD-MON-RR'),'P',211,17,938.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (550,16380,to_date('10-JUN-98','DD-MON-RR'),'I',379,5,119);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2315,52860,to_date('10-JUN-98','DD-MON-RR'),'S',9999,6,114);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (630,125910,to_date('11-JUN-98','DD-MON-RR'),'T',163,2,33.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6920,30650,to_date('13-JUN-98','DD-MON-RR'),'S',9999,37,1480);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3745,6030,to_date('16-JUN-98','DD-MON-RR'),'P',9999,10,1080);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2640,15200,to_date('17-JUN-98','DD-MON-RR'),'C',9999,17,323);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (920,6760,to_date('18-JUN-98','DD-MON-RR'),'S',391,2,12.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9925,21600,to_date('20-JUN-98','DD-MON-RR'),'P',499,17,187.85);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (185,29790,to_date('22-JUN-98','DD-MON-RR'),'S',9999,44,1716);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1655,37120,to_date('26-JUN-98','DD-MON-RR'),'I',9999,5,240);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4835,145360,to_date('27-JUN-98','DD-MON-RR'),'P',9999,3,90);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (44520,178150,to_date('28-JUN-98','DD-MON-RR'),'C',9999,12,96);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10965,145360,to_date('03-JUL-98','DD-MON-RR'),'I',67,19,1692.9);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (160,161560,to_date('04-JUL-98','DD-MON-RR'),'C',343,17,748);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15225,49620,to_date('04-JUL-98','DD-MON-RR'),'S',9999,10,880);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1945,49840,to_date('05-JUL-98','DD-MON-RR'),'S',9999,24,1728);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (42220,43180,to_date('09-JUL-98','DD-MON-RR'),'S',238,8,89.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9185,22800,to_date('11-JUL-98','DD-MON-RR'),'C',391,28,1545.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (34740,33600,to_date('11-JUL-98','DD-MON-RR'),'P',211,3,100.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3430,45810,to_date('12-JUL-98','DD-MON-RR'),'P',55,39,6142.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11925,3870,to_date('13-JUL-98','DD-MON-RR'),'P',9999,11,286);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16260,98630,to_date('13-JUL-98','DD-MON-RR'),'I',9999,4,60);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11525,22810,to_date('17-JUL-98','DD-MON-RR'),'I',430,13,222.3);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4270,29950,to_date('17-JUL-98','DD-MON-RR'),'T',499,2,50.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4210,18510,to_date('21-JUL-98','DD-MON-RR'),'T',9999,2,18);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2595,42070,to_date('22-JUL-98','DD-MON-RR'),'C',262,6,235.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6920,27920,to_date('23-JUL-98','DD-MON-RR'),'I',391,19,608);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3615,66800,to_date('25-JUL-98','DD-MON-RR'),'I',9999,44,616);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1235,32460,to_date('27-JUL-98','DD-MON-RR'),'S',9999,14,756);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6465,4580,to_date('27-JUL-98','DD-MON-RR'),'P',9999,17,1173);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2915,18510,to_date('27-JUL-98','DD-MON-RR'),'T',9999,2,136);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3200,65010,to_date('29-JUL-98','DD-MON-RR'),'I',211,14,112);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2190,54210,to_date('01-AUG-98','DD-MON-RR'),'S',9999,16,112);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (445,45410,to_date('02-AUG-98','DD-MON-RR'),'C',154,11,431.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2415,9580,to_date('06-AUG-98','DD-MON-RR'),'S',7,19,1179.9);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6005,34340,to_date('08-AUG-98','DD-MON-RR'),'S',475,33,2323.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6815,42900,to_date('10-AUG-98','DD-MON-RR'),'S',9999,24,1656);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3790,45270,to_date('10-AUG-98','DD-MON-RR'),'S',478,12,259.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (20470,55760,to_date('11-AUG-98','DD-MON-RR'),'S',9999,31,992);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4395,17630,to_date('14-AUG-98','DD-MON-RR'),'T',9999,2,98);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4845,200,to_date('14-AUG-98','DD-MON-RR'),'T',475,2,10.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3055,4580,to_date('14-AUG-98','DD-MON-RR'),'P',115,39,491.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9045,149940,to_date('17-AUG-98','DD-MON-RR'),'I',9999,1,39);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4315,140570,to_date('17-AUG-98','DD-MON-RR'),'I',9999,4,144);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (550,430,to_date('18-AUG-98','DD-MON-RR'),'S',9999,5,140);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4105,45270,to_date('18-AUG-98','DD-MON-RR'),'C',442,12,758.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3145,48670,to_date('19-AUG-98','DD-MON-RR'),'S',9999,3,195);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3945,37280,to_date('20-AUG-98','DD-MON-RR'),'I',9999,19,1596);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9400,23270,to_date('20-AUG-98','DD-MON-RR'),'P',9999,11,187);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2885,16420,to_date('20-AUG-98','DD-MON-RR'),'I',226,4,281.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3330,85570,to_date('20-AUG-98','DD-MON-RR'),'S',19,7,491.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2515,49280,to_date('23-AUG-98','DD-MON-RR'),'S',9999,4,60);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11895,118830,to_date('24-AUG-98','DD-MON-RR'),'P',9999,18,288);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1230,2010,to_date('24-AUG-98','DD-MON-RR'),'T',9999,10,560);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10790,47430,to_date('25-AUG-98','DD-MON-RR'),'S',9999,3,585);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3800,1730,to_date('26-AUG-98','DD-MON-RR'),'S',19,46,1490.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2275,63470,to_date('26-AUG-98','DD-MON-RR'),'T',91,2,115.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1365,28350,to_date('27-AUG-98','DD-MON-RR'),'S',9999,2,98);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18205,39750,to_date('27-AUG-98','DD-MON-RR'),'S',9999,2,116);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7420,13640,to_date('28-AUG-98','DD-MON-RR'),'S',9999,9,198);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7605,35860,to_date('30-AUG-98','DD-MON-RR'),'S',9999,39,1482);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6980,40930,to_date('06-SEP-98','DD-MON-RR'),'I',9999,40,1720);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (26380,29950,to_date('09-SEP-98','DD-MON-RR'),'T',9999,2,116);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (280,171730,to_date('14-SEP-98','DD-MON-RR'),'C',9999,35,1575);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3155,12070,to_date('15-SEP-98','DD-MON-RR'),'S',9999,2,104);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9060,16590,to_date('15-SEP-98','DD-MON-RR'),'S',433,8,924);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (105,74360,to_date('19-SEP-98','DD-MON-RR'),'T',9999,7,476);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7845,16090,to_date('19-SEP-98','DD-MON-RR'),'S',49,12,280.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2000,176210,to_date('19-SEP-98','DD-MON-RR'),'C',9999,17,323);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3725,65090,to_date('19-SEP-98','DD-MON-RR'),'C',9999,27,1458);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (480,4470,to_date('20-SEP-98','DD-MON-RR'),'T',9999,2,48);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5530,23960,to_date('21-SEP-98','DD-MON-RR'),'I',241,5,45);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (425,45700,to_date('22-SEP-98','DD-MON-RR'),'C',37,11,1376.1);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (535,34680,to_date('22-SEP-98','DD-MON-RR'),'S',97,14,1234.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4460,35860,to_date('24-SEP-98','DD-MON-RR'),'S',9999,3,144);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3760,33710,to_date('24-SEP-98','DD-MON-RR'),'S',9999,9,405);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (49955,16380,to_date('01-OCT-98','DD-MON-RR'),'C',9999,13,1378);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (470,130130,to_date('01-OCT-98','DD-MON-RR'),'S',9999,24,384);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9615,25900,to_date('04-OCT-98','DD-MON-RR'),'C',385,3,21.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16295,113140,to_date('05-OCT-98','DD-MON-RR'),'P',9999,8,112);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2210,62460,to_date('06-OCT-98','DD-MON-RR'),'S',421,2,10.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3670,64390,to_date('07-OCT-98','DD-MON-RR'),'S',9999,33,8184);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (39705,45270,to_date('09-OCT-98','DD-MON-RR'),'T',9999,2,118);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5430,13000,to_date('11-OCT-98','DD-MON-RR'),'I',469,24,705.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2910,4750,to_date('12-OCT-98','DD-MON-RR'),'S',1,17,612);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2205,52860,to_date('12-OCT-98','DD-MON-RR'),'S',9999,6,42);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (43840,79410,to_date('14-OCT-98','DD-MON-RR'),'P',9999,3,177);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1575,176930,to_date('14-OCT-98','DD-MON-RR'),'P',9999,11,638);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (28955,22330,to_date('16-OCT-98','DD-MON-RR'),'S',9999,11,1188);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5980,6680,to_date('24-OCT-98','DD-MON-RR'),'I',9999,1,9);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (695,36540,to_date('24-OCT-98','DD-MON-RR'),'S',9999,2,26);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2585,24980,to_date('26-OCT-98','DD-MON-RR'),'I',9999,21,1848);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (23005,31270,to_date('26-OCT-98','DD-MON-RR'),'C',9999,18,1764);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2735,13340,to_date('27-OCT-98','DD-MON-RR'),'S',9999,16,768);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4100,4620,to_date('28-OCT-98','DD-MON-RR'),'I',9999,4,240);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10720,12160,to_date('28-OCT-98','DD-MON-RR'),'I',9999,25,625);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10070,24510,to_date('29-OCT-98','DD-MON-RR'),'S',9999,9,792);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3560,113110,to_date('29-OCT-98','DD-MON-RR'),'I',9999,12,432);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (39955,18250,to_date('29-OCT-98','DD-MON-RR'),'S',9999,33,1089);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (600,34710,to_date('29-OCT-98','DD-MON-RR'),'I',9999,8,784);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (37055,141470,to_date('30-OCT-98','DD-MON-RR'),'I',445,19,855.95);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2410,45550,to_date('30-OCT-98','DD-MON-RR'),'C',9999,28,196);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (315,178150,to_date('02-NOV-98','DD-MON-RR'),'S',9999,8,552);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (40895,30350,to_date('06-NOV-98','DD-MON-RR'),'S',9999,22,1452);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9980,67040,to_date('07-NOV-98','DD-MON-RR'),'I',9999,4,192);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9115,8430,to_date('09-NOV-98','DD-MON-RR'),'T',9999,7,448);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7595,40720,to_date('12-NOV-98','DD-MON-RR'),'I',157,1,44);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7725,22940,to_date('12-NOV-98','DD-MON-RR'),'I',9999,19,1121);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2345,51020,to_date('12-NOV-98','DD-MON-RR'),'S',157,2,30.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12925,46080,to_date('12-NOV-98','DD-MON-RR'),'T',9999,10,260);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8075,48390,to_date('14-NOV-98','DD-MON-RR'),'T',9999,3,384);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (450,10930,to_date('14-NOV-98','DD-MON-RR'),'T',1,2,86.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12485,148950,to_date('16-NOV-98','DD-MON-RR'),'T',9999,10,690);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1560,89990,to_date('17-NOV-98','DD-MON-RR'),'I',13,2,1071);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2135,138090,to_date('18-NOV-98','DD-MON-RR'),'T',9999,2,74);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16040,48040,to_date('18-NOV-98','DD-MON-RR'),'S',9999,8,64);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9690,5560,to_date('19-NOV-98','DD-MON-RR'),'S',457,3,54.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2625,22800,to_date('19-NOV-98','DD-MON-RR'),'S',265,8,377.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (28745,74400,to_date('20-NOV-98','DD-MON-RR'),'P',9999,18,2304);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3250,38970,to_date('21-NOV-98','DD-MON-RR'),'I',9999,12,1500);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (80,18880,to_date('21-NOV-98','DD-MON-RR'),'C',9999,12,408);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2190,79000,to_date('23-NOV-98','DD-MON-RR'),'I',9999,20,140);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (26900,128020,to_date('23-NOV-98','DD-MON-RR'),'T',9999,2,30);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7525,770,to_date('23-NOV-98','DD-MON-RR'),'S',9999,34,850);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13075,9580,to_date('24-NOV-98','DD-MON-RR'),'I',9999,8,336);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (43500,75300,to_date('28-NOV-98','DD-MON-RR'),'I',9999,8,320);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (270,27550,to_date('28-NOV-98','DD-MON-RR'),'T',25,5,396);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4340,23030,to_date('02-DEC-98','DD-MON-RR'),'P',9999,5,225);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (435,157820,to_date('03-DEC-98','DD-MON-RR'),'I',9999,19,1748);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2620,1970,to_date('06-DEC-98','DD-MON-RR'),'I',9999,16,1424);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9295,24000,to_date('06-DEC-98','DD-MON-RR'),'S',9999,34,612);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (24330,25400,to_date('08-DEC-98','DD-MON-RR'),'I',9999,17,1156);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2860,45530,to_date('08-DEC-98','DD-MON-RR'),'P',9999,11,528);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2400,8370,to_date('09-DEC-98','DD-MON-RR'),'S',9999,13,91);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4030,4880,to_date('09-DEC-98','DD-MON-RR'),'P',9999,7,70);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (20160,7200,to_date('09-DEC-98','DD-MON-RR'),'S',9999,1,18);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (36450,23030,to_date('11-DEC-98','DD-MON-RR'),'P',9999,8,272);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1175,146640,to_date('13-DEC-98','DD-MON-RR'),'S',9999,4,424);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5605,30960,to_date('14-DEC-98','DD-MON-RR'),'S',9999,7,826);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2860,80260,to_date('15-DEC-98','DD-MON-RR'),'S',9999,3,144);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2020,16340,to_date('16-DEC-98','DD-MON-RR'),'I',9999,1,19);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2185,84480,to_date('16-DEC-98','DD-MON-RR'),'S',9999,9,2502);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (19780,69350,to_date('17-DEC-98','DD-MON-RR'),'S',9999,20,980);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (315,178150,to_date('18-DEC-98','DD-MON-RR'),'S',9999,16,1104);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3810,34340,to_date('24-DEC-98','DD-MON-RR'),'S',9999,11,286);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (22470,157940,to_date('25-DEC-98','DD-MON-RR'),'S',9999,13,1430);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6030,5330,to_date('27-DEC-98','DD-MON-RR'),'C',9999,46,874);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2735,6000,to_date('28-DEC-98','DD-MON-RR'),'C',9999,6,288);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1575,45810,to_date('28-DEC-98','DD-MON-RR'),'S',9999,3,174);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2070,55690,to_date('28-DEC-98','DD-MON-RR'),'I',9999,4,432);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (32565,44100,to_date('29-DEC-98','DD-MON-RR'),'T',9999,10,790);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7810,18330,to_date('30-DEC-98','DD-MON-RR'),'I',9999,4,124);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (29245,10190,to_date('01-JAN-99','DD-MON-RR'),'C',9999,14,756);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (30,5010,to_date('02-JAN-99','DD-MON-RR'),'S',9999,35,490);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1900,34700,to_date('04-JAN-99','DD-MON-RR'),'I',9999,13,117);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8160,138090,to_date('05-JAN-99','DD-MON-RR'),'S',9999,38,1596);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3695,1100,to_date('05-JAN-99','DD-MON-RR'),'S',9999,26,832);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2030,28350,to_date('06-JAN-99','DD-MON-RR'),'S',9999,29,551);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5380,48180,to_date('06-JAN-99','DD-MON-RR'),'T',9999,2,164);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15600,63480,to_date('08-JAN-99','DD-MON-RR'),'S',47,19,923.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (27105,18860,to_date('10-JAN-99','DD-MON-RR'),'S',9999,2,128);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17250,134430,to_date('12-JAN-99','DD-MON-RR'),'I',9999,20,840);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1920,35510,to_date('12-JAN-99','DD-MON-RR'),'S',9999,1,9);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (32315,3220,to_date('13-JAN-99','DD-MON-RR'),'I',9999,14,112);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10395,4750,to_date('13-JAN-99','DD-MON-RR'),'S',9999,2,78);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7685,2580,to_date('13-JAN-99','DD-MON-RR'),'T',9999,3,147);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1425,16920,to_date('14-JAN-99','DD-MON-RR'),'I',9999,4,76);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1210,40020,to_date('16-JAN-99','DD-MON-RR'),'S',9999,14,966);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (295,57730,to_date('16-JAN-99','DD-MON-RR'),'S',23,2,124.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (32950,22760,to_date('18-JAN-99','DD-MON-RR'),'S',23,34,2386.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4365,34710,to_date('18-JAN-99','DD-MON-RR'),'T',59,5,441);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3170,41060,to_date('19-JAN-99','DD-MON-RR'),'S',9999,13,1144);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (43095,8800,to_date('20-JAN-99','DD-MON-RR'),'C',9999,16,624);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18225,89870,to_date('21-JAN-99','DD-MON-RR'),'T',9999,3,114);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7030,46730,to_date('22-JAN-99','DD-MON-RR'),'S',347,3,172.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1805,139450,to_date('22-JAN-99','DD-MON-RR'),'S',9999,3,1185);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (39340,27320,to_date('22-JAN-99','DD-MON-RR'),'C',9999,22,440);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3070,21920,to_date('25-JAN-99','DD-MON-RR'),'S',9999,26,1794);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2500,33930,to_date('25-JAN-99','DD-MON-RR'),'T',347,7,347.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (24595,8020,to_date('25-JAN-99','DD-MON-RR'),'I',9999,1,42);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4520,61780,to_date('25-JAN-99','DD-MON-RR'),'C',9999,13,338);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8345,8850,to_date('28-JAN-99','DD-MON-RR'),'I',9999,1,4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (685,15120,to_date('30-JAN-99','DD-MON-RR'),'S',167,17,571.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (910,69500,to_date('01-FEB-99','DD-MON-RR'),'T',119,7,50.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1170,11850,to_date('02-FEB-99','DD-MON-RR'),'S',9999,14,1484);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5650,12010,to_date('02-FEB-99','DD-MON-RR'),'S',395,14,1232);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11635,5560,to_date('06-FEB-99','DD-MON-RR'),'I',59,8,50.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8955,30100,to_date('08-FEB-99','DD-MON-RR'),'I',9999,41,7708);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (100,2470,to_date('08-FEB-99','DD-MON-RR'),'I',9999,6,408);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2415,109310,to_date('09-FEB-99','DD-MON-RR'),'P',9999,18,1242);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1310,50950,to_date('09-FEB-99','DD-MON-RR'),'I',419,18,688.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (540,81570,to_date('10-FEB-99','DD-MON-RR'),'C',9999,14,392);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1315,58940,to_date('10-FEB-99','DD-MON-RR'),'S',9999,33,1485);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8755,10410,to_date('11-FEB-99','DD-MON-RR'),'I',419,33,658.35);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2045,121820,to_date('13-FEB-99','DD-MON-RR'),'I',9999,11,715);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (145,55420,to_date('17-FEB-99','DD-MON-RR'),'I',455,17,326.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2760,34770,to_date('18-FEB-99','DD-MON-RR'),'I',9999,7,483);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4870,71250,to_date('23-FEB-99','DD-MON-RR'),'S',9999,1,59);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (465,109850,to_date('23-FEB-99','DD-MON-RR'),'S',9999,4,196);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1835,125910,to_date('24-FEB-99','DD-MON-RR'),'I',191,13,530.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2240,45820,to_date('24-FEB-99','DD-MON-RR'),'I',143,11,415.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2340,58840,to_date('24-FEB-99','DD-MON-RR'),'S',419,1,140);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5340,22810,to_date('25-FEB-99','DD-MON-RR'),'C',9999,12,720);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8315,5900,to_date('26-FEB-99','DD-MON-RR'),'C',9999,17,782);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1510,11110,to_date('27-FEB-99','DD-MON-RR'),'S',9999,29,1305);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6420,740,to_date('27-FEB-99','DD-MON-RR'),'S',191,27,626.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5050,12760,to_date('27-FEB-99','DD-MON-RR'),'S',9999,20,1280);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12985,92290,to_date('01-MAR-99','DD-MON-RR'),'I',9999,12,432);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2070,79580,to_date('01-MAR-99','DD-MON-RR'),'I',9999,11,1188);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8105,28710,to_date('02-MAR-99','DD-MON-RR'),'P',9999,8,552);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2865,11400,to_date('03-MAR-99','DD-MON-RR'),'S',9999,2,270);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4385,25400,to_date('03-MAR-99','DD-MON-RR'),'C',9999,7,686);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8140,42920,to_date('03-MAR-99','DD-MON-RR'),'I',11,14,4977);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6940,9670,to_date('04-MAR-99','DD-MON-RR'),'I',89,38,4617);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15705,79410,to_date('06-MAR-99','DD-MON-RR'),'I',9999,19,171);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (990,69500,to_date('08-MAR-99','DD-MON-RR'),'C',9999,14,896);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8685,8870,to_date('08-MAR-99','DD-MON-RR'),'S',167,4,384);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1580,160950,to_date('09-MAR-99','DD-MON-RR'),'T',359,2,22.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1085,76220,to_date('10-MAR-99','DD-MON-RR'),'C',9999,14,2520);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6195,15250,to_date('10-MAR-99','DD-MON-RR'),'S',9999,18,198);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3885,43350,to_date('10-MAR-99','DD-MON-RR'),'P',9999,24,1656);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7620,73340,to_date('11-MAR-99','DD-MON-RR'),'S',251,3,249.9);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7870,15120,to_date('12-MAR-99','DD-MON-RR'),'C',9999,7,182);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2075,19900,to_date('13-MAR-99','DD-MON-RR'),'S',9999,13,1092);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8555,17660,to_date('14-MAR-99','DD-MON-RR'),'P',9999,18,2502);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7015,46840,to_date('14-MAR-99','DD-MON-RR'),'I',9999,19,171);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (870,22390,to_date('16-MAR-99','DD-MON-RR'),'T',9999,7,413);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6400,6680,to_date('18-MAR-99','DD-MON-RR'),'P',9999,18,342);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5200,67620,to_date('19-MAR-99','DD-MON-RR'),'I',467,30,832.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3035,10660,to_date('23-MAR-99','DD-MON-RR'),'I',335,24,806.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1400,79070,to_date('23-MAR-99','DD-MON-RR'),'I',9999,1,6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (43700,33600,to_date('26-MAR-99','DD-MON-RR'),'S',9999,9,126);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7260,9330,to_date('26-MAR-99','DD-MON-RR'),'S',77,4,36);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2305,42920,to_date('26-MAR-99','DD-MON-RR'),'I',9999,1,58);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13930,5490,to_date('27-MAR-99','DD-MON-RR'),'I',9999,1,48);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4190,12680,to_date('28-MAR-99','DD-MON-RR'),'T',9999,3,21);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (210,6900,to_date('29-MAR-99','DD-MON-RR'),'I',185,11,35.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1025,56000,to_date('29-MAR-99','DD-MON-RR'),'S',9999,2,24);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10785,6790,to_date('01-APR-99','DD-MON-RR'),'T',9999,2,24);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2445,12570,to_date('02-APR-99','DD-MON-RR'),'C',9999,7,273);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16180,74400,to_date('02-APR-99','DD-MON-RR'),'I',9999,41,697);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2100,8750,to_date('04-APR-99','DD-MON-RR'),'I',9999,19,1292);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3940,54410,to_date('07-APR-99','DD-MON-RR'),'S',9999,2,140);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (735,34710,to_date('08-APR-99','DD-MON-RR'),'S',347,9,1260);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3565,16470,to_date('09-APR-99','DD-MON-RR'),'S',9999,2,330);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10,178160,to_date('09-APR-99','DD-MON-RR'),'S',9999,23,4025);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14760,66520,to_date('11-APR-99','DD-MON-RR'),'I',347,4,284.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2635,65010,to_date('12-APR-99','DD-MON-RR'),'S',9999,2,6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (865,65860,to_date('16-APR-99','DD-MON-RR'),'C',9999,7,378);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7525,21090,to_date('17-APR-99','DD-MON-RR'),'S',9999,2,50);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4605,13340,to_date('19-APR-99','DD-MON-RR'),'I',2,19,923.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11780,5410,to_date('19-APR-99','DD-MON-RR'),'I',9999,10,690);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1675,16340,to_date('20-APR-99','DD-MON-RR'),'T',419,10,472);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16540,132610,to_date('21-APR-99','DD-MON-RR'),'I',194,30,480);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7790,20130,to_date('21-APR-99','DD-MON-RR'),'P',9999,11,638);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (220,74590,to_date('21-APR-99','DD-MON-RR'),'P',9999,3,12);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2415,33560,to_date('21-APR-99','DD-MON-RR'),'S',9999,2,138);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3585,50750,to_date('22-APR-99','DD-MON-RR'),'P',9999,12,1428);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15910,90640,to_date('23-APR-99','DD-MON-RR'),'T',9999,7,224);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1605,27350,to_date('25-APR-99','DD-MON-RR'),'T',9999,5,195);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2370,29790,to_date('26-APR-99','DD-MON-RR'),'I',9999,12,312);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2815,54410,to_date('26-APR-99','DD-MON-RR'),'T',329,2,44.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (360,45820,to_date('26-APR-99','DD-MON-RR'),'C',9999,20,860);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1750,46910,to_date('28-APR-99','DD-MON-RR'),'I',305,21,1852.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11505,22670,to_date('02-MAY-99','DD-MON-RR'),'C',9999,16,1424);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10650,49600,to_date('04-MAY-99','DD-MON-RR'),'I',9999,38,1596);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1815,52330,to_date('04-MAY-99','DD-MON-RR'),'S',9999,16,272);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7095,45810,to_date('05-MAY-99','DD-MON-RR'),'I',350,5,168);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5070,28330,to_date('05-MAY-99','DD-MON-RR'),'S',9999,2,156);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9805,29960,to_date('06-MAY-99','DD-MON-RR'),'S',9999,4,236);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7125,12160,to_date('08-MAY-99','DD-MON-RR'),'P',497,8,338);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4870,68530,to_date('09-MAY-99','DD-MON-RR'),'S',9999,29,1711);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (460,22420,to_date('10-MAY-99','DD-MON-RR'),'S',9999,1,49);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8915,18260,to_date('11-MAY-99','DD-MON-RR'),'I',9999,21,819);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3040,4240,to_date('13-MAY-99','DD-MON-RR'),'I',9999,26,1014);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1750,71010,to_date('13-MAY-99','DD-MON-RR'),'I',9999,21,2058);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1240,43910,to_date('14-MAY-99','DD-MON-RR'),'C',9999,46,3634);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4525,75880,to_date('15-MAY-99','DD-MON-RR'),'I',9999,29,754);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11865,14250,to_date('18-MAY-99','DD-MON-RR'),'I',497,1,34.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (835,6030,to_date('18-MAY-99','DD-MON-RR'),'S',9999,35,2065);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1195,79180,to_date('19-MAY-99','DD-MON-RR'),'T',9999,10,690);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1990,34700,to_date('21-MAY-99','DD-MON-RR'),'S',9999,13,832);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1505,8800,to_date('21-MAY-99','DD-MON-RR'),'S',9999,37,1665);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13470,10410,to_date('22-MAY-99','DD-MON-RR'),'P',9999,12,720);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9790,19520,to_date('22-MAY-99','DD-MON-RR'),'S',9999,15,720);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (885,74620,to_date('22-MAY-99','DD-MON-RR'),'S',9999,24,456);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2015,11320,to_date('26-MAY-99','DD-MON-RR'),'T',290,5,85.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1605,19900,to_date('27-MAY-99','DD-MON-RR'),'S',9999,3,117);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3310,49620,to_date('27-MAY-99','DD-MON-RR'),'I',9999,12,144);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18170,51760,to_date('28-MAY-99','DD-MON-RR'),'T',9999,7,294);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2575,17730,to_date('30-MAY-99','DD-MON-RR'),'S',9999,4,196);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7040,16480,to_date('01-JUN-99','DD-MON-RR'),'T',9999,10,120);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8540,6120,to_date('01-JUN-99','DD-MON-RR'),'I',9999,12,1668);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6615,40720,to_date('05-JUN-99','DD-MON-RR'),'S',9999,22,1144);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5210,12680,to_date('05-JUN-99','DD-MON-RR'),'I',9999,17,629);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7845,23880,to_date('06-JUN-99','DD-MON-RR'),'S',473,24,436.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1100,188700,to_date('08-JUN-99','DD-MON-RR'),'S',9999,33,2277);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1505,9490,to_date('08-JUN-99','DD-MON-RR'),'I',242,11,396);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (44775,22810,to_date('09-JUN-99','DD-MON-RR'),'S',9999,2,158);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2520,16420,to_date('09-JUN-99','DD-MON-RR'),'I',341,21,283.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (395,70680,to_date('11-JUN-99','DD-MON-RR'),'I',9999,1,139);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15535,124300,to_date('12-JUN-99','DD-MON-RR'),'S',305,6,302.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1075,31590,to_date('14-JUN-99','DD-MON-RR'),'S',9999,9,441);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3670,45700,to_date('14-JUN-99','DD-MON-RR'),'S',9999,21,5208);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4840,25290,to_date('14-JUN-99','DD-MON-RR'),'C',341,27,1468.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4520,84700,to_date('17-JUN-99','DD-MON-RR'),'C',98,6,140.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1485,168170,to_date('17-JUN-99','DD-MON-RR'),'S',341,23,165.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2125,45710,to_date('18-JUN-99','DD-MON-RR'),'S',62,20,1152);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5505,21920,to_date('24-JUN-99','DD-MON-RR'),'T',9999,10,380);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1150,44100,to_date('27-JUN-99','DD-MON-RR'),'C',9999,7,630);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6135,128090,to_date('27-JUN-99','DD-MON-RR'),'I',302,8,243.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1395,20860,to_date('28-JUN-99','DD-MON-RR'),'C',281,7,33.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (19340,2080,to_date('29-JUN-99','DD-MON-RR'),'C',9999,7,455);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (560,157230,to_date('02-JUL-99','DD-MON-RR'),'T',350,10,512);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1315,55770,to_date('02-JUL-99','DD-MON-RR'),'P',482,3,114.75);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3485,55360,to_date('03-JUL-99','DD-MON-RR'),'T',9999,2,64);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1415,131710,to_date('04-JUL-99','DD-MON-RR'),'S',9999,1,59);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1220,49410,to_date('06-JUL-99','DD-MON-RR'),'T',9999,3,204);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4805,20190,to_date('09-JUL-99','DD-MON-RR'),'S',9999,33,1980);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1750,150900,to_date('14-JUL-99','DD-MON-RR'),'C',434,12,1058.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10060,28810,to_date('14-JUL-99','DD-MON-RR'),'C',9999,27,2943);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2780,68240,to_date('14-JUL-99','DD-MON-RR'),'S',9999,20,400);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6155,30960,to_date('14-JUL-99','DD-MON-RR'),'S',9999,35,2940);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (250,30720,to_date('17-JUL-99','DD-MON-RR'),'C',9999,5,140);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3045,11400,to_date('17-JUL-99','DD-MON-RR'),'I',9999,29,4002);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8725,3610,to_date('18-JUL-99','DD-MON-RR'),'S',146,42,3704.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2920,49480,to_date('25-JUL-99','DD-MON-RR'),'S',9999,2,86);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1525,75880,to_date('25-JUL-99','DD-MON-RR'),'I',9999,12,528);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (40425,49080,to_date('26-JUL-99','DD-MON-RR'),'I',9999,8,64);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2210,3970,to_date('27-JUL-99','DD-MON-RR'),'S',9999,19,133);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6250,6910,to_date('28-JUL-99','DD-MON-RR'),'P',9999,18,5004);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3840,7980,to_date('29-JUL-99','DD-MON-RR'),'S',9999,2,550);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1580,22160,to_date('29-JUL-99','DD-MON-RR'),'T',9999,2,28);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1515,175370,to_date('01-AUG-99','DD-MON-RR'),'C',9999,7,63);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4950,1110,to_date('02-AUG-99','DD-MON-RR'),'S',9999,4,76);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2840,21770,to_date('02-AUG-99','DD-MON-RR'),'S',9999,2,370);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (43565,23240,to_date('03-AUG-99','DD-MON-RR'),'P',9999,12,708);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4750,930,to_date('03-AUG-99','DD-MON-RR'),'I',9999,1,42);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1065,55370,to_date('05-AUG-99','DD-MON-RR'),'C',9999,8,1440);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16640,23140,to_date('06-AUG-99','DD-MON-RR'),'S',9999,26,988);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12085,13640,to_date('06-AUG-99','DD-MON-RR'),'S',9999,4,192);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1740,2340,to_date('09-AUG-99','DD-MON-RR'),'T',9999,5,240);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5445,45810,to_date('13-AUG-99','DD-MON-RR'),'I',9999,11,539);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3060,16720,to_date('14-AUG-99','DD-MON-RR'),'P',9999,17,1105);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6940,43170,to_date('15-AUG-99','DD-MON-RR'),'S',9999,1,135);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (515,43350,to_date('15-AUG-99','DD-MON-RR'),'S',9999,2,56);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8690,18670,to_date('19-AUG-99','DD-MON-RR'),'P',9999,7,434);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (625,168920,to_date('24-AUG-99','DD-MON-RR'),'S',9999,33,1122);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6985,124300,to_date('25-AUG-99','DD-MON-RR'),'I',9999,19,817);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (19795,11470,to_date('26-AUG-99','DD-MON-RR'),'P',9999,8,736);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1670,45900,to_date('26-AUG-99','DD-MON-RR'),'S',9999,21,1239);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4585,11840,to_date('27-AUG-99','DD-MON-RR'),'P',9999,8,864);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7800,25800,to_date('28-AUG-99','DD-MON-RR'),'S',9999,18,1044);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14775,16760,to_date('28-AUG-99','DD-MON-RR'),'S',9999,4,352);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2705,66700,to_date('28-AUG-99','DD-MON-RR'),'I',9999,7,196);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18880,74400,to_date('30-AUG-99','DD-MON-RR'),'S',9999,28,1652);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2695,82190,to_date('04-SEP-99','DD-MON-RR'),'P',9999,11,198);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4475,43870,to_date('04-SEP-99','DD-MON-RR'),'C',9999,1,139);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12640,132370,to_date('05-SEP-99','DD-MON-RR'),'S',9999,2,98);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2660,46610,to_date('06-SEP-99','DD-MON-RR'),'I',9999,4,780);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (565,62010,to_date('07-SEP-99','DD-MON-RR'),'P',9999,3,360);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5140,71610,to_date('08-SEP-99','DD-MON-RR'),'I',9999,4,196);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2675,62650,to_date('09-SEP-99','DD-MON-RR'),'C',9999,3,294);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9660,47520,to_date('10-SEP-99','DD-MON-RR'),'I',9999,8,592);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12575,146460,to_date('10-SEP-99','DD-MON-RR'),'P',9999,31,1178);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1030,33540,to_date('11-SEP-99','DD-MON-RR'),'I',9999,1,12);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (485,88340,to_date('11-SEP-99','DD-MON-RR'),'I',9999,1,24);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (200,6770,to_date('12-SEP-99','DD-MON-RR'),'I',9999,21,966);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8725,24550,to_date('14-SEP-99','DD-MON-RR'),'I',9999,21,2058);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4080,47740,to_date('14-SEP-99','DD-MON-RR'),'C',9999,6,78);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3455,74190,to_date('17-SEP-99','DD-MON-RR'),'C',9999,13,624);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (38235,171730,to_date('19-SEP-99','DD-MON-RR'),'I',9999,8,472);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2385,23960,to_date('20-SEP-99','DD-MON-RR'),'P',9999,3,114);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16540,74400,to_date('21-SEP-99','DD-MON-RR'),'I',9999,11,220);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (435,17920,to_date('21-SEP-99','DD-MON-RR'),'S',9999,14,1288);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2155,30960,to_date('22-SEP-99','DD-MON-RR'),'C',9999,12,1320);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (695,59250,to_date('23-SEP-99','DD-MON-RR'),'S',9999,34,442);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (235,117200,to_date('24-SEP-99','DD-MON-RR'),'S',9999,27,2052);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1475,44040,to_date('27-SEP-99','DD-MON-RR'),'C',9999,24,960);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (265,109490,to_date('01-OCT-99','DD-MON-RR'),'T',9999,7,336);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18655,3820,to_date('02-OCT-99','DD-MON-RR'),'C',9999,17,2346);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2070,49390,to_date('03-OCT-99','DD-MON-RR'),'I',9999,4,432);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1750,13100,to_date('04-OCT-99','DD-MON-RR'),'C',9999,7,686);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (33085,17920,to_date('05-OCT-99','DD-MON-RR'),'S',9999,2,240);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3510,27320,to_date('06-OCT-99','DD-MON-RR'),'S',9999,6,750);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (31245,65010,to_date('07-OCT-99','DD-MON-RR'),'T',9999,2,290);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (44385,9440,to_date('09-OCT-99','DD-MON-RR'),'S',9999,3,162);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16505,2340,to_date('10-OCT-99','DD-MON-RR'),'I',9999,29,1392);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2255,41650,to_date('12-OCT-99','DD-MON-RR'),'C',9999,22,858);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8805,19480,to_date('12-OCT-99','DD-MON-RR'),'S',9999,12,1416);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (47425,24680,to_date('12-OCT-99','DD-MON-RR'),'S',9999,21,588);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9935,47740,to_date('12-OCT-99','DD-MON-RR'),'C',9999,7,119);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6335,7000,to_date('13-OCT-99','DD-MON-RR'),'S',9999,9,621);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2370,16380,to_date('14-OCT-99','DD-MON-RR'),'I',9999,19,494);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (44720,6440,to_date('15-OCT-99','DD-MON-RR'),'I',9999,24,360);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8205,8020,to_date('15-OCT-99','DD-MON-RR'),'S',9999,9,306);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (200,8430,to_date('16-OCT-99','DD-MON-RR'),'S',9999,3,138);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14505,26450,to_date('17-OCT-99','DD-MON-RR'),'T',9999,2,152);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1290,42270,to_date('17-OCT-99','DD-MON-RR'),'I',9999,11,638);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9790,35130,to_date('20-OCT-99','DD-MON-RR'),'I',9999,14,672);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7515,7020,to_date('20-OCT-99','DD-MON-RR'),'C',9999,7,175);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9545,9700,to_date('21-OCT-99','DD-MON-RR'),'I',9999,38,2964);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1310,24410,to_date('24-OCT-99','DD-MON-RR'),'T',9999,2,90);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9180,9860,to_date('24-OCT-99','DD-MON-RR'),'S',9999,8,200);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (300,55360,to_date('25-OCT-99','DD-MON-RR'),'T',9999,2,196);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2490,7450,to_date('25-OCT-99','DD-MON-RR'),'C',9999,6,114);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16870,49620,to_date('29-OCT-99','DD-MON-RR'),'S',9999,34,340);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14830,63470,to_date('30-OCT-99','DD-MON-RR'),'I',9999,17,1326);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11285,8850,to_date('30-OCT-99','DD-MON-RR'),'S',9999,26,260);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (32785,92640,to_date('30-OCT-99','DD-MON-RR'),'C',9999,7,252);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4135,27350,to_date('01-NOV-99','DD-MON-RR'),'S',9999,2,28);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2145,3870,to_date('02-NOV-99','DD-MON-RR'),'C',9999,28,3080);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7635,31840,to_date('02-NOV-99','DD-MON-RR'),'I',9999,20,180);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12035,43070,to_date('03-NOV-99','DD-MON-RR'),'I',9999,4,72);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2230,138090,to_date('03-NOV-99','DD-MON-RR'),'S',9999,37,1554);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7990,45210,to_date('03-NOV-99','DD-MON-RR'),'S',9999,33,1188);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3950,570,to_date('04-NOV-99','DD-MON-RR'),'S',9999,27,1296);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4095,26120,to_date('04-NOV-99','DD-MON-RR'),'I',9999,38,1596);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (27295,21880,to_date('04-NOV-99','DD-MON-RR'),'P',9999,8,320);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12070,19220,to_date('04-NOV-99','DD-MON-RR'),'C',9999,28,4144);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13675,46910,to_date('04-NOV-99','DD-MON-RR'),'P',9999,31,1674);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1670,150900,to_date('05-NOV-99','DD-MON-RR'),'S',9999,2,118);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2445,14300,to_date('05-NOV-99','DD-MON-RR'),'C',9999,7,273);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8605,27090,to_date('05-NOV-99','DD-MON-RR'),'C',9999,12,588);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (49330,8890,to_date('07-NOV-99','DD-MON-RR'),'I',9999,11,1452);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3040,550,to_date('11-NOV-99','DD-MON-RR'),'S',9999,37,1443);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3775,10660,to_date('11-NOV-99','DD-MON-RR'),'S',9999,3,177);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4355,40180,to_date('13-NOV-99','DD-MON-RR'),'C',9999,12,828);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2780,11680,to_date('14-NOV-99','DD-MON-RR'),'S',9999,27,540);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10450,5080,to_date('14-NOV-99','DD-MON-RR'),'C',9999,17,816);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1685,157230,to_date('15-NOV-99','DD-MON-RR'),'S',9999,22,858);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1900,158430,to_date('16-NOV-99','DD-MON-RR'),'S',9999,34,306);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (37285,22000,to_date('17-NOV-99','DD-MON-RR'),'S',9999,11,286);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (26080,6280,to_date('18-NOV-99','DD-MON-RR'),'T',9999,2,28);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15285,9370,to_date('18-NOV-99','DD-MON-RR'),'I',9999,27,1593);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9745,29260,to_date('18-NOV-99','DD-MON-RR'),'S',9999,1,145);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (26200,65830,to_date('19-NOV-99','DD-MON-RR'),'C',9999,4,68);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1840,5040,to_date('19-NOV-99','DD-MON-RR'),'T',9999,5,145);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4255,49410,to_date('20-NOV-99','DD-MON-RR'),'I',9999,19,874);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11065,10000,to_date('20-NOV-99','DD-MON-RR'),'S',9999,2,118);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (26200,101150,to_date('21-NOV-99','DD-MON-RR'),'I',9999,19,323);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1425,22970,to_date('24-NOV-99','DD-MON-RR'),'I',9999,18,342);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2785,13340,to_date('25-NOV-99','DD-MON-RR'),'S',9999,1,69);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (41575,8900,to_date('25-NOV-99','DD-MON-RR'),'S',9999,34,680);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6840,28560,to_date('26-NOV-99','DD-MON-RR'),'I',9999,6,120);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15280,132370,to_date('26-NOV-99','DD-MON-RR'),'T',9999,7,553);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (205,147160,to_date('26-NOV-99','DD-MON-RR'),'P',9999,8,528);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4225,43430,to_date('26-NOV-99','DD-MON-RR'),'I',9999,17,1428);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (40395,10930,to_date('27-NOV-99','DD-MON-RR'),'S',9999,3,78);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11185,14300,to_date('29-NOV-99','DD-MON-RR'),'S',9999,1,138);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6170,22130,to_date('04-DEC-99','DD-MON-RR'),'I',9999,21,1848);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3845,65930,to_date('04-DEC-99','DD-MON-RR'),'S',9999,4,32);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (25025,29260,to_date('04-DEC-99','DD-MON-RR'),'S',9999,34,714);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2755,30750,to_date('04-DEC-99','DD-MON-RR'),'S',9999,9,621);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (26895,29300,to_date('04-DEC-99','DD-MON-RR'),'S',9999,24,1488);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2710,13100,to_date('05-DEC-99','DD-MON-RR'),'I',9999,12,336);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2770,6440,to_date('06-DEC-99','DD-MON-RR'),'P',9999,12,240);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11785,16140,to_date('07-DEC-99','DD-MON-RR'),'S',9999,37,1184);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17505,44520,to_date('08-DEC-99','DD-MON-RR'),'C',9999,11,209);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (970,11320,to_date('11-DEC-99','DD-MON-RR'),'P',9999,44,1716);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12910,137850,to_date('11-DEC-99','DD-MON-RR'),'S',9999,2,52);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7860,36010,to_date('13-DEC-99','DD-MON-RR'),'I',9999,21,2310);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8680,27550,to_date('16-DEC-99','DD-MON-RR'),'S',9999,2,56);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (85,14680,to_date('18-DEC-99','DD-MON-RR'),'I',9999,11,1298);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9480,12670,to_date('18-DEC-99','DD-MON-RR'),'I',9999,21,1176);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2305,16140,to_date('18-DEC-99','DD-MON-RR'),'S',9999,9,522);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8345,38620,to_date('18-DEC-99','DD-MON-RR'),'S',9999,26,104);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12485,24670,to_date('19-DEC-99','DD-MON-RR'),'T',9999,2,138);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1015,68100,to_date('19-DEC-99','DD-MON-RR'),'C',9999,35,350);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1210,139450,to_date('20-DEC-99','DD-MON-RR'),'S',9999,26,1794);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1275,22300,to_date('21-DEC-99','DD-MON-RR'),'I',9999,19,1482);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8075,20000,to_date('22-DEC-99','DD-MON-RR'),'S',9999,9,1152);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8545,19630,to_date('24-DEC-99','DD-MON-RR'),'S',9999,8,792);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10545,88620,to_date('26-DEC-99','DD-MON-RR'),'I',9999,21,1449);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (910,51760,to_date('28-DEC-99','DD-MON-RR'),'S',9999,2,16);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (430,188700,to_date('28-DEC-99','DD-MON-RR'),'I',9999,1,155);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2620,79580,to_date('28-DEC-99','DD-MON-RR'),'S',9999,9,801);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2230,32460,to_date('30-DEC-99','DD-MON-RR'),'C',9999,17,714);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (485,139450,to_date('30-DEC-99','DD-MON-RR'),'S',9999,2,48);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3985,20000,to_date('01-JAN-00','DD-MON-RR'),'I',9999,18,306);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1645,21090,to_date('02-JAN-00','DD-MON-RR'),'S',9999,8,384);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (32180,37670,to_date('04-JAN-00','DD-MON-RR'),'I',9999,17,527);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4095,74820,to_date('05-JAN-00','DD-MON-RR'),'P',9999,3,126);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5010,8430,to_date('05-JAN-00','DD-MON-RR'),'I',9999,19,1254);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6145,20370,to_date('05-JAN-00','DD-MON-RR'),'S',9999,6,504);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2410,35180,to_date('06-JAN-00','DD-MON-RR'),'T',9999,7,49);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (24410,8480,to_date('07-JAN-00','DD-MON-RR'),'I',9999,7,98);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9760,40930,to_date('07-JAN-00','DD-MON-RR'),'T',9999,5,45);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (515,20660,to_date('08-JAN-00','DD-MON-RR'),'I',9999,12,336);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (47740,16190,to_date('08-JAN-00','DD-MON-RR'),'I',9999,6,252);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5210,42030,to_date('10-JAN-00','DD-MON-RR'),'S',9999,7,259);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1925,76930,to_date('11-JAN-00','DD-MON-RR'),'I',9999,21,189);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6855,33930,to_date('13-JAN-00','DD-MON-RR'),'I',9999,6,414);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3210,17060,to_date('13-JAN-00','DD-MON-RR'),'S',9999,15,1035);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6950,4900,to_date('13-JAN-00','DD-MON-RR'),'P',9999,8,704);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13010,48040,to_date('14-JAN-00','DD-MON-RR'),'P',9999,1,59);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7890,1340,to_date('15-JAN-00','DD-MON-RR'),'I',9999,11,616);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (33205,48460,to_date('16-JAN-00','DD-MON-RR'),'P',9999,6,78);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (47425,46730,to_date('17-JAN-00','DD-MON-RR'),'I',9999,11,308);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18640,30680,to_date('19-JAN-00','DD-MON-RR'),'C',9999,14,1932);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3980,39820,to_date('20-JAN-00','DD-MON-RR'),'I',9999,21,357);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (40870,142640,to_date('22-JAN-00','DD-MON-RR'),'T',9999,2,8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (33085,61720,to_date('23-JAN-00','DD-MON-RR'),'S',9999,14,1680);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4800,22300,to_date('23-JAN-00','DD-MON-RR'),'I',9999,4,1460);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11630,13850,to_date('25-JAN-00','DD-MON-RR'),'S',9999,4,28);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8815,135970,to_date('26-JAN-00','DD-MON-RR'),'S',9999,2,26);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5280,22800,to_date('26-JAN-00','DD-MON-RR'),'I',9999,11,616);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6730,34940,to_date('26-JAN-00','DD-MON-RR'),'S',9999,25,1475);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4095,4950,to_date('27-JAN-00','DD-MON-RR'),'T',9999,2,84);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14970,79070,to_date('27-JAN-00','DD-MON-RR'),'S',9999,24,480);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (23620,6890,to_date('27-JAN-00','DD-MON-RR'),'P',9999,3,114);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6290,41500,to_date('28-JAN-00','DD-MON-RR'),'P',9999,8,336);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4295,20130,to_date('28-JAN-00','DD-MON-RR'),'S',9999,8,32);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (26180,15230,to_date('30-JAN-00','DD-MON-RR'),'S',9999,4,68);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4395,43680,to_date('30-JAN-00','DD-MON-RR'),'C',9999,14,686);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1220,43350,to_date('30-JAN-00','DD-MON-RR'),'C',9999,13,884);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14245,148880,to_date('30-JAN-00','DD-MON-RR'),'P',9999,8,1024);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8635,17060,to_date('02-FEB-00','DD-MON-RR'),'T',9999,2,56);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1025,42960,to_date('03-FEB-00','DD-MON-RR'),'S',9999,2,24);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2070,76630,to_date('04-FEB-00','DD-MON-RR'),'S',9999,3,324);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9315,7720,to_date('05-FEB-00','DD-MON-RR'),'S',9999,2,138);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18745,63330,to_date('05-FEB-00','DD-MON-RR'),'T',9999,2,318);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1730,117410,to_date('07-FEB-00','DD-MON-RR'),'C',9999,1,48);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (19680,128650,to_date('08-FEB-00','DD-MON-RR'),'S',9999,20,560);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3855,61720,to_date('09-FEB-00','DD-MON-RR'),'S',9999,2,16);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2225,9490,to_date('09-FEB-00','DD-MON-RR'),'T',9999,2,116);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11965,22000,to_date('09-FEB-00','DD-MON-RR'),'S',9999,2,550);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (37600,27430,to_date('10-FEB-00','DD-MON-RR'),'C',9999,24,3552);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4505,3880,to_date('11-FEB-00','DD-MON-RR'),'S',9999,21,1008);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4480,57840,to_date('11-FEB-00','DD-MON-RR'),'P',9999,12,1668);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (185,65190,to_date('12-FEB-00','DD-MON-RR'),'I',144,4,140.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2070,81220,to_date('12-FEB-00','DD-MON-RR'),'T',9999,2,216);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2415,11610,to_date('12-FEB-00','DD-MON-RR'),'T',48,5,310.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3720,6750,to_date('13-FEB-00','DD-MON-RR'),'I',144,4,115.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1080,188670,to_date('14-FEB-00','DD-MON-RR'),'P',9999,11,143);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5160,38290,to_date('15-FEB-00','DD-MON-RR'),'S',9999,10,490);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7325,15480,to_date('15-FEB-00','DD-MON-RR'),'S',9999,4,276);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12935,134470,to_date('15-FEB-00','DD-MON-RR'),'T',300,2,19.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5785,6680,to_date('17-FEB-00','DD-MON-RR'),'I',9999,40,1320);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1810,98380,to_date('17-FEB-00','DD-MON-RR'),'S',9999,26,442);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2255,96400,to_date('17-FEB-00','DD-MON-RR'),'S',9999,4,156);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9515,132610,to_date('18-FEB-00','DD-MON-RR'),'I',420,21,107.1);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (26245,6510,to_date('18-FEB-00','DD-MON-RR'),'P',9999,17,1598);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11940,26450,to_date('18-FEB-00','DD-MON-RR'),'C',276,17,489.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7125,46910,to_date('18-FEB-00','DD-MON-RR'),'C',9999,7,455);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5830,28660,to_date('18-FEB-00','DD-MON-RR'),'I',9999,4,276);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1860,8970,to_date('21-FEB-00','DD-MON-RR'),'T',9999,5,390);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3840,71850,to_date('21-FEB-00','DD-MON-RR'),'S',9999,4,1100);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2265,25760,to_date('21-FEB-00','DD-MON-RR'),'I',9999,21,882);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1330,15340,to_date('22-FEB-00','DD-MON-RR'),'I',360,21,1106.7);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6505,39480,to_date('23-FEB-00','DD-MON-RR'),'P',9999,7,826);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (560,182090,to_date('23-FEB-00','DD-MON-RR'),'T',9999,2,128);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1385,30750,to_date('23-FEB-00','DD-MON-RR'),'S',9999,9,711);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9845,19520,to_date('25-FEB-00','DD-MON-RR'),'S',144,1,29.7);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2095,59960,to_date('26-FEB-00','DD-MON-RR'),'T',9999,14,1176);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5000,20860,to_date('26-FEB-00','DD-MON-RR'),'S',9999,2,16);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (120,69370,to_date('26-FEB-00','DD-MON-RR'),'I',9999,21,2310);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2890,33530,to_date('27-FEB-00','DD-MON-RR'),'I',9999,1,40);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (940,27270,to_date('28-FEB-00','DD-MON-RR'),'C',300,17,2244);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (815,1880,to_date('03-MAR-00','DD-MON-RR'),'T',9999,2,118);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2325,79580,to_date('03-MAR-00','DD-MON-RR'),'S',48,42,718.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3900,22160,to_date('04-MAR-00','DD-MON-RR'),'C',156,12,134.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2170,2060,to_date('04-MAR-00','DD-MON-RR'),'I',360,12,758.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1035,176930,to_date('05-MAR-00','DD-MON-RR'),'P',408,17,583.1);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14530,5410,to_date('07-MAR-00','DD-MON-RR'),'C',372,6,102.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4500,840,to_date('08-MAR-00','DD-MON-RR'),'C',96,6,496.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17410,79410,to_date('08-MAR-00','DD-MON-RR'),'S',9999,1,37);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4945,9860,to_date('09-MAR-00','DD-MON-RR'),'S',348,27,907.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2480,68060,to_date('09-MAR-00','DD-MON-RR'),'I',72,12,140.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13980,140570,to_date('10-MAR-00','DD-MON-RR'),'P',144,18,194.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1220,27580,to_date('11-MAR-00','DD-MON-RR'),'I',9999,5,340);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11380,12480,to_date('11-MAR-00','DD-MON-RR'),'C',9999,31,2170);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3440,13340,to_date('13-MAR-00','DD-MON-RR'),'P',9999,11,1375);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4445,11840,to_date('13-MAR-00','DD-MON-RR'),'T',408,10,266);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3925,41460,to_date('15-MAR-00','DD-MON-RR'),'S',9999,4,144);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1445,145410,to_date('18-MAR-00','DD-MON-RR'),'S',9999,4,500);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (800,2830,to_date('20-MAR-00','DD-MON-RR'),'I',9999,40,2160);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9425,30620,to_date('21-MAR-00','DD-MON-RR'),'I',288,19,1352.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2745,35640,to_date('23-MAR-00','DD-MON-RR'),'T',9999,5,725);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13070,74360,to_date('24-MAR-00','DD-MON-RR'),'C',252,15,1536);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1200,9270,to_date('24-MAR-00','DD-MON-RR'),'I',372,13,717.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1640,5010,to_date('24-MAR-00','DD-MON-RR'),'S',9999,29,1044);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8050,73960,to_date('25-MAR-00','DD-MON-RR'),'T',9999,2,34);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7960,30620,to_date('25-MAR-00','DD-MON-RR'),'I',432,11,138.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16620,51530,to_date('26-MAR-00','DD-MON-RR'),'P',372,8,292.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1195,9670,to_date('26-MAR-00','DD-MON-RR'),'S',9999,3,207);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2120,68100,to_date('26-MAR-00','DD-MON-RR'),'S',9999,17,2312);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (755,71280,to_date('27-MAR-00','DD-MON-RR'),'T',9999,2,24);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10260,19900,to_date('28-MAR-00','DD-MON-RR'),'S',9999,3,33);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2420,1960,to_date('01-APR-00','DD-MON-RR'),'S',9999,1,7);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3425,51430,to_date('02-APR-00','DD-MON-RR'),'C',9999,14,392);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8430,9200,to_date('02-APR-00','DD-MON-RR'),'C',9999,24,2352);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3720,43400,to_date('06-APR-00','DD-MON-RR'),'I',9999,27,864);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (240,42900,to_date('06-APR-00','DD-MON-RR'),'T',9999,10,590);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1355,64750,to_date('06-APR-00','DD-MON-RR'),'S',9999,2,66);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1065,61540,to_date('07-APR-00','DD-MON-RR'),'I',9999,19,3420);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8780,49790,to_date('08-APR-00','DD-MON-RR'),'S',9999,4,440);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8010,1580,to_date('09-APR-00','DD-MON-RR'),'T',9999,10,480);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (805,11830,to_date('09-APR-00','DD-MON-RR'),'I',9999,7,413);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2075,16470,to_date('11-APR-00','DD-MON-RR'),'S',9999,14,1176);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2160,35860,to_date('11-APR-00','DD-MON-RR'),'C',9999,15,1650);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17130,135390,to_date('15-APR-00','DD-MON-RR'),'S',9999,29,1711);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (43565,46730,to_date('16-APR-00','DD-MON-RR'),'S',9999,1,59);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2540,64390,to_date('16-APR-00','DD-MON-RR'),'I',9999,6,312);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2735,71850,to_date('18-APR-00','DD-MON-RR'),'T',9999,2,96);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14455,68030,to_date('18-APR-00','DD-MON-RR'),'P',9999,17,1496);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1700,40050,to_date('20-APR-00','DD-MON-RR'),'P',9999,3,99);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4240,22760,to_date('21-APR-00','DD-MON-RR'),'C',9999,7,280);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (400,42270,to_date('22-APR-00','DD-MON-RR'),'T',9999,5,695);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4335,74720,to_date('23-APR-00','DD-MON-RR'),'S',9999,4,180);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9985,106990,to_date('23-APR-00','DD-MON-RR'),'T',9999,5,575);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1805,111010,to_date('23-APR-00','DD-MON-RR'),'C',9999,4,1580);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3755,45940,to_date('24-APR-00','DD-MON-RR'),'C',9999,7,217);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5,22260,to_date('24-APR-00','DD-MON-RR'),'S',9999,17,2975);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6700,12910,to_date('24-APR-00','DD-MON-RR'),'C',9999,12,36);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2025,7650,to_date('24-APR-00','DD-MON-RR'),'S',9999,19,361);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1690,62910,to_date('26-APR-00','DD-MON-RR'),'S',9999,4,56);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7005,24670,to_date('27-APR-00','DD-MON-RR'),'C',9999,13,767);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11385,13780,to_date('27-APR-00','DD-MON-RR'),'I',9999,21,2625);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2460,20660,to_date('01-MAY-00','DD-MON-RR'),'S',9999,3,183);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (47575,17350,to_date('01-MAY-00','DD-MON-RR'),'I',9999,25,3375);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8860,29330,to_date('01-MAY-00','DD-MON-RR'),'I',9999,8,1400);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18605,145360,to_date('03-MAY-00','DD-MON-RR'),'C',9999,12,936);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4010,8560,to_date('03-MAY-00','DD-MON-RR'),'S',9999,7,224);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3925,4620,to_date('03-MAY-00','DD-MON-RR'),'I',9999,1,36);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4395,31470,to_date('03-MAY-00','DD-MON-RR'),'S',9999,2,98);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2915,62140,to_date('04-MAY-00','DD-MON-RR'),'S',9999,24,1632);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17805,2200,to_date('04-MAY-00','DD-MON-RR'),'I',9999,19,2242);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2620,50250,to_date('05-MAY-00','DD-MON-RR'),'S',9999,46,4094);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12315,26120,to_date('05-MAY-00','DD-MON-RR'),'I',78,24,1382.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2045,94330,to_date('05-MAY-00','DD-MON-RR'),'P',9999,7,455);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (30000,136490,to_date('08-MAY-00','DD-MON-RR'),'P',9999,17,51);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11720,9200,to_date('08-MAY-00','DD-MON-RR'),'T',9999,2,138);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (415,4920,to_date('09-MAY-00','DD-MON-RR'),'P',9999,3,465);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9650,30730,to_date('09-MAY-00','DD-MON-RR'),'C',54,13,807.3);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1275,2770,to_date('11-MAY-00','DD-MON-RR'),'S',9999,25,1950);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6335,18050,to_date('12-MAY-00','DD-MON-RR'),'I',9999,1,69);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (460,35310,to_date('14-MAY-00','DD-MON-RR'),'P',414,17,583.1);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3550,52750,to_date('15-MAY-00','DD-MON-RR'),'S',210,20,1003);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3160,24950,to_date('17-MAY-00','DD-MON-RR'),'S',210,28,1164.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1410,89990,to_date('17-MAY-00','DD-MON-RR'),'I',9999,21,399);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8085,6380,to_date('18-MAY-00','DD-MON-RR'),'P',9999,3,204);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (285,1300,to_date('18-MAY-00','DD-MON-RR'),'P',9999,11,759);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8640,14820,to_date('18-MAY-00','DD-MON-RR'),'P',102,7,617.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1710,139450,to_date('19-MAY-00','DD-MON-RR'),'T',9999,2,66);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1855,85310,to_date('19-MAY-00','DD-MON-RR'),'I',18,14,1449);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3825,47750,to_date('19-MAY-00','DD-MON-RR'),'P',9999,18,1008);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4420,71250,to_date('21-MAY-00','DD-MON-RR'),'I',9999,1,14);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2135,68240,to_date('21-MAY-00','DD-MON-RR'),'I',9999,23,851);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (80,710,to_date('21-MAY-00','DD-MON-RR'),'S',9999,2,68);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5785,16150,to_date('21-MAY-00','DD-MON-RR'),'I',18,4,118.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14960,68030,to_date('22-MAY-00','DD-MON-RR'),'P',9999,10,200);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2640,22240,to_date('24-MAY-00','DD-MON-RR'),'C',9999,16,304);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1975,27470,to_date('25-MAY-00','DD-MON-RR'),'I',9999,41,533);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2555,27990,to_date('26-MAY-00','DD-MON-RR'),'P',9999,14,546);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (545,36410,to_date('26-MAY-00','DD-MON-RR'),'P',234,18,2019.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1100,69500,to_date('28-MAY-00','DD-MON-RR'),'P',54,18,1117.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2645,8550,to_date('28-MAY-00','DD-MON-RR'),'S',9999,2,92);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11130,27430,to_date('29-MAY-00','DD-MON-RR'),'S',9999,2,24);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5200,23330,to_date('04-JUN-00','DD-MON-RR'),'I',9999,7,259);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2100,65860,to_date('05-JUN-00','DD-MON-RR'),'C',9999,7,476);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8035,1170,to_date('05-JUN-00','DD-MON-RR'),'S',9999,10,1350);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1885,76930,to_date('05-JUN-00','DD-MON-RR'),'T',9999,3,132);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3900,24740,to_date('06-JUN-00','DD-MON-RR'),'S',9999,19,266);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2365,37580,to_date('09-JUN-00','DD-MON-RR'),'I',9999,19,1425);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5750,13060,to_date('09-JUN-00','DD-MON-RR'),'I',9999,7,273);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (895,62140,to_date('11-JUN-00','DD-MON-RR'),'S',486,3,18);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (40340,61720,to_date('12-JUN-00','DD-MON-RR'),'C',42,14,529.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2380,2850,to_date('14-JUN-00','DD-MON-RR'),'I',9999,11,1518);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4035,32910,to_date('14-JUN-00','DD-MON-RR'),'S',162,29,7400.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (290,67480,to_date('16-JUN-00','DD-MON-RR'),'S',9999,15,1470);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9950,33540,to_date('17-JUN-00','DD-MON-RR'),'T',186,10,756.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3240,5010,to_date('17-JUN-00','DD-MON-RR'),'C',9999,24,1680);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7035,14680,to_date('19-JUN-00','DD-MON-RR'),'T',9999,7,336);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7890,9860,to_date('20-JUN-00','DD-MON-RR'),'T',42,10,504);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1975,81220,to_date('20-JUN-00','DD-MON-RR'),'S',306,12,124.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4480,200,to_date('21-JUN-00','DD-MON-RR'),'T',9999,2,278);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9645,15590,to_date('21-JUN-00','DD-MON-RR'),'S',9999,3,1275);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (895,68530,to_date('22-JUN-00','DD-MON-RR'),'I',9999,9,72);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (38835,62650,to_date('22-JUN-00','DD-MON-RR'),'P',42,5,175.5);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9315,26120,to_date('22-JUN-00','DD-MON-RR'),'C',9999,5,345);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1360,53790,to_date('23-JUN-00','DD-MON-RR'),'P',9999,14,1512);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1490,18250,to_date('25-JUN-00','DD-MON-RR'),'P',246,17,122.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (930,40020,to_date('25-JUN-00','DD-MON-RR'),'S',9999,28,4620);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (460,18160,to_date('26-JUN-00','DD-MON-RR'),'I',186,4,156.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (865,23180,to_date('26-JUN-00','DD-MON-RR'),'C',282,11,475.2);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2345,22810,to_date('29-JUN-00','DD-MON-RR'),'S',9999,2,38);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (47290,113110,to_date('01-JUL-00','DD-MON-RR'),'S',9999,20,980);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (910,8350,to_date('03-JUL-00','DD-MON-RR'),'C',9999,28,224);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1150,31460,to_date('04-JUL-00','DD-MON-RR'),'I',9999,12,1080);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3975,43350,to_date('05-JUL-00','DD-MON-RR'),'P',9999,8,136);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2015,11320,to_date('06-JUL-00','DD-MON-RR'),'S',9999,4,76);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6265,4470,to_date('07-JUL-00','DD-MON-RR'),'C',9999,17,1224);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18925,65930,to_date('08-JUL-00','DD-MON-RR'),'T',9999,2,128);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12265,92290,to_date('09-JUL-00','DD-MON-RR'),'S',9999,28,1176);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18255,146380,to_date('09-JUL-00','DD-MON-RR'),'T',9999,2,38);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (85,29790,to_date('10-JUL-00','DD-MON-RR'),'P',9999,11,1298);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (505,4180,to_date('11-JUL-00','DD-MON-RR'),'S',9999,13,1404);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (765,66860,to_date('12-JUL-00','DD-MON-RR'),'I',9999,19,931);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10710,29450,to_date('12-JUL-00','DD-MON-RR'),'S',9999,19,475);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1885,9370,to_date('13-JUL-00','DD-MON-RR'),'C',9999,22,968);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5290,48350,to_date('13-JUL-00','DD-MON-RR'),'C',9999,13,728);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (33670,49840,to_date('17-JUL-00','DD-MON-RR'),'C',9999,5,790);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (650,40720,to_date('19-JUL-00','DD-MON-RR'),'S',9999,2,220);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7945,110610,to_date('20-JUL-00','DD-MON-RR'),'I',9999,12,948);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1930,37240,to_date('25-JUL-00','DD-MON-RR'),'I',9999,18,1962);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1430,30100,to_date('25-JUL-00','DD-MON-RR'),'C',9999,7,875);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4950,4620,to_date('25-JUL-00','DD-MON-RR'),'S',9999,9,171);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1750,121820,to_date('25-JUL-00','DD-MON-RR'),'S',9999,19,1862);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1745,108160,to_date('26-JUL-00','DD-MON-RR'),'S',9999,2,196);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11675,16210,to_date('26-JUL-00','DD-MON-RR'),'S',9999,3,207);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14830,116940,to_date('27-JUL-00','DD-MON-RR'),'S',9999,19,1482);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1565,6120,to_date('27-JUL-00','DD-MON-RR'),'S',9999,33,2145);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8190,30730,to_date('28-JUL-00','DD-MON-RR'),'C',9999,7,98);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6470,22330,to_date('30-JUL-00','DD-MON-RR'),'S',9999,14,966);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2890,11830,to_date('02-AUG-00','DD-MON-RR'),'T',9999,2,80);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16200,94480,to_date('03-AUG-00','DD-MON-RR'),'P',9999,11,429);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1450,61720,to_date('03-AUG-00','DD-MON-RR'),'I',9999,17,646);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3515,22800,to_date('04-AUG-00','DD-MON-RR'),'I',9999,11,99);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (880,6270,to_date('05-AUG-00','DD-MON-RR'),'I',9999,14,588);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (255,108160,to_date('07-AUG-00','DD-MON-RR'),'I',9999,26,936);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3615,74400,to_date('12-AUG-00','DD-MON-RR'),'I',123,21,264.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17920,135970,to_date('13-AUG-00','DD-MON-RR'),'S',9999,3,42);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1705,28920,to_date('14-AUG-00','DD-MON-RR'),'S',9999,3,99);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9120,30650,to_date('15-AUG-00','DD-MON-RR'),'I',411,11,392.7);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7845,1170,to_date('15-AUG-00','DD-MON-RR'),'P',9999,18,468);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7070,8370,to_date('15-AUG-00','DD-MON-RR'),'S',9999,28,1092);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8275,79440,to_date('17-AUG-00','DD-MON-RR'),'I',411,21,2060.1);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17975,3040,to_date('18-AUG-00','DD-MON-RR'),'S',387,6,158.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13540,128650,to_date('19-AUG-00','DD-MON-RR'),'S',339,6,268.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (38450,22300,to_date('20-AUG-00','DD-MON-RR'),'P',9999,11,638);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1170,12900,to_date('23-AUG-00','DD-MON-RR'),'S',231,9,810.9);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5935,30620,to_date('25-AUG-00','DD-MON-RR'),'S',111,19,273.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (860,22300,to_date('25-AUG-00','DD-MON-RR'),'S',111,4,158.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18540,31770,to_date('26-AUG-00','DD-MON-RR'),'I',9999,23,391);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3950,12070,to_date('28-AUG-00','DD-MON-RR'),'P',9999,10,480);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1135,22540,to_date('28-AUG-00','DD-MON-RR'),'C',159,5,148);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4400,20670,to_date('30-AUG-00','DD-MON-RR'),'S',9999,9,738);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4800,14300,to_date('30-AUG-00','DD-MON-RR'),'I',9999,4,1460);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (490,97980,to_date('01-SEP-00','DD-MON-RR'),'I',75,24,518.4);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3050,32160,to_date('04-SEP-00','DD-MON-RR'),'T',9999,7,98);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (8990,10760,to_date('04-SEP-00','DD-MON-RR'),'S',219,19,896.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1160,157820,to_date('06-SEP-00','DD-MON-RR'),'S',9999,4,380);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2860,24440,to_date('07-SEP-00','DD-MON-RR'),'S',9999,2,96);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1160,182090,to_date('08-SEP-00','DD-MON-RR'),'T',9999,2,190);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (900,19400,to_date('09-SEP-00','DD-MON-RR'),'I',9999,21,168);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15280,123250,to_date('09-SEP-00','DD-MON-RR'),'P',9999,8,632);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1445,145410,to_date('10-SEP-00','DD-MON-RR'),'C',9999,12,1500);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1195,158960,to_date('11-SEP-00','DD-MON-RR'),'S',51,47,2918.7);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (180,98530,to_date('11-SEP-00','DD-MON-RR'),'S',9999,8,368);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1430,9440,to_date('12-SEP-00','DD-MON-RR'),'S',9999,14,1750);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (910,76220,to_date('14-SEP-00','DD-MON-RR'),'I',9999,21,168);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1990,18150,to_date('16-SEP-00','DD-MON-RR'),'S',399,29,1484.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4865,33940,to_date('18-SEP-00','DD-MON-RR'),'S',183,19,820.8);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (24130,115660,to_date('19-SEP-00','DD-MON-RR'),'S',9999,4,104);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1015,45410,to_date('21-SEP-00','DD-MON-RR'),'P',483,7,56);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3720,28830,to_date('22-SEP-00','DD-MON-RR'),'P',87,7,201.6);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15765,127460,to_date('23-SEP-00','DD-MON-RR'),'S',9999,2,178);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2275,157740,to_date('23-SEP-00','DD-MON-RR'),'S',9999,24,1536);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9140,29790,to_date('24-SEP-00','DD-MON-RR'),'I',9999,19,1102);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (7825,36640,to_date('24-SEP-00','DD-MON-RR'),'S',87,34,1377);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (270,46730,to_date('25-SEP-00','DD-MON-RR'),'T',363,5,352);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6775,38720,to_date('25-SEP-00','DD-MON-RR'),'C',9999,22,1408);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2275,16920,to_date('26-SEP-00','DD-MON-RR'),'I',9999,19,1216);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10885,8100,to_date('28-SEP-00','DD-MON-RR'),'S',87,6,783);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (285,18250,to_date('29-SEP-00','DD-MON-RR'),'I',9999,1,69);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9950,26590,to_date('29-SEP-00','DD-MON-RR'),'S',9999,34,3026);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (24330,4240,to_date('02-OCT-00','DD-MON-RR'),'S',9999,10,680);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3675,43870,to_date('04-OCT-00','DD-MON-RR'),'I',9999,11,2728);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (34135,36010,to_date('05-OCT-00','DD-MON-RR'),'S',9999,39,468);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6070,45700,to_date('06-OCT-00','DD-MON-RR'),'I',9999,6,354);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5855,3310,to_date('07-OCT-00','DD-MON-RR'),'P',9999,24,408);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16505,8100,to_date('08-OCT-00','DD-MON-RR'),'I',9999,21,1008);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1030,25290,to_date('11-OCT-00','DD-MON-RR'),'C',9999,14,168);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (20480,13680,to_date('11-OCT-00','DD-MON-RR'),'S',9999,10,90);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3790,50120,to_date('12-OCT-00','DD-MON-RR'),'I',9999,4,144);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2475,65830,to_date('13-OCT-00','DD-MON-RR'),'S',9999,43,559);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (19795,3040,to_date('14-OCT-00','DD-MON-RR'),'I',9999,17,1564);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (47180,24380,to_date('14-OCT-00','DD-MON-RR'),'I',9999,1,13);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4025,2080,to_date('15-OCT-00','DD-MON-RR'),'S',9999,4,40);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18485,118290,to_date('15-OCT-00','DD-MON-RR'),'S',9999,4,156);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2915,56000,to_date('16-OCT-00','DD-MON-RR'),'C',9999,46,3128);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4400,47740,to_date('16-OCT-00','DD-MON-RR'),'S',9999,8,656);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (3690,8630,to_date('17-OCT-00','DD-MON-RR'),'S',9999,33,1056);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2395,100,to_date('18-OCT-00','DD-MON-RR'),'T',9999,5,270);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15515,16140,to_date('19-OCT-00','DD-MON-RR'),'T',9999,5,60);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2230,130130,to_date('20-OCT-00','DD-MON-RR'),'P',9999,3,126);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (39070,550,to_date('22-OCT-00','DD-MON-RR'),'S',9999,27,4293);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1105,40920,to_date('23-OCT-00','DD-MON-RR'),'C',9999,14,966);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1860,30620,to_date('24-OCT-00','DD-MON-RR'),'T',9999,5,390);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (24520,4090,to_date('25-OCT-00','DD-MON-RR'),'S',9999,19,133);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (38680,29890,to_date('25-OCT-00','DD-MON-RR'),'S',9999,2,76);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1235,62650,to_date('26-OCT-00','DD-MON-RR'),'S',9999,1,54);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (325,32850,to_date('27-OCT-00','DD-MON-RR'),'I',9999,12,192);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (13425,17920,to_date('27-OCT-00','DD-MON-RR'),'S',9999,2,136);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (16815,53230,to_date('28-OCT-00','DD-MON-RR'),'T',9999,2,124);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (12705,98630,to_date('29-OCT-00','DD-MON-RR'),'C',9999,22,616);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1855,20190,to_date('30-OCT-00','DD-MON-RR'),'T',9999,2,230);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (5000,10030,to_date('30-OCT-00','DD-MON-RR'),'P',9999,3,24);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11695,12070,to_date('02-NOV-00','DD-MON-RR'),'S',9999,2,18);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17900,57840,to_date('04-NOV-00','DD-MON-RR'),'I',9999,11,143);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6335,45310,to_date('04-NOV-00','DD-MON-RR'),'C',9999,17,1173);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (21650,50080,to_date('04-NOV-00','DD-MON-RR'),'I',9999,13,494);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (985,141470,to_date('06-NOV-00','DD-MON-RR'),'I',9999,12,768);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (11925,8020,to_date('06-NOV-00','DD-MON-RR'),'S',9999,26,676);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2600,26020,to_date('07-NOV-00','DD-MON-RR'),'C',9999,7,616);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (14045,149100,to_date('08-NOV-00','DD-MON-RR'),'S',9999,14,826);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (40525,144000,to_date('08-NOV-00','DD-MON-RR'),'S',9999,34,680);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (43630,35310,to_date('09-NOV-00','DD-MON-RR'),'I',9999,18,216);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6700,111010,to_date('09-NOV-00','DD-MON-RR'),'I',9999,25,75);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (35475,33570,to_date('09-NOV-00','DD-MON-RR'),'S',9999,6,54);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4630,142640,to_date('09-NOV-00','DD-MON-RR'),'C',9999,12,744);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10745,9500,to_date('09-NOV-00','DD-MON-RR'),'I',9999,19,1691);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10600,4640,to_date('10-NOV-00','DD-MON-RR'),'S',9999,2,78);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (32620,24100,to_date('10-NOV-00','DD-MON-RR'),'C',9999,22,1496);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9310,30590,to_date('10-NOV-00','DD-MON-RR'),'S',9999,16,1104);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (32280,19480,to_date('11-NOV-00','DD-MON-RR'),'S',9999,19,190);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (15015,104100,to_date('13-NOV-00','DD-MON-RR'),'S',9999,8,208);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (740,22200,to_date('13-NOV-00','DD-MON-RR'),'S',9999,4,156);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6505,5620,to_date('13-NOV-00','DD-MON-RR'),'S',9999,9,1062);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1330,63770,to_date('15-NOV-00','DD-MON-RR'),'C',9999,24,1488);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (27150,47160,to_date('15-NOV-00','DD-MON-RR'),'P',9999,18,360);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1490,188700,to_date('16-NOV-00','DD-MON-RR'),'S',9999,4,36);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18250,98630,to_date('17-NOV-00','DD-MON-RR'),'C',9999,10,1480);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (40425,188200,to_date('18-NOV-00','DD-MON-RR'),'S',9999,23,184);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4435,11610,to_date('18-NOV-00','DD-MON-RR'),'S',9999,47,1363);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (6435,24250,to_date('18-NOV-00','DD-MON-RR'),'S',9999,33,858);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (115,16990,to_date('20-NOV-00','DD-MON-RR'),'S',9999,33,2112);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (18845,12160,to_date('20-NOV-00','DD-MON-RR'),'I',9999,11,275);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (4255,14050,to_date('20-NOV-00','DD-MON-RR'),'P',9999,8,368);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (34355,8620,to_date('22-NOV-00','DD-MON-RR'),'P',9999,17,816);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (10515,68300,to_date('22-NOV-00','DD-MON-RR'),'S',9999,9,486);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (17935,21600,to_date('24-NOV-00','DD-MON-RR'),'T',9999,10,140);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2190,13770,to_date('25-NOV-00','DD-MON-RR'),'S',9999,23,161);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (2225,15720,to_date('28-NOV-00','DD-MON-RR'),'S',9999,25,1450);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (34005,120760,to_date('29-NOV-00','DD-MON-RR'),'P',9999,44,2376);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (9425,4750,to_date('29-NOV-00','DD-MON-RR'),'I',9999,11,979);
Insert into SALES (PROD_ID,CUST_ID,TIME_ID,CHANNEL_ID,PROMO_ID,QUANTITY_SOLD,AMOUNT_SOLD) values (1675,46750,to_date('29-NOV-00','DD-MON-RR'),'S',9999,19,1121);
--------------------------------------------------------
--  DDL for Index SALES_PROD_BIX
--------------------------------------------------------

  CREATE BITMAP INDEX "SALES_PROD_BIX" ON "SALES" ("PROD_ID") 
   LOCAL
 (PARTITION "SALES_1995" , 
 PARTITION "SALES_1996" , 
 PARTITION "SALES_H1_1997" , 
 PARTITION "SALES_H2_1997" , 
 PARTITION "SALES_Q1_1998" , 
 PARTITION "SALES_Q2_1998" , 
 PARTITION "SALES_Q3_1998" , 
 PARTITION "SALES_Q4_1998" , 
 PARTITION "SALES_Q1_1999" , 
 PARTITION "SALES_Q2_1999" , 
 PARTITION "SALES_Q3_1999" , 
 PARTITION "SALES_Q4_1999" , 
 PARTITION "SALES_Q1_2000" , 
 PARTITION "SALES_Q2_2000" , 
 PARTITION "SALES_Q3_2000" , 
 PARTITION "SALES_Q4_2000" ) ;
--------------------------------------------------------
--  DDL for Index SALES_CUST_BIX
--------------------------------------------------------

  CREATE BITMAP INDEX "SALES_CUST_BIX" ON "SALES" ("CUST_ID") 
   LOCAL
 (PARTITION "SALES_1995" , 
 PARTITION "SALES_1996" , 
 PARTITION "SALES_H1_1997" , 
 PARTITION "SALES_H2_1997" , 
 PARTITION "SALES_Q1_1998" , 
 PARTITION "SALES_Q2_1998" , 
 PARTITION "SALES_Q3_1998" , 
 PARTITION "SALES_Q4_1998" , 
 PARTITION "SALES_Q1_1999" , 
 PARTITION "SALES_Q2_1999" , 
 PARTITION "SALES_Q3_1999" , 
 PARTITION "SALES_Q4_1999" , 
 PARTITION "SALES_Q1_2000" , 
 PARTITION "SALES_Q2_2000" , 
 PARTITION "SALES_Q3_2000" , 
 PARTITION "SALES_Q4_2000" ) ;
--------------------------------------------------------
--  DDL for Index SALES_TIME_BIX
--------------------------------------------------------

  CREATE BITMAP INDEX "SALES_TIME_BIX" ON "SALES" ("TIME_ID") 
   LOCAL
 (PARTITION "SALES_1995" , 
 PARTITION "SALES_1996" , 
 PARTITION "SALES_H1_1997" , 
 PARTITION "SALES_H2_1997" , 
 PARTITION "SALES_Q1_1998" , 
 PARTITION "SALES_Q2_1998" , 
 PARTITION "SALES_Q3_1998" , 
 PARTITION "SALES_Q4_1998" , 
 PARTITION "SALES_Q1_1999" , 
 PARTITION "SALES_Q2_1999" , 
 PARTITION "SALES_Q3_1999" , 
 PARTITION "SALES_Q4_1999" , 
 PARTITION "SALES_Q1_2000" , 
 PARTITION "SALES_Q2_2000" , 
 PARTITION "SALES_Q3_2000" , 
 PARTITION "SALES_Q4_2000" ) ;
--------------------------------------------------------
--  DDL for Index SALES_CHANNEL_BIX
--------------------------------------------------------

  CREATE BITMAP INDEX "SALES_CHANNEL_BIX" ON "SALES" ("CHANNEL_ID") 
   LOCAL
 (PARTITION "SALES_1995" , 
 PARTITION "SALES_1996" , 
 PARTITION "SALES_H1_1997" , 
 PARTITION "SALES_H2_1997" , 
 PARTITION "SALES_Q1_1998" , 
 PARTITION "SALES_Q2_1998" , 
 PARTITION "SALES_Q3_1998" , 
 PARTITION "SALES_Q4_1998" , 
 PARTITION "SALES_Q1_1999" , 
 PARTITION "SALES_Q2_1999" , 
 PARTITION "SALES_Q3_1999" , 
 PARTITION "SALES_Q4_1999" , 
 PARTITION "SALES_Q1_2000" , 
 PARTITION "SALES_Q2_2000" , 
 PARTITION "SALES_Q3_2000" , 
 PARTITION "SALES_Q4_2000" ) ;
--------------------------------------------------------
--  DDL for Index SALES_PROMO_BIX
--------------------------------------------------------

  CREATE BITMAP INDEX "SALES_PROMO_BIX" ON "SALES" ("PROMO_ID") 
   LOCAL
 (PARTITION "SALES_1995" , 
 PARTITION "SALES_1996" , 
 PARTITION "SALES_H1_1997" , 
 PARTITION "SALES_H2_1997" , 
 PARTITION "SALES_Q1_1998" , 
 PARTITION "SALES_Q2_1998" , 
 PARTITION "SALES_Q3_1998" , 
 PARTITION "SALES_Q4_1998" , 
 PARTITION "SALES_Q1_1999" , 
 PARTITION "SALES_Q2_1999" , 
 PARTITION "SALES_Q3_1999" , 
 PARTITION "SALES_Q4_1999" , 
 PARTITION "SALES_Q1_2000" , 
 PARTITION "SALES_Q2_2000" , 
 PARTITION "SALES_Q3_2000" , 
 PARTITION "SALES_Q4_2000" ) ;
--------------------------------------------------------
--  Constraints for Table SALES
--------------------------------------------------------

  ALTER TABLE "SALES" MODIFY ("PROD_ID" CONSTRAINT "SALES_PRODUCT_NN" NOT NULL ENABLE);
  ALTER TABLE "SALES" MODIFY ("CUST_ID" CONSTRAINT "SALES_CUSTOMER_NN" NOT NULL ENABLE);
  ALTER TABLE "SALES" MODIFY ("TIME_ID" CONSTRAINT "SALES_TIME_NN" NOT NULL ENABLE);
  ALTER TABLE "SALES" MODIFY ("CHANNEL_ID" CONSTRAINT "SALES_CHANNEL_NN" NOT NULL ENABLE);
  ALTER TABLE "SALES" MODIFY ("PROMO_ID" CONSTRAINT "SALES_PROMO_NN" NOT NULL ENABLE);
  ALTER TABLE "SALES" MODIFY ("QUANTITY_SOLD" CONSTRAINT "SALES_QUANTITY_NN" NOT NULL ENABLE);
  ALTER TABLE "SALES" MODIFY ("AMOUNT_SOLD" CONSTRAINT "SALES_AMOUNT_NN" NOT NULL ENABLE);
--------------------------------------------------------
--  Ref Constraints for Table SALES
--------------------------------------------------------

  ALTER TABLE "SALES" ADD CONSTRAINT "SALES_PRODUCT_FK" FOREIGN KEY ("PROD_ID")
	  REFERENCES "PRODUCTS" ("PROD_ID") RELY ENABLE NOVALIDATE;
  ALTER TABLE "SALES" ADD CONSTRAINT "SALES_CUSTOMER_FK" FOREIGN KEY ("CUST_ID")
	  REFERENCES "CUSTOMERS" ("CUST_ID") RELY ENABLE NOVALIDATE;
  ALTER TABLE "SALES" ADD CONSTRAINT "SALES_TIME_FK" FOREIGN KEY ("TIME_ID")
	  REFERENCES "TIMES" ("TIME_ID") RELY ENABLE NOVALIDATE;
  ALTER TABLE "SALES" ADD CONSTRAINT "SALES_CHANNEL_FK" FOREIGN KEY ("CHANNEL_ID")
	  REFERENCES "CHANNELS" ("CHANNEL_ID") RELY ENABLE NOVALIDATE;
  ALTER TABLE "SALES" ADD CONSTRAINT "SALES_PROMO_FK" FOREIGN KEY ("PROMO_ID")
	  REFERENCES "PROMOTIONS" ("PROMO_ID") RELY ENABLE NOVALIDATE;
