update stats on wbdemo ;
open wbdemo ;

insert into paytype ( paytype_id, name, image_large, image_small ) values (
    1001, "VISA Gold", "/vpe/cddemo/images/CCvisa.gif", "/vpe/cddemo/images/CCvisa.gif"
) ;
insert into paytype ( paytype_id, name, image_large, image_small ) values (
    1002, "MasterCard", "/vpe/cddemo/images/CCmstcrd.gif", "/vpe/cddemo/images/CCmstcrd.gif"
) ;
insert into paytype ( paytype_id, name, image_large, image_small ) values (
    1003, "Discover", "/vpe/cddemo/images/CCdscovr.gif", "/vpe/cddemo/images/CCdscovr.gif"
) ;
insert into paytype ( paytype_id, name, image_large, image_small ) values (
    1004, "American Express", "/vpe/cddemo/images/CCamex.gif", "/vpe/cddemo/images/CCamex.gif"
) ;

insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	101,1001,1001,"David R. Hill","4011000200030004",7,96,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	103,1002,1003,"Douglas A. Buschman","6011000100020003",7,96,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	104,1003,1001,"Christopher Dozier","4024000100020008",9,96,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	105,1003,1002,"Christopher Dozier","9999000100020008",10,96,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	106,1003,1004,"Christopher Dozier","8888000100020003",11,95,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	107,1001,1002,"David R. Hill","8888111122223333",3,96,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	109,1001,1004,"David R. Hill","4444555566667777",2,96,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	110,1004,1001,"Douglas","Buschman",5,96,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	111,1005,1001,"Valerie E. B. Williams","111222333444",12,95,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	112,1006,1004,"Tarisa E Holbrook","123456780000",10,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	113,1005,1003,"Valerie E. B. Williams","111222333444",12,96,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	114,1005,1003,"Valerie E. B. Williams","111222333444",12,96,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	115,1007,1004,"test","1234",9,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	116,1008,1001,"Gwen W. Hammaker","123abc",4,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	117,1008,1002,"Gwen W. Hammaker","123abc",1,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	118,1008,1003,"Gwen W. Hammaker","123abc",1,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	119,1008,1004,"Gwen W. Hammaker","123abc",1,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	120,1009,1002,"Gwen Hammaker","1234567890",7,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	121,1010,1001,"tim baer","123-456-789",1,95,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	122,1011,1001,"Joy Wycliff","75675-87666",5,97,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	123,1012,1001,"Fred Flintstone","1122334455",1,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	124,1012,1002,"Fred Flintstone","2233445566",1,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	125,1012,1003,"Fred Flintstone","3344556677",1,98,"V" );
insert into custcard ( custcard_id, cust_id, paytype_id, nameoncard,
    cardacct, cardexmo, cardexyr, statflag) values (
	126,1012,1004,"Fred Flintstone","4455667788",1,98,"V" );

insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10005,"66672",22.0,"Hot Rocks: The Rolling Stones 1964-1971"," ",
	    "/vpe/cddemo/images/stones.gif","/vpe/cddemo/images/stoness.gif",
	    "1986 CD - 21 tracks, 2 disks" );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10002,"CK37951",13.5,"Always on My Mind: Willie Nelson"," ",
	    "/vpe/cddemo/images/wnelson.gif","/vpe/cddemo/images/wnelsons.gif",
	    "1982 recording - 10 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10004,"MCAD-10387",12.75,"Steely Dan - gold (Expanded Edition)"," ",
	    "/vpe/cddemo/images/st_dan.gif","/vpe/cddemo/images/st_dans.gif",
	    "1991 CD - 12 tracks" );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10001,"410525-2",14.0,"Water Music - G. F. Handel"," ",
	    "/vpe/cddemo/images/handel.gif","/vpe/cddemo/images/handels.gif",
	    "1983 Recording by Trevor Pinnock - 19 tracks.  Water Music - tracks 1 through 9.  Suite in D/G Major - tracks 10 through 19." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10003,"3110-2",10.5,"History: America's Greatest Hits"," ",
	    "/vpe/cddemo/images/america.gif","/vpe/cddemo/images/americas.gif",
	    "1975 Recording - 12 tracks" );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10006,"724383179626",24.0,"Live at the BBC: The Beatles"," ",
	    "/vpe/cddemo/images/beatles.gif","/vpe/cddemo/images/beatless.gif",
	    "1994 CD - 69 tracks, 2 disks" );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10007,"CK64327",13.5,"Stones in the Road: M. C. Carpenter"," ",
	    "/vpe/cddemo/images/mc_carp.gif","/vpe/cddemo/images/mc_carps.gif",
	    "1994 CD - 13 tracks" );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10008,"782157-2",12.0,"Serious Hits - Live!:  Phil Collins"," ",
	    "/vpe/cddemo/images/collins.gif","/vpe/cddemo/images/collinss.gif",
	    "1990 CD - 15 tracks" );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10009,"CK40585",13.0,"Time Out: The Dave Brubeck Quartet"," ",
	    "/vpe/cddemo/images/brubeck.gif","/vpe/cddemo/images/brubecks.gif","CD - 7 tracks of previously recorded material" );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10010,"EPC4604972",11.75,"Stronger than Pride: Sade"," ",
	    "/vpe/cddemo/images/sade.gif","/vpe/cddemo/images/sades.gif",
	    "1988 CD - 10 tracks" );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10011,"MYK37760",12.0,"Mendelssohn: Symphony No. 4 in A Major"," ",
	    "/vpe/cddemo/images/mendel.gif","/vpe/cddemo/images/mendels.gif",
	    "1985 Recording by George Szell and the Cleveland Orchestra.  Also includes Incidental Music to 'A Midsummer Night's Dream'." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10012,"31005",13.5,"Chopin - Piano Favorites"," ",
	    "/vpe/cddemo/images/chopin.gif","/vpe/cddemo/images/chopins.gif",
	    "Live recordings from the 11th International Chopin Competition, Warsaw 1985.  14 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10013,"CMPGR2",10.95,"The Masterpiece Collection: Edvard Grieg"," ",
	    "/vpe/cddemo/images/grieg.gif","/vpe/cddemo/images/griegs.gif",
	    "Includes Peer Gynt Suite and Piano Concerto in A Minor. 14 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10014,"E2-106",11.25,"Linda Ronstadt - Greatest Hits"," ",
	    "/vpe/cddemo/images/ronstad.gif","/vpe/cddemo/images/ronstads.gif",
	    "Collection from 1970's.  12 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10015,"W225792",11.0,"Something Inside so Strong: Kenny Rogers"," ",
	    "/vpe/cddemo/images/rogers.gif","/vpe/cddemo/images/rogerss.gif",
	    "1989 Recording.  10 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10016,"CK35625",12.5,"You Don't Bring Me Flowers: Neil Diamond"," ",
	    "/vpe/cddemo/images/diamond.gif","/vpe/cddemo/images/diamonds.gif",
	    "1978 Recording.  10 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10017,"CDP724383033423",12.0,"Bob Seger - Greatest Hits"," ",
	    "/vpe/cddemo/images/seger.gif","/vpe/cddemo/images/segers.gif",
	    "1994 Recording.  14 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10018,"CDQ2019",13.0,"Piano Rags: S. Joplin & G. Gershwin"," ",
	    "/vpe/cddemo/images/joplin.gif","/vpe/cddemo/images/joplins.gif",
	    "1990 Recording.  13 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10019,"I224050",12.5,"No Need to Argue: The Cranberries"," ",
	    "/vpe/cddemo/images/cranbrr.gif","/vpe/cddemo/images/cranbrrs.gif",
	    "1994 recording.  13 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10020,"314514875-2",12.0,"Elemental: Tears for Fears"," ",
	    "/vpe/cddemo/images/tears.gif","/vpe/cddemo/images/tearss.gif",
	    "1993 recording.  10 tracks." );
insert into product ( product_id, prodnum, price, name, html,
    image_large, image_small, descr) values (
	10021,"961569-2",11.0,"10,000 Maniacs: MTV unplugged"," ",
	    "/vpe/cddemo/images/maniacs.gif","/vpe/cddemo/images/maniacss.gif",
	    "1993 recording.  14 tracks." );

insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1001,1001,"1995-10-05","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1002,1002,"1995-10-05","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1003,1003,"1995-10-05","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1004,1001,"1995-10-06","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1006,1001,"1995-10-10","Y",101 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1010,1001,"1995-10-10","Y",107 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1011,1001,"1995-10-10","Y",101 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1012,1001,"1995-10-10","Y",101 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1015,1004,"1995-10-12","Y",110 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1016,1004,"1995-10-12","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1014,1001,"1995-10-12","Y",107 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1017,1001,"1995-10-12","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1018,1001,"1995-10-17","Y",107 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1019,1001,"1995-10-17","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1020,1001,"1995-10-19","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1021,1001,"1995-11-16","Y",107 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1022,1001,"1995-11-16","Y",107 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1023,1001,"1995-11-17","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1024,1001,"1995-11-20","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1025,1005,"1995-11-20","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1026,1005,"1995-11-20","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1027,1005,"1995-11-21","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1028,1005,"1995-11-22","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1029,1005,"1995-11-27","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1030,1005,"1995-11-27","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1031,1005,"1995-11-28","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1032,1005,"1995-11-28","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1033,1005,"1995-11-28","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1034,1005,"1995-11-28","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1035,1005,"1995-11-28","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1036,1005,"1995-11-28","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1037,1005,"1995-11-30","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1038,1006,"1995-11-30","Y",112 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1039,1002,"1995-12-01","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1040,1002,"1995-12-01","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1041,1002,"1995-12-03","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1042,1002,"1995-12-03","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1043,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1044,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1045,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1046,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1047,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1048,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1049,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1050,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1051,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1052,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1053,1002,"1995-12-04","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1054,1002,"1995-12-05","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1055,1002,"1995-12-05","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1056,1002,"1995-12-05","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1057,1002,"1995-12-05","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1058,1002,"1995-12-06","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1059,1005,"1995-12-22","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1060,1005,"1995-12-27","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1061,1003,"1996-01-11","Y",104 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1062,1003,"1996-01-16","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1063,1002,"1996-01-19","Y",103 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1064,1005,"1996-01-31","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1065,1005,"1996-01-31","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1066,1005,"1996-01-31","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1067,1005,"1996-01-31","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1068,1005,"1996-02-10","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1069,1005,"1996-02-12","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1070,1005,"1996-02-13","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1071,1005,"1996-02-14","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1072,1007,"1996-02-22","Y",115 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1073,1005,"1996-02-22","Y",114 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1074,1007,"1996-02-23","Y",115 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1075,1005,"1996-02-23","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1076,1005,"1996-02-26","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1077,1005,"1996-03-26","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1078,1008,"1996-04-01","Y",116 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1079,1008,"1996-04-01","Y",116 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1080,1008,"1996-04-01","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1081,1008,"1996-04-02","Y",119 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1082,1008,"1996-04-02","Y",117 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1083,1008,"1996-04-11","Y",118 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1084,1009,"1996-04-15","Y",120 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1085,1009,"1996-04-15","Y",120 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1086,1008,"1996-04-15","Y",116 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1087,1008,"1996-04-17","Y",116 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1088,1010,"1996-04-18","Y",121 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1089,1005,"1996-04-19","Y",113 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1090,1011,"1996-04-22","Y",122 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1091,1011,"1996-04-22","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1092,1005,"1996-04-22","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1093,1005,"1996-04-29","Y",111 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1094,1005,"1996-04-30","Y",113 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1095,1012,"1996-05-06","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1096,1012,"1996-05-08","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1097,1012,"1996-05-08","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1098,1005,"1996-05-08","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1099,1012,"1996-05-08","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1100,1012,"1996-05-08","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1101,1012,"1996-05-08","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1102,1012,"1996-05-08","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1103,1012,"1996-05-14","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1104,1012,"1996-05-14","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1105,1012,"1996-05-14","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1106,1012,"1996-05-14","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1107,1012,"1996-05-14","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1108,1012,"1996-05-15","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1109,1005,"1996-05-15","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1110,1012,"1996-05-15","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1111,1012,"1996-05-15","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1112,1012,"1996-05-16","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1113,1012,"1996-05-16","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1114,1012,"1996-05-17","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1115,1012,"1996-05-17","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1116,1012,"1996-05-17","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1117,1012,"1996-05-17","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1118,1012,"1996-05-21","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1119,1012,"1996-05-22","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1120,1012,"1996-05-22","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1121,1012,"1996-05-23","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1122,1012,"1996-05-23","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1123,1012,"1996-05-24","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1124,1012,"1996-05-26","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1125,1012,"1996-05-27","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1126,1012,"1996-05-28","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1127,1012,"1996-05-30","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1128,1012,"1996-05-30","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1129,1012,"1996-05-31","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1130,1012,"1996-06-04","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1131,1012,"1996-06-04","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1132,1012,"1996-06-05","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1133,1012,"1996-06-05","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1134,1012,"1996-06-05","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1135,1012,"1996-06-06","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1136,1012,"1996-06-07","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1137,1012,"1996-06-08","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1138,1012,"1996-06-09","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1139,1012,"1996-06-10","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1140,1012,"1996-06-11","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1141,1012,"1996-06-11","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1142,1012,"1996-06-12","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1143,1012,"1996-06-13","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1144,1012,"1996-06-16","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1145,1012,"1996-06-17","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1146,1012,"1996-06-17","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1147,1012,"1996-06-18","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1148,1012,"1996-06-18","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1149,1012,"1996-06-18","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1150,1012,"1996-06-19","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1151,1012,"1996-06-19","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1152,1012,"1996-06-19","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1153,1012,"1996-06-24","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1154,1012,"1996-06-25","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1155,1012,"1996-06-26","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1156,1012,"1996-06-26","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1157,1012,"1996-06-27","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1158,1012,"1996-06-27","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1159,1012,"1996-06-28","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1160,1012,"1996-07-01","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1161,1012,"1996-07-01","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1162,1012,"1996-07-01","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1163,1012,"1996-07-02","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1164,1012,"1996-07-02","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1165,1012,"1996-07-02","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1166,1012,"1996-07-02","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1167,1012,"1996-07-03","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1168,1012,"1996-07-04","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1169,1012,"1996-07-05","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1170,1012,"1996-07-08","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1171,1012,"1996-07-08","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1172,1012,"1996-07-08","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1173,1012,"1996-07-08","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1174,1012,"1996-07-09","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1175,1012,"1996-07-10","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1176,1012,"1996-07-12","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1177,1012,"1996-07-13","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1178,1012,"1996-07-15","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1179,1012,"1996-07-16","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1180,1012,"1996-07-17","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1181,1012,"1996-07-18","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1182,1012,"1996-07-21","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1183,1012,"1996-07-25","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1184,1012,"1996-07-27","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1185,1012,"1996-08-07","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1186,1012,"1996-08-09","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1187,1012,"1996-08-09","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1188,1012,"1996-08-09","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1189,1012,"1996-08-12","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1190,1012,"1996-08-13","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1191,1012,"1996-08-14","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1192,1012,"1996-08-15","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1193,1012,"1996-08-16","Y",126 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1194,1012,"1996-08-19","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1195,1012,"1996-08-21","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1196,1012,"1996-08-22","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1197,1012,"1996-08-23","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1198,1012,"1996-08-23","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1199,1012,"1996-08-24","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1200,1012,"1996-08-24","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1201,1012,"1996-08-27","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1202,1012,"1996-08-30","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1203,1012,"1996-09-04","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1204,1012,"1996-09-04","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1205,1012,"1996-09-04","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1206,1012,"1996-09-04","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1207,1012,"1996-09-11","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1208,1012,"1996-09-12","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1209,1012,"1996-09-16","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1210,1012,"1996-09-17","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1211,1012,"1996-09-19","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1212,1012,"1996-09-19","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1213,1012,"1996-09-23","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1214,1012,"1996-09-25","Y",124 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1215,1012,"1996-09-26","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1216,1012,"1996-09-26","Y",125 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1217,1012,"1996-09-30","N",null ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1218,1012,"1996-10-04","Y",123 ) ;
insert into custorder ( order_id, cust_id, order_dt, purchased, custcard_id )
    values ( 1219,1012,"1996-10-09","Y",123 ) ;

insert into orditem ( order_id, product_id, qty ) values ( 1046,10021,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1041,10010,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1001,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1001,10003,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1041,10001,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1045,10006,4 );
insert into orditem ( order_id, product_id, qty ) values ( 1003,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1003,10003,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1039,10007,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1004,10004,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1006,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1044,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1010,10003,4 );
insert into orditem ( order_id, product_id, qty ) values ( 1010,10004,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1011,10003,12 );
insert into orditem ( order_id, product_id, qty ) values ( 1011,10004,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1012,10003,5 );
insert into orditem ( order_id, product_id, qty ) values ( 1039,10012,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1015,10003,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1043,10021,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1015,10004,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1043,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1020,10004,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1038,10009,4 );
insert into orditem ( order_id, product_id, qty ) values ( 1020,10003,16 );
insert into orditem ( order_id, product_id, qty ) values ( 1042,10006,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1037,10017,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1022,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1022,10004,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1025,10003,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1042,10016,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1035,10011,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1026,10005,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1026,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1026,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1027,10004,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1037,10010,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1028,10021,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1028,10018,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1029,10012,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1029,10018,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1031,10017,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1032,10009,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1032,10003,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1033,10020,120 );
insert into orditem ( order_id, product_id, qty ) values ( 1033,10003,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1034,10011,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1034,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1047,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1047,10009,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1048,10012,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1049,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1049,10018,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1050,10021,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1050,10003,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1051,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1051,10013,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1051,10019,100 );
insert into orditem ( order_id, product_id, qty ) values ( 1052,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1052,10001,20 );
insert into orditem ( order_id, product_id, qty ) values ( 1053,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1054,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1054,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1055,10011,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1055,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1056,10021,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1056,10009,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1057,10021,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1057,10001,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1058,10019,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1058,10010,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1061,10005,10 );
insert into orditem ( order_id, product_id, qty ) values ( 1060,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1062,10001,10 );
insert into orditem ( order_id, product_id, qty ) values ( 1063,10008,4 );
insert into orditem ( order_id, product_id, qty ) values ( 1063,10003,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1066,10017,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1064,10008,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1065,10011,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1068,10020,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1067,10001,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1068,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1069,10019,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1070,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1071,10019,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1072,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1073,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1074,10007,12 );
insert into orditem ( order_id, product_id, qty ) values ( 1074,10009,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1075,10003,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1076,10010,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1077,10012,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1078,10010,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1078,10009,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1079,10004,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1079,10006,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1079,10001,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1081,10016,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1081,10019,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1082,10011,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1083,10004,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1084,10009,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1085,10001,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1085,10009,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1086,10019,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1086,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1087,10011,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1087,10013,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1088,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1088,10003,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1089,10010,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1090,10020,4 );
insert into orditem ( order_id, product_id, qty ) values ( 1093,10021,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1093,10017,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1094,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1096,10004,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1095,10012,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1095,10011,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1096,10016,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1098,10020,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1097,10005,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1101,10001,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1099,10013,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1100,10010,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1102,10005,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1103,10017,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1103,10012,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1104,10005,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1105,10007,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1106,10016,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1107,10018,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1108,10021,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1108,10017,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1110,10010,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1112,10019,12 );
insert into orditem ( order_id, product_id, qty ) values ( 1113,10007,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1114,10018,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1115,10006,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1116,10017,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1119,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1121,10005,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1122,10010,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1123,10012,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1124,10021,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1125,10006,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1126,10021,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1126,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1127,10010,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1127,10021,345 );
insert into orditem ( order_id, product_id, qty ) values ( 1129,10021,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1129,10001,5 );
insert into orditem ( order_id, product_id, qty ) values ( 1130,10021,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1131,10003,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1132,10019,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1132,10021,10 );
insert into orditem ( order_id, product_id, qty ) values ( 1133,10021,14 );
insert into orditem ( order_id, product_id, qty ) values ( 1134,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1138,10012,125 );
insert into orditem ( order_id, product_id, qty ) values ( 1138,10010,5 );
insert into orditem ( order_id, product_id, qty ) values ( 1139,10001,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1139,10004,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1139,10005,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1140,10005,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1144,10019,300 );
insert into orditem ( order_id, product_id, qty ) values ( 1145,10019,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1145,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1145,10013,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1147,10021,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1148,10006,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1150,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1151,10014,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1151,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1152,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1154,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1155,10015,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1155,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1156,10006,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1157,10020,4 );
insert into orditem ( order_id, product_id, qty ) values ( 1159,10006,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1160,10018,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1161,10010,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1162,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1163,10001,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1164,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1165,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1166,10017,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1167,10020,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1170,10014,5 );
insert into orditem ( order_id, product_id, qty ) values ( 1170,10007,4 );
insert into orditem ( order_id, product_id, qty ) values ( 1171,10019,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1171,10011,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1172,10019,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1172,10011,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1174,10017,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1174,10004,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1175,10009,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1175,10018,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1175,10013,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1175,10012,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1183,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1176,10020,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1186,10002,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1186,10014,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1187,10001,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1190,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1190,10021,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1190,10001,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1191,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1193,10013,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1197,10009,3 );
insert into orditem ( order_id, product_id, qty ) values ( 1197,10011,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1199,10009,27 );
insert into orditem ( order_id, product_id, qty ) values ( 1201,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1201,10005,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1203,10017,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1204,10018,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1205,10017,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1207,10008,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1207,10009,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1209,10004,2 );
insert into orditem ( order_id, product_id, qty ) values ( 1211,10021,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1213,10001,6 );
insert into orditem ( order_id, product_id, qty ) values ( 1214,10020,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1215,10017,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1216,10021,100 );
insert into orditem ( order_id, product_id, qty ) values ( 1218,10019,1 );
insert into orditem ( order_id, product_id, qty ) values ( 1219,10021,1 );

insert into keyword ( keywd_id, keywd ) values ( 10001,"Folk/C & W" ) ;
insert into keyword ( keywd_id, keywd ) values ( 10002,"Pop/Top 40" ) ;
insert into keyword ( keywd_id, keywd ) values ( 10003,"Classic Rock/Oldies" ) ;
insert into keyword ( keywd_id, keywd ) values ( 10004,"Jazz" ) ;
insert into keyword ( keywd_id, keywd ) values ( 10005,"Classical" ) ;
insert into keyword ( keywd_id, keywd ) values ( 10006,"Alternative" ) ;

insert into prodkey ( keywd_id, product_id ) values ( 10005,10001 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10001,10002 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10002,10003 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10003,10004 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10003,10005 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10003,10006 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10001,10007 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10002,10008 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10004,10009 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10004,10010 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10005,10011 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10005,10012 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10005,10013 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10001,10014 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10001,10015 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10002,10016 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10003,10017 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10004,10018 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10006,10019 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10006,10020 ) ;
insert into prodkey ( keywd_id, product_id ) values ( 10006,10021 ) ;

commit ;

