load-database.sql

INSERT INTO salesrep VALUES ('SR1','William S. Burroughs','13 William Tell Court','Lawrence','KS','909137',10000.00,9.99),('SR2','Pascale Desjardin','34 Fairview','Burlington','ON','L7P4N1',1669.50,4.25),('SR3','Mr. Rogers','123 fake street','Toronto','On','j2k2f6',2143.67,0.30),('SR4','Marvin The Martian','Planet X','Mars','X','XxXxXx',3457.93,0.35),('SR5','HARRY POTTER','654 JUNEBUG BLVD','PINELAND','ONT','H5H5H5',3533.00,0.35),('SR6','Jackie Chan','22 Main Street','Toronto','ON','S4S3D2',20000.00,0.15),('SR7','James Bond','69 Agent Road','Brampton','ON','L4V5D5',15000.00,0.10),('SR8','Bruce Wayne','20 Michigan Ave','Toronto','ON','M9G4H6',4000.50,2.25),('SR9','Bob Marley','123 Somestreet Ave.','Oakville','ON','AV1234',123456.78,1.23),('SRA','Sherlock Holmes','45 Englang Ave.','Guelph','ON','AV2345',234567.89,2.34),('SRB','William Riker','87 Hemming Way','Risa','BC','8B3K6H',123912.00,9.50),('SRC','James Bond','97 CARLAW ST','OAKVILLE','ON','L3H1Y9',3500.00,7.00),('SRD','George Orwell','1234 ONTARIO ST','TORONTO','ON','M9C1Y3',7000.00,9.00);
INSERT INTO part VALUES ('01CB','SCREW',22,'HW',0.22),('02CB','HAMMER',4,'KI',5.99),('0309','42LB, BLACK',NULL,'HW',90.99),('03CB','SCREWDRIVER',2,'AP',4.99),('04CB','NAILS',100,'HW',0.50),('0D1C','Golf clubs',1,'SP',149.99),('1','books',20,'KI',4.00),('1001','MC NUT METRIC',500,'HW',1.27),('1002','MC METRIC SOCKET',300,'HW',4.83),('1003','MC PIPE FITTINGS',350,'HW',5.15),('1004','MC M3 X 25 ROLL PINS',230,'HW',0.45),('101','Hockey Sticks',4,'SP',25.00),('102','Forks',50,'KI',2.99),('103','Wrench',2,'HW',12.99),('104','Microwave',1,'AP',150.00),('1054','Printer',7,'HW',105.99),('1104','Stove',20,'AP',499.99),('111','4.9 Cu.Ft. Washer',5,'AP',998.00),('1111','Sink',6,'KI',1068.43),('1112','Faucet',9,'KI',339.61),('112','Adjustable Pliers',35,'HW',26.99),('113','20 Cu.Ft. Freezer',8,'KI',798.00),('114','Treadmill',4,'SP',1999.99),('118','Motherboard',10,'HW',87.99),('122','Basketball',3,'SP',22.99),('123','Microwave',50,'AP',150.00),('1234','Engine',6,'AP',2000.99),('124','Dishwasher',30,'AP',1100.00),('1240','APPLE AIR',1799,'HW',1900.99),('125','Hockey Stick',100,'SP',100.00),('126','Power Drill',100,'HW',200.00),('1312','Hockey Stick',25,'SP',24.99),('1346','Door Locker',15,'HW',50.00),('1362','Rigid Drill',7,'HW',279.99),('137','Barbeque',13,'AP',136.99),('1444','CPU',8,'HW',128.99),('1523','Ford Car',2500,'AP',3500.90),('1542','Screw Driver',12,'HW',4.99),('1709','Sink',20,'KI',200.00),('172','Chefs Knife',30,'KI',11.99),('1818','Padlock',30,'HW',15.99),('1956','Keyboard',5,'HW',59.99),('2','pens',3,'hW',4.00),('2085','Toaster',20,'AP',29.99),('2134','plasticcover',64,'SP',3.10),('2212','Lamp',13,'AP',15.99),('2231','gun',10,'SP',100.00),('2234','Mouse',3,'HW',99.99),('2324','Handy Microwave',9,'KI',129.00),('2349','Pizza Pan',7,'KI',9.99),('2361','BOLT',59,'HW',3.00),('2426','Mixer',100,'KI',46.99),('2427','Fishing Rod',5,'SP',45.99),('2479','Light Bulb',25,'HW',0.99),('255','Washing Machine',8,'AP',399.99),('2559','Home Depot  ',5,'SP',986.60),('2576','Stick',40,'HW',7.00),('2586','WHEEL',25,'HW',127.60),('2600','Stove',5,'KI',999.99),('2633','M-Benz',3500,'HW',8500.00),('2667','TYRES',40,'AP',1000.00),('2710','LCD touch screen',2,'AP',199.99),('2711','Digitizer',200,'HW',99.99),('2712','Motherboard',150,'KI',250.00),('2713','Audio chipset',800,'SP',9.99),('2743','Rubics cube',4,'AP',19.99),('2827','REFRIGERATOR',400,'KI',160.00),('2886','HP PRESARIO',799,'HW',900.99),('2937','Wrench',5,'HW',3.75),('2944','Playstation 3',10,'HW',300.00),('2999','Cheap',3,'HW',10.99),('3','laptops',400,'AP',6.00),('3118','Chair',10,'HW',29.99),('3284','Max 2 Kitchen Oven ',2,'HW',2231.99),('3285','Stove',3,'KI',599.99),('3287','FAN',43,'AP',400.00),('3322','Handy Stove',4,'KI',1449.00),('3324','fridge',12,'KI',750.00),('3367','RIMS',40,'AP',200.00),('341','VERNIER',20,'HW',189.00),('3507','14G Wire per foot',1000,'HW',1.14),('353','testpart',3,'AP',23.45),('3564','Hammer',6,'AP',3.20),('3657','NUT',30,'HW',3.00),('369','SONY VAIO',1100,'HW',1300.50),('372','Keychain',203,'HW',1.99),('3733','Cherry',40,'AP',1000.00),('3750','Basketball net',10,'SP',30.00),('3865','Skateboard',20,'SP',70.00),('3960','TRANSMISSION',40,'HW',500.00),('3F5D','Printer',2,'HW',69.99),('4','pencils',15,'SP',7.00),('4114','Snowboard 60in.',25,'SP',60.00),('4222','BOLT',60,'HW',64.25),('4291','NISSAN',2500,'KI',4500.00),('430','Big Cog',4,'HW',12.29),('4357','Miter Saw',20,'HW',299.99),('4452','SCREW',20,'HW',50.00),('4461','Television',5,'AP',1299.99),('4478','MICROWAVE',12,'AP',200.00),('451','DELL ASP',1000,'HW',1100.00),('4523','Caliper',3,'AP',99.99),('4532','Fridge',5,'AP',499.99),('4545','dryer',4,'AP',430.00),('4564','Kettle',30,'KI',24.99),('4663','Refrigerator',2,'AP',2299.00),('4685','Basketball',20,'SP',10.00),('4707','testpart3',11,'HW',109.15),('4717','Chain Saw',15,'HW',160.00),('473','36in. Gascook top',5,'KI',800.00),('4791','Desk',5,'HW',999.99),('4840','MAZDA-3',1000,'SP',8000.00),('4844','KNOB',40,'HW',45.50),('4963','Bolts',10,'HW',120.03),('4970','Apple',10,'SP',2000.00),('5050','buttonspring',56,'HW',2.25),('5111','hammer',50,'HW',5.00),('512','Dryer',1,'AP',499.99),('5138','Tennis Racquet',30,'SP',99.99),('519','Small Cog',12,'HW',5.50),('5380','Band Saw',3,'HW',129.99),('5433','Tire',2,'SP',149.99),('5485','HONDA CIVIC',3000,'KI',1500.00),('5525','Refrigerator',5,'KI',299.99),('555','Slap Chop',5,'KI',14.99),('5555','frying pan',20,'KI',12.00),('559','Mixing bowl set',2,'KI',32.99),('5594','Ferrarie',1500,'KI',6500.00),('5677','2.5inc Screws box',50,'HW',3.95),('5678','Transmission',7,'HW',2499.99),('5705','testpart4',9,'AP',66.39),('5717','TIEROD',40,'HW',200.00),('581','MIRRORS',10,'AP',100.00),('585','OVEN',13,'AP',100.00),('5925','X Wing Fighter',9,'HW',2000.00),('5932','BRAKECALLIPER',10,'HW',40.00),('5G2A','Desk',3,'HW',49.99),('6123','Dryer',2,'KI',399.99),('6338','Paint Scraper',3,'HW',10.99),('6595','Toaster',17,'AP',44.99),('6646','Hockey Stick',15,'SP',29.99),('6648','Laundry basket',25,'HW',19.99),('6666','hockey stick',35,'SP',21.00),('6738','Hockey Stick',75,'SP',169.99),('6785','Life microwave 22',8,'KI',80.99),('6820','Engine',30,'HW',40.99),('6958','Eddie Bauer glove',7,'SP',25.99),('7014','Hammer',3,'HW',9.99),('7165','testpart2',5,'SP',51.34),('7184','Main Board',6,'HW',142.19),('7307','ELECTRIC DRYER',500,'AP',180.00),('737','Slide Rule',89,'KI',8.99),('7401','10LB, BLACK',NULL,'HW',84.99),('7461','Dish Washer',5,'KI',699.99),('7485','George Foreman Grill',2,'KI',19.99),('7503','Solar Charger',8,'HW',929.99),('7622','Pine',30,'HW',8000.00),('7639','Refrigerator',10,'KI',50.99),('764','SEAT COVER',50,'AP',500.00),('7695','silverbutton',45,'HW',3.50),('7703','Radiant Heaters',10,'AP',108.99),('776','Handy Fridge',1,'KI',1049.00),('7777','coffee machine',30,'AP',120.00),('7816','Wine Cooler',10,'AP',1499.00),('7845','Lug Nuts',20,'HW',203.19),('7860','MICROMETER',12,'HW',179.00),('7890','Soccer Ball',30,'SP',8.23),('8032','HOCKEY STICK',5,'SP',49.98),('8044','Handy Toaster',2,'KI',125.00),('8092','Benz-A',1000,'SP',9000.00),('8167','Washer',4,'KI',499.99),('8268','DISHWASHER',47,'AP',300.00),('826B','Blender',200,'KI',79.64),('8406','VCR',1,'KI',1.99),('8413','Blender',17,'AP',50.99),('8449','20 inch Monitor',5,'HW',399.98),('8458','Tennis Racquet',266,'SP',149.99),('8478','Winch 1000lb',20,'HW',649.99),('8507','Freezer',12,'AP',560.00),('8556','BLUE PAINT',2000,'HW',25.00),('8764','Kitchen Knife',5,'AP',99.99),('8888','cordless drill',15,'HW',85.00),('8914','Berry',20,'KI',4000.00),('8943','Toaster',10,'KI',49.99),('8964','Cutting Board',26,'KI',2.99),('9034','20LB, BLACK',NULL,'HW',49.99),('9101','Soccer Ball',30,'SP',29.99),('9109','14LB,SILVER',NULL,'HW',19.49),('9197','BICYCLE',800,'SP',100.00),('9231','Dishwasher',10,'KI',70.00),('9346','longspring',24,'KI',6.53),('9393','Basketball',45,'SP',9.99),('9405','STUDS',50,'HW',10.00),('9436','Football',102,'SP',8.99),('9521','Microwave',10,'AP',80.00),('9539','Toilet Paper',220,'SP',199.99),('9550','BIG SCREEN TV',5,'AP',1999.98),('9745','TOYOTA COROLLA',4000,'AP',2500.00),('9923','SILVER SPOONS',4,'KI',99.98),('9994','Modem',43,'HW',2111.12),('9995','Keyboard',12,'HW',4111.12),('9996','Video Card',54,'HW',114.12),('9997','Motherboard',11,'HW',141.15),('9998','Stove',20,'AP',987.00),('9D2H','Washer',4,'AP',199.99),('A001','dell',20,'HW',2.05),('A002','hp',30,'HW',233.00),('A003','database',40,'AP',600.00),('A004','appel',50,'AP',9999.99),('A145','Water filter',20,'AP',29.95),('AE01','Hammer',20,'AP',12.99),('AE02','Fine Sandpaper',35,'SP',5.69),('AE03','Jigsaw',15,'AP',24.95),('AE04','Screwdriver',23,'AP',11.49),('AI1','TB Harddrive',10,'HW',89.99),('AI2','Logitech Keyboard',5,'HW',65.99),('AI3','DVD Pack',3,'HW',20.99),('AI4','Sony Laptop',2,'SP',799.99),('AIp1','DESKTOP BOX',200,'HW',2500.00),('AIp2','keyboard Control',300,'HW',60.00),('AIp3','Mouse control',200,'HW',20.00),('AIp4','Monitor',200,'HW',100.00),('AN18','Allspark',1,'AP',100.00),('AN25','Miracle Blade',10,'KI',14.99),('AN32','Magic Bullet',5,'KI',24.99),('AN64','Flux Capacitor',1,'HW',9999.00),('AP','BluRay Player',86,'AP',249.99),('AP10','Mouse',20,'HW',25.00),('AP11','Laptop',12,'HW',725.00),('AP12','Ball Pen',20,'HW',2.00),('AP13','Monitor',4,'HW',125.00),('AT01','HP Deskjet',20,'KI',299.99),('AT02','Colour Cartridge',200,'KI',29.99),('AT03','Epson Toner',120,'KI',159.00),('AT04','Network adaptor',40,'KI',3.99),('AV11','Mouse',123,'HW',1234.56),('AV22','Keyboard',234,'HW',2345.67),('AV33','Monitor',345,'HW',3456.78),('AV44','Harddrive',456,'HW',4567.89),('AX12','Iron',104,'HW',24.95),('B001','BIKE GLOVES',30,'SP',6.50),('B002','BIKE HELMET',50,'SP',8.00),('B003','BIKE SHOES',20,'SP',19.75),('B004','BIKE BELL',10,'SP',12.50),('BA74','Basketball',40,'SP',29.95),('BB17','Engine',6,'AP',2000.99),('BB42','Caliper',3,'AP',99.99),('BB53','Tire',2,'SP',149.99),('BB57','Transmission',7,'HW',2499.99),('BDA3','Stand mixer',7,'KI',250.00),('BDF2','Fishing Rod',10,'SP',39.00),('BDM4','Washing Machine',5,'AP',499.00),('BDS2','Screwdriver',20,'HW',5.90),('BGP1','Part 1',1,'AP',0.99),('BGP2','Part 2',2,'HW',1.99),('BGP3','Part 3',3,'KI',2.99),('BGP4','Part 4',4,'SP',3.99),('BM01','oven',10,'AP',449.99),('BM04','100 galvanized nails',1500,'HW',6.99),('BM71','checkered tile',500,'KI',19.99),('BM98','skis',5,'SP',375.99),('BS12','Copper',300,'HW',38.95),('BZ66','Washer',52,'AP',399.99),('CB24','Very Nice',873,'KI',14.99),('CB26','Small But Nice',871,'KI',4.99),('CB44','Decent',873,'KI',22.99),('CBFC','Not to fun',833,'KI',1.99),('CD34','Soccer',10,'SP',12.95),('CH1','Keyboard',10,'SP',50.25),('CH2','Mouse',3,'HW',20.10),('CH3','Monitor',1,'SP',500.99),('CH4','Router',8,'SP',85.39),('CL01','thisispartone',1,'AP',20.00),('CL02','thisisparttwp',2,'HW',23.00),('CL03','thisispartthree',3,'KI',4.00),('CL04','thisispartfour',4,'SP',30.00),('CPUS','INTEL CORE I7',40,'HW',450.00),('CX01','washing machine',15,'AP',1500.00),('CX02','coffie pot',23,'KI',120.00),('CX03','skateboard',57,'SP',105.00),('CX04','heater',65,'AP',380.00),('CX11','Blender',112,'KI',22.95),('DC50','TENNIS RACKET',25,'SP',68.99),('DC51','REFRIGERATOR',10,'AP',349.99),('DC52','COOKING RANGE',5,'KI',457.99),('DC53','CISCO ACCESS POINT',20,'HW',129.99),('DC68','Microwave',5,'KI',80.95),('DM01','Object1',1,'AP',10.22),('DM02','Object2',1,'AP',11.98),('DM03','Object3',1,'AP',10.42),('DM04','Object4',1,'AP',15.71),('DO34','SOCKETPIPE',15,'HW',56.48),('DOAS','KITCHENSINKTAP',22,'KI',65.28),('DOE4','HOSECLAMP',1,'AP',27.68),('DOHT','TENTSTANDS',34,'SP',132.34),('DS12','Shiny Thing',50,'KI',2.75),('DS34','Thingamjig',12,'KI',11.63),('DS56','Whatchamacallit',39,'KI',1.49),('DS78','12-inch Bearing',98,'HW',7.96),('ED55','Oven',80,'AP',600.99),('EK01','Side',2,'AP',10.00),('EK02','Back',4,'HW',20.00),('EK03','Panel',6,'HW',30.00),('EK04','Screw',8,'AP',40.00),('EP12','BLENDER',56,'AP',27.46),('EP24','TOASTER',23,'AP',48.03),('EP56','MICROWAVE',21,'AP',72.26),('EP82','OVEN',7,'KI',1589.72),('FA13','STOVE',12,'KI',1052.45),('FA14','SOCCER BALL',300,'SP',23.99),('FA15','FRIDGE',45,'AP',1500.01),('FA16','TORQUE WRENCH',250,'HW',19.99),('FB','Football',15,'SP',25.00),('FG11','Football',25,'SP',9.99),('FG13','Microwave',12,'KI',59.99),('FG23','Wrench',54,'HW',14.49),('FG24','DVD Player',34,'AP',64.49),('FP1','Part for cars',25,'AP',25.99),('FP2','Axle',50,'AP',30.99),('FP3','Caliper',75,'KI',13.99),('FP4','Battery',20,'SP',9.99),('GA1','Poder4',2,'KI',20.00),('GA2','Poder3',3,'hW',30.00),('GA3','Poder2',4,'AP',40.00),('GA4','Poder1',5,'SP',10.00),('GPUS','NVIDIA GTX580',40,'HW',800.00),('H329','Drill Bits',15,'HW',4.34),('HA4','Hammer',12,'HW',10.99),('HH','Hockey Helmet',10,'SP',50.00),('HK01','PRINTER',70,'HW',29.99),('HK02','VACUUM CLEANER',20,'AP',32.00),('HK03','DISH WASHER',35,'KI',44.89),('HK04','FOOTBALL',90,'SP',4.99),('HS01','HAMMER',50,'AP',45.90),('HS02','BOARD',45,'HW',25.60),('HS03','NAIL',1000,'KI',3.70),('HS04','SCREWDRIVER',200,'AP',20.78),('HV1','BLADE',22,'AP',25.20),('HV2','AXE',12,'HW',102.30),('HV3','GRIDER',45,'KI',99.30),('HV4','CHISEL',23,'SP',12.00),('HW23','Screwdriver',249,'HW',14.99),('JA01','Kettle',15,'KI',15.75),('JA02','Type B Screws',1200,'AP',0.69),('JA03','Type A Screws',1200,'AP',0.69),('JA04','Bat',3,'SP',15.30),('JA05','Iron Box',25,'AP',25.75),('JA06','Flashlight',3,'HW',5.00),('JA12','Tower B Casing',5,'AP',20.00),('JA13','Super Hammer',10,'HW',40.00),('JA14','Super Ball',13,'SP',19.99),('JA15','Deep Fryer',23,'KI',187.99),('JA16','Dish Washer',2,'AP',300.00),('JC10','SCREWDRIVER',2,'HW',20.00),('JC42','BOLTS',3,'HW',1.00),('JC46','DRILL',7,'HW',50.00),('JC47','HAMMER',4,'HW',35.00),('JD1','tupperware',42,'KI',4.00),('JD2','Chairs',13,'HW',4.00),('JD3','hockey-kit',5,'SP',7.00),('JD4','music-systems',50,'AP',6.00),('JL1','Car Battery',4000,'AP',50.00),('JL2','Car Battery',4000,'SP',50.00),('JL3','Car Battery',4000,'HW',50.00),('JL4','Car Battery',4000,'KI',50.00),('JLP1','CPU Component',3,'AP',259.99),('JLP2','HDD Component',5,'HW',89.99),('JLP3','Memory Component',1,'HW',24.99),('JLP4','Graphics Component',3,'SP',129.99),('JP12','NIC',2,'HW',299.99),('JP32','RAM',15,'HW',399.99),('JP43','Washing Machine',55,'AP',599.99),('JP78','Sink',65,'KI',39.99),('JS01','Keyboard',20,'HW',23.44),('JS02','Microwave',12,'KI',72.00),('JS03','Monitor',24,'HW',45.50),('JS11','Small Medkit',10,'AP',86.99),('JS12','Tardis Console',11,'AP',1231.42),('JS13','Warp Coil',17,'HW',8732.12),('JS14','Spectral shielding',12,'HW',9992.92),('JS22','Sport Shoes',90,'SP',66.66),('JT12','Dryer Thermister',5,'AP',7.99),('JT34','Cabinet Door Hinge',20,'KI',10.99),('JT56','21-inch Bicycle Tube',12,'SP',9.99),('JT78','10 Concrete Screws',40,'HW',3.99),('K287','Cooktop cleaner',25,'KI',9.90),('KD01','first part',4,'AP',12.99),('KD02','second part',5,'HW',15.99),('KD03','third part',12,'SP',24.99),('KD04','fourth part',19,'KI',1.99),('KG64','HardDrive',25,'HW',99.99),('KG65','Blender',152,'KI',84.99),('KG66','Vaccuum',3,'AP',113.99),('KG67','FTLdrives',1024,'SP',9.99),('KI13','Throwing Knife',13,'KI',13.13),('KN12','spoon',4,'KI',2.99),('KN22','skillet',12,'KI',49.99),('KN46','fork',17,'KI',3.99),('KN82','microwave',5,'AP',299.99),('LAA1','soccer balls',2,'SP',2.99),('LAA2','basket balls',2,'SP',4.99),('LAA3','tennis balls',2,'SP',3.99),('LAA4','foot balls',2,'SP',5.99),('LD01','My first part',3,'SP',19.99),('LD02','My second part',7,'SP',29.99),('LD03','My third part',1,'KI',39.99),('LD04','My fourth part',0,'SP',49.99),('LG01','food processor',18,'KI',129.99),('LG02','immersion blender',25,'KI',89.99),('LG03','corner brace',156,'HW',2.59),('LG04','door hinge',203,'HW',3.25),('LIM1','FIXING TOOLS',12,'HW',1200.00),('LIM2','PLANTING TOOLS',1,'HW',1500.00),('LIM3','ELECTRICAL',13,'HW',1300.00),('LIM4','PLUMMING TOOLS',15,'HW',1200.00),('LR01','Fork',20,'KI',1.49),('LR02','Baseball Bat',5,'SP',89.99),('LR03','Washer',2,'AP',499.99),('LR04','Hammer',14,'HW',7.99),('MC51','Airplane toilet',12,'HW',400.00),('MC52','Cheese slice',112,'KI',0.12),('MC53','Back scratcher',18,'KI',18.00),('MC54','Shrubbery',137,'AP',20.00),('MG01','42 Inch 720P Plasma',3,'AP',99.99),('MG02','XBOX 360 w Kinect',6,'AP',299.99),('MG03','Sony VAIO Laptop',2,'AP',1199.99),('MG04','Duracel AAA',5,'HW',9.97),('MH34','MasterCraft Hammer',50,'HW',25.99),('MH39','Toaster',20,'KI',29.99),('MH44','Vacuum Cleaner',14,'AP',124.36),('MH94','Easton Hockey Stick',12,'SP',149.99),('MJ1','Soccerball',10,'SP',10.00),('MJ2','Stove',3,'AP',550.00),('MJ3','Fridge',2,'AP',600.00),('MJ4','Kettle',16,'KI',25.00),('MK01','fluxCapacitor',200,'SP',4.00),('MK02','thingyMaBob',600,'HW',12.00),('MK03','doHickey',412,'KI',1.47),('MK04','whatchaCallIt',12,'AP',0.99),('MKA1','CR4 Explosive 20oz',137,'HW',340.99),('MKA2','Radio Trigger 10km',46,'HW',100.95),('MKA3','Wire Trigger',90,'HW',20.59),('MKA4','Timer Trigger',137,'HW',50.99),('MOBO','ASUS RAMPAGE',40,'HW',400.00),('MS34','12in. nail',5,'AP',1.50),('MS35','hockey stick',10,'SP',5.00),('MS36','sink',2,'KI',50.00),('MS45','drill bit',6,'HW',2.75),('MV01','FAN',10,'AP',100.00),('MV02','RAM',25,'HW',1000.00),('MV03','LED',15,'KI',180.00),('MV04','CHIP',32,'SP',2560.00),('N11','NSTEEL',11,'HW',1000.00),('N12','NALUMINIUM',12,'HW',1100.00),('N13','NCOPPER',13,'HW',1200.00),('N14','NGOLD',14,'HW',1300.00),('NK34','Table Saw',100,'AP',150.00),('NK35','Midar Saw',55,'AP',199.99),('NK36','Drill Press',178,'AP',249.98),('NK37','Eletric Sander',43,'AP',78.99),('NR12','Microwave',50,'AP',200.00),('NR23','PC',100,'HW',600.00),('NR34','Sink',100,'KI',60.00),('NR45','Sports locker',40,'SP',400.00),('ns10','table',1,'KI',65.70),('ns20','engine',1,'AP',99.50),('ns30','plastic',2,'KI',34.90),('ns40','chair',3,'KI',35.25),('PB7','Paint Brush',15,'HW',8.99),('PC01','Core i7',25,'KI',20.30),('PC02','Pentium Dual Core',85,'KI',20.30),('PC03','Core i5',25,'HW',20.30),('PC04','Core 2 Duo CPU',26,'KI',20.30),('PL01','bolt',12,'HW',0.99),('PL02','screwdriver',8,'HW',9.99),('PL03','pliers',14,'HW',15.99),('PL04','hammer',5,'HW',9.99),('PO80','toaster',10,'AP',59.99),('PO81','oven',2,'KI',359.99),('PO83','fridge',3,'AP',239.99),('PO84','stoveVent',2,'AP',89.99),('PR4','Paint Roller',3,'HW',5.99),('PS1P','Monitor',20,'HW',55.00),('PS2P','Car',10,'AP',4432.49),('PS3P','Refrigerator',15,'KI',155.00),('PS4P','Bat',30,'SP',15.10),('QR12','iron',NULL,'AP',65.89),('QR34','steel',NULL,'AP',77.77),('QR56','wood',NULL,'AP',42.63),('QR78','bar',NULL,'AP',0.34),('RD11','16 Oz. Claw Hammer',11,'HW',19.99),('RD12','Roast Rack',7,'KI',18.69),('RD13','Breadmaker',13,'AP',189.39),('RD14','14FT Trampoline',4,'SP',389.99),('RE01','Monkey Wrench',5,'SP',5.99),('RE02','Moldy Bagel',43,'AP',7.95),('RE03','Batman Stuff',2,'KI',15.00),('RE04','Textpad',42,'SP',0.50),('RK1','Tv',45,'AP',413.00),('RK2','Fridge',13,'AP',213.00),('RK3','Dishwasher',43,'AP',713.00),('RK4','Microwave',32,'AP',113.00),('RM1','CPU',10,'HW',300.00),('RM2','RAM',5,'HW',50.00),('RM3','HARDISK',3,'HW',100.00),('RM4','LCD',10,'HW',250.00),('RN1','part 1',20,'SP',15.00),('RN2','part 2',30,'SP',20.00),('RN3','part 3',90,'SP',50.00),('RN4','part 4',40,'SP',70.00),('RP34','Part 1',1234,'AP',23.50),('RP35','Part 2',12,'HW',23.50),('RP36','Part 3',124,'KI',23.50),('RP37','Part 4',134,'SP',23.50),('RR09','Torque Wrench',10,'HW',20.89),('RR21','Rubber Mallet',6,'HW',16.50),('RR32','Square Screwdriver',9,'HW',9.99),('RRM8','Nail Gun',4,'SP',36.99),('RS','Robertson Screwdrvr',20,'HW',5.25),('RS1','plastic',NULL,'AP',32.11),('RS22','Range',5,'AP',2199.99),('RS34','10mm Screws',1000,'HW',0.20),('RS4','metal',NULL,'HW',99.99),('RS42','Mixer',10,'KI',199.99),('RS5','screen',NULL,'HW',132.12),('RS52','Bicycle',4,'SP',299.99),('RS62','Canoe',4,'SP',399.95),('RS63','Rubber Chicken',12,'KI',9.95),('RS64','Bobsled',9,'SP',129.95),('RS65','Nutcracker',21,'KI',3.95),('RS8','wire',NULL,'HW',2.00),('S760','Lid Switch',18,'SP',27.50),('SD13','Toaster',14,'AP',34.99),('SD34','ScrewDriver',24,'HW',12.99),('SD7','Screwdriver',9,'HW',6.99),('SD76','BoxingGloves',7,'SP',39.99),('SD78','WoodenSpoon',65,'KI',6.99),('SJM0','2 TB Hard Drive',3,'HW',99.99),('SJM1','Maytag Washer',6,'AP',449.99),('SJM2','Whirlpool Fridge',2,'KI',679.99),('SJM3','RBK Hockey Stick',5,'SP',59.97),('SK01','Toolbox',2,'HW',20.99),('SK02','Flashlight',3,'HW',9.99),('SK03','Drill Set',3,'HW',149.99),('SK04','Compressed Air',8,'HW',3.99),('SK05','Screwdriver',4,'HW',2.99),('SK1','computer',2,'HW',45.20),('SK2','computer',2,'HW',55.20),('SK3','glass',2,'KI',45.50),('SK6','paper',1,'KI',30.50),('SL1','Copper Tube',140,'HW',14.62),('SL2','Porcelin Sink',12,'KI',99.72),('SL3','Basketball Net',10,'SP',199.99),('SL4','Toaster',140,'AP',39.99),('SM01','MONITAR',30,'AP',5.00),('SM02','KEYBOARD',25,'HW',3.00),('SM03','PRINTER',7,'KI',2.00),('SM04','SCANER',4,'SP',1.50),('SM05','Shock Absorber',11,'SP',74.99),('SM09','Heat Coil',26,'KI',67.99),('SM13','Primary tool',32,'HW',169.99),('SM21','Thermostabilizer',29,'AP',428.99),('SM91','HARDDRIVE WD ASD10',51,'HW',100.50),('SM92','HARDDRIVE WD ASD11',25,'HW',80.50),('SM93','HARDDRIVE WD ASC15',1,'HW',65.00),('SM94','HARDDRIVE SEAGATE',0,'HW',55.99),('SNK','Sink',14,'KI',75.50),('SP66','Baseball Glove',20,'SP',24.95),('SW11','Balljoint',5,'AP',10.00),('SW12','Timing belt',10,'SP',15.00),('SW13','Alternator',2,'HW',200.00),('SW14','Transmittion',1,'KI',500.00),('TB1','First Part',100,'AP',30.00),('TB12','kitchen tool',11,'ki',1001.23),('TB2','Second Part',20,'SP',15.00),('TB3','Third Part',55,'HW',80.00),('TB4','Fourth Part',70,'KI',25.00),('TB69','ball',7,'sp',3.99),('TB70','hardware',17,'hw',2.33),('TB77','screw for hardware',11,'hw',0.32),('TF01','TFPART1',21,'SP',10.75),('TF02','TFPART2',22,'SP',11.00),('TF03','TFPART3',23,'SP',11.25),('TF04','TFPART4',24,'SP',11.50),('TOWR','COOLER MASTER',40,'HW',100.00),('TS29','Wrench',32,'HW',6.00),('TS71','Level',9,'HW',8.00),('TS89','Hammer',12,'HW',5.00),('TS95','Saw',16,'HW',12.00),('WD1','wheelBarrel',5,'HW',13.99),('WD2','skates',20,'SP',99.99),('WD3','fridge',10,'AP',499.99),('WD4','faucet',25,'KI',59.99),('YSP1','part 1',3,'AP',2.99),('YSP2','part 2',2,'KI',180.49),('YSP3','part 3',1,'HW',45.59),('YSP4','part 4',5,'AP',100.99),('YSP5','part 5',6,'SP',99.99),('ZQ53','PC-5300 1GB!',8,'HW',14.99),('ZQ59','GeForce GTX 590',3,'HW',859.99),('ZQ64','PC-6400 2GB!',4,'HW',24.99),('ZQWW','A wrist watch!',15,'AP',115.35);
INSERT INTO customer VALUES ('001','Violet Jones','1146 Shirley Ave.','Brampton','ON','HOHOHO',50.0,0.00,9000,'SR2'),('002','Joan Volmer','13-1066 7th Avenue','New York','NY','906137',0.0,9000.00,0,NULL),('1','Connor','Morrison Creek','Oakville','ON','L7S2J5',5.0,0.00,1000,'SR5'),('10','Amiel','160 Fake Street','Hamilton','ON','L8N3V2',10.0,0.00,1000,'SR5'),('101','Priya','4703 Empire Crescent','Missisauga','ON','L5R1M8',2.5,150.00,450,'SR1'),('102','Shubhankar','2 Hershley Road','Missisauga','ON','L5R1M8',1.4,30.00,80,'SR1'),('105','Gaurav','4973 Empire Crescent','Missisauga','ON','L5R1M8',2.0,100.00,490,'SR1'),('111','Monica','Bronte','Oakville','ON','T3P2F4',7.5,6.20,4,NULL),('12','Eric','30 James Street','Brampton','ON','L6D4G7',20.0,100.00,100,'SR8'),('123','Nazme Mahzabeen','Roadside Way','Mississauga','Ont','L5A0J1',0.1,0.00,500,'SR2'),('124','Naima Mahjabin','6 Sir Lou Drive','Brampton','ON','L6Y4E8',2.5,818.75,1000,'SR5'),('129','Anita Caven','4 Forest','Guelph','ON','L8P4N1',4.1,1817.25,3000,'SR4'),('133','Egbert','Tidles','London','Ont','L7J9H4',3.0,1.99,44,NULL),('148','Jack Rabbit','321 Fake Street','Mississauga','ONT','L6D2I6',40.1,10000.00,30000,'SR1'),('157','Albert Manos','1112 Pleasent Drive','Oakville','Ont','L1T4D5',9.2,112.42,1000,'SR5'),('158','Ahmed Khattab','123 Winstonchurchil street','Mississauga','ON','L5N32I',10.0,234.60,3500,'SR4'),('168','NOAH FENCE','784 42ND STREET','TORONTO','ON','M1C8D6',5.0,528.24,1000,'SR5'),('174','Jack','890 Blah Rd.','Toronto','ON','M6C1A1',0.0,0.00,0,NULL),('18','Devinder','44 MArkham St.','Brampton','ON','M6y2t9',9.0,1500.00,15000,'SR1'),('183','David Luu','47 Terry Fox Way','Mississauga','ONT','L6H9F3',10.0,1000.00,5000,'SR3'),('198','Arif Rahman','Elm Drive','Brampton','Ont','L1H2K4',0.1,100.00,200,'SR3'),('2','Aditya Bahll','879 Fielder Dr','Mississauga','ON','L5S2S2',44.2,100.00,10,NULL),('207','MRMATTHEW','GRANDRAVINE DRIVE','OAKVILLE','ONT','L6H6B1',NULL,NULL,NULL,NULL),('213','Matthew','Circle','Oakville','ON','L62B4H',1.1,2.20,1,NULL),('219','MRJOSEPH','FERNLIA DRIVE','OAKVILLE','ONT','L6M4B3',NULL,NULL,NULL,NULL),('223','Kimmy Seaton','8 Bloor Street W','Toronto','ON','L5Z9K7',5.0,1000.00,1000,'SR5'),('23','Kim B','Sushi Street','Montreal','QC','I3D9K8',10.0,6000.00,600,NULL),('241','PANNU','50 DUNDAS','Brampton','ON','L6R1MK',40.0,1000.00,3000,'SR4'),('256','Sally Adams','481 Oak Street','Oakville','ON','L6H2L6',4.5,1817.25,4000,'SR4'),('257','Jean Luke','17, Egypt Dr.','Brampton','ON','L6R2N6',10.5,312.50,643,'SR1'),('277','Brandon Blake','67 Penbridge Circle','Brampton','ON','l7a2r1',15.0,32000.00,20000,'SR1'),('278','Aayron Dyal','8 Big Sky Road','Brampton','ON','l5n3i9',30.0,62000.00,40000,'SR1'),('283','Jason Shwarts','Alpha Lane','Oakville','On','L8U8V1',0.0,7859.00,10000,'SR2'),('286','pat healey','Erin Mills','mississauga','Ont','l8c2b6',10.0,569.39,1000,'SR5'),('287','Amandeep Paul','14, Scarlet','Brampton','ON','L6Y3T1',11.0,112.50,243,'SR2'),('3','Matthew Del Buono','54 Nottingham Cres','Brampton','ON','L6S5Y9',10.5,150.75,243,'SR8'),('324','ERIC PARK','101 MAIN STREET','OAKVILLE','ON','L6H6B7',25.0,2678.01,5000,'SR3'),('331','Sharin Sharma ','87 Windmill Dr','Brampton','ON','L6M4X4',15.0,400.00,500,'SR6'),('336','Micheal payne','12 samwest street','Brampton','ON','L5N21K',15.0,610.50,2000,'SR4'),('345','Bianca Santoro','605 Williamson','Burlington','ON','L7R2K7',4.5,354.87,2000,'SR4'),('366','Ivan Jandric','66 Fake Street','Brampton','ON','L6W9T1',10.0,0.00,0,NULL),('390','Ashish Sharma','77 Mergaser Cres.','Missisuaga','ON','L6W2E9',55.2,800.00,340,'SR7'),('391','Andreus','Mavis / Rathburn','Mississauga','ON','L5C3W6',3.1,7.20,5,NULL),('413','Katharine Roberts','80 Bloor Street','Mississauga','ON','L4Y7M8',1.0,0.00,1000,'SR5'),('414','Andrew Winterburn','99 Kennedy Rd N','Brampton','ONT','L6V1X8',99.0,10000.00,10000,'SR2'),('416','Bryon Hart','123 Fake Street','Mississauga','ONT','L9GE0J',40.1,10000.00,30000,'SR1'),('421','Lucas Lomnicki','1731, Missenden cres.','Mississauga','ON','L5J2T3',0.5,6734.89,8000,'SR2'),('423','Jackie','Chan','China','ON','L5M2A5',2.1,1.20,2,NULL),('424','Willy Wonka','1445, Norwood Ave.','Itasca','Il','60143',0.1,4562.76,5000,'SR3'),('428','Richard','65 TIANALEE CRES','BRAMPTON','ON','L7A2X4',5.2,1329.28,200,'SR8'),('43','DEV','50 RAYLAWSON','Brampton','ON','L6R1MK',40.0,1000.00,3000,'SR4'),('432','borat sagdeyev','650 savoy','mississauga','on','l5r2g1',5.1,7783.12,56845,'SR1'),('434','Chris Bohl','33 Humingbird Cres.','Guelph','ONT','NIG3B1',2.5,60.04,5000,'SR1'),('439','Marty Bohl','33 Humingbird Cres.','Guelph','ONT','NIG3B1',2.5,60.04,5000,'SR1'),('45','Chris B ','Fake Street','Toronto','ON','B3C5D6',5.0,70000.00,7000,'SR7'),('459','SANTE SOTTILE','326 DALTON ROAD','SUDBURY','ONT','P6MJ4K',15.7,300.80,340,'SR7'),('46','Chekov','2066 Charokee Drive','Toronto','ON','L5Z3K2',5.0,40.00,560,'SR4'),('469','DanIel','84 QUEEN STR','TORONTO','ON','M3N1A3',3.2,893.83,150,'SR8'),('473','Bob Ross','Steels','Brampton','Ont','P6MJ4K',10.0,1234.12,1000,'SR5'),('495','She Ra','15 Light Hope','Burnaby','BC','V2J4M1',0.0,500.00,0,NULL),('511','Anas','3480 Colonial Drive','Mississauga','ON','L5L5T5',50.0,0.00,10000,'SR2'),('512','suhaib ahmed','402 sergeants','mississauga','on','l5r4j2',3.2,4563.34,21345,'SR1'),('527','Obi-wan Kenobi','534 Spadina St','Toronto','ON','M5S5T3',15.7,300.80,340,'SR7'),('530','Kanye West','77 Real Road','Mississauga','ON','R7R9E9',15.0,0.00,11234,'SR1'),('542','Joanna','Sugrahill','Brampton','ON','L7A3L8',0.1,0.00,0,NULL),('55','Upinder Arora','74 Albian Cres.','Brampton','ON','L6W2x2',55.2,500.00,900,'SR6'),('559','kamil moron','Winston Churchill','mississauga','Ont','l2g2s7',15.0,269.39,500,'SR6'),('570','Dean Staples','738 Robertson Cres','Milton','Ont','L9T4W4',12.2,1252.42,2000,'SR4'),('575','Jason Lee','Mulcaster Rd.','Mississauga','Ont','L5L4RJ',90.0,0.00,9999,'SR2'),('584','Andrew','Waldoncroft','Burlington','Ont','L7L3A6',99.0,99999.99,49395,'SRB'),('587','Kiran','76 BlueBonnet','Brampton','ON','L6Y4X4',12.0,1600.00,12000,'SR1'),('597','Christina Arguilera','Some Rd.','Mississauga','Ont','L5M3RK',0.0,300.80,340,'SR7'),('599','Tiger','3422 Cage Road','Toronto','ON','5Y6U8U',5.0,234.23,1000,'SR5'),('5D1','Young kyu Han','Andover Rd','Oakville','ONT','L6H6C4',20.0,100.00,300,'SR2'),('621','Kristopher Piersiak','1382 Moon Dr.','Oakville','ON','L6H1B9',30.0,0.00,0,'SR1'),('622','Nicholas Johnson','3512 Crescent Lane','Mississauga','ON','L5C1H4',10.0,0.00,0,'SR2'),('64','Fred Caron','12 Peter Street','Port Hope','On','k9d3f4',16.1,10232.48,10000,'SR2'),('644','Kiran Choong','74 SunForest Dr','Brampton','ON','L6K4X4',10.0,300.00,500,'SR6'),('65','Brandon Brooks','433 George Street','Mississauga','On','J9gg59',12.1,12500.88,50000,'SR1'),('669','Anas Mayat','7104 Goreway Dr','Mississauga','Ont','L4T2X4',10.0,0.00,500,'SR6'),('675','STANLEY LEE','7897 MCLAUGHLIN ROAD','BRAMPTON','ONT','L6Y5H9',10.5,150.75,243,'SR8'),('676','Alex Yeung','Redcar','Kanata','Ont','L6Y5H9',10.0,1234.12,1000,'SR5'),('677','Devinder Labana','76 Mergaser Cres.','Brampton','ON','L6W2E9',45.2,400.00,243,'SR8'),('687','MATTHEW MACEDO','839 CLEMENS CRES','MISSISSAUGA','ONT','L5V2S8',60.0,3200.50,60000,'SR1'),('688','Richard','34 Rush Rd.','Aurora','ON','L4G7G5',0.4,0.00,2000,'SR4'),('6CB','JOHN DOE','QUEEN','TORONTO','ONT','M4B1V2',12.0,1020.00,2010,'SR1'),('701','Ricardo','Morton Way','Brampton','ON','L6Y2P5',0.0,0.00,1500,'SR5'),('706','SRISHTI','55 KingNoll','Brampton','ON','L6Y2X7',10.0,1500.00,6000,'SR2'),('73','Sonali Thakur','5 king cross Rd.','Brampton','ON','L6t3x3',45.2,400.00,1000,'SR5'),('730','Mit Bhojak','239 Reil Cres.','Brampton','ON','L6W2A1',45.2,700.00,340,'SR7'),('738','Subodh Bahl','979 Fielder Dr','Mississauga','ON','L5V2S2',44.2,300.00,100,'SR8'),('747','Niti Bhojak','75 Charolais blvd','Brampton','ON','L6Y2R8',23.5,300.00,243,'SR8'),('768','Robert Winterburn','99 Kennedy Rd N','Brampton','ONT','L6V1X8',2.0,4.64,500,'SR6'),('769','PAUL','50 MACLUGLIN .','Brampton','ON','L6R1TM',10.0,1100.00,11000,'SR1'),('786','Ronak Patel','Sherobee','Missi','On','L5A2H5',8.5,785.20,5000,'SR8'),('789','Kimo','44 Another St.','Toronto','ON','J7U3F9',10.0,100.00,0,NULL),('806','Zayna Shahzad','6855 Gracefield Dr','Mississauga','ONT','L5N6T4',0.1,0.00,0,NULL),('81','Eric Hoffmann','2221 Stanfield Rd.','Mississauga','ONT','L4Y1R6',10.0,0.00,0,'SR2'),('819','Michael Rovira','1400 Knight Rd','Toronto','ON','M9Z2J5',5.0,0.00,1000,'SR5'),('820','Alex Chestein','46 Thomas St','Mississauga','ONT','L5N8T1',0.2,0.00,0,NULL),('835','SUBODH','50 MACLUGLIN .','Brampton','ON','L6R1TM',10.0,1100.00,11000,'SR1'),('841','Mike Nicholson','2250 Mississauga Rd','Mississauga','Ont','L4T2B8',0.0,0.00,0,NULL),('868','ASHISH','28 Thunderbird','Brampton','ON','L6R2t7',10.0,1200.00,5000,'SR3'),('869','Mark','Kennedy Rd','Brampton','ON','L6W3G4',0.1,0.00,0,NULL),('875','Jeremy Brittain','33 Lostington st.','Walkerton','ON','WWWW21',0.2,176.11,0,NULL),('876','Jack Skillerlord','32 Lost st.','Welland','ON','QQQQ21',0.1,124.11,0,NULL),('958','Peter','Steeles Av.','Brampton','ON','L6Y2P1',0.0,0.00,0,NULL),('966','CHOURICO BROCLI','545 VEGITABLE LANE.','BARNEBEE','ONT','G5G5G5',50.0,1111.11,5000,'SR3'),('982','Chris Primerano','749 Gardinia Way','Caledon','ONT','L8D4H2',25.0,0.00,10000,'SR2'),('991','Adam Budzianowksi','2167 Mountain Grove Ave.','Burlington','ON','L7P2H8',99.9,0.00,10000,'SR2'),('999','Jordan Ripley','FakeStreet','Mississauga','On','L7Y0C2',10.0,0.00,20500,'SR1'),('9CB','CRAIG BONIN','GREAVES','HUNTSVILLE','ONT','P1H1V2',22.0,1000.00,2000,'SR1'),('AC1','Arvinder','13 Weir Chase','Mississauga','ON','L5B2X9',1.0,400.00,1200,'SR3'),('AC2','Luvleen','27 Paisley Blvd','Mississauga','ON','L5B2X9',1.5,350.00,2000,'SR3'),('ADB','Alex Denbok','71 Telfer Rd.','Collingwood','ON','L9Y4S2',20.0,500.90,0,'SR3'),('AE4','Amber Eadie','4318 Forest Fire Lane','Mississauga','ON','L4W3P4',0.2,129.47,1000,'SR2'),('AE5','George Blue','12 Anywhere Road','Oakville','ON','M5H3T4',0.1,234.56,1500,'SR2'),('AI1','ify','60 claderstone rd','brampton','Ont','L6p2b6',50.1,2000.00,5000,'SR2'),('AI2','Ted','329 upshur st','washington','AB','L6p2Y4',0.0,1500.00,1000,'SR2'),('AI7','Alexandra Isac','Lakeshore Rd E.','Burlington','Ont','L7L4Z2',NULL,NULL,NULL,NULL),('AI8','Stefen Holgate','Sussex Ave','Sunny Ville','Ont','L3D5S4',NULL,NULL,NULL,NULL),('AN1','Al Ng','4045 Garnetwood Chase','Mississauga','ONT','L4W2N9',10.0,1000.00,15000,'SR2'),('AN2','Tom Sawyer','52 Rush Drive','Toronto','ONT','T7G3P3',15.0,2000.00,25000,'SR2'),('AT1','Andrew Toole','54 Custy Lane','Custyville','ON','k1k1k1',10.1,10.10,99,NULL),('AT2','Andrew OToole','5 Custy Lane','Custyville','ON','k1k1k1',10.2,10.20,100,'SR8'),('AV3','Alex Vitiuk','2266 Grand Oak Trail','Oakville','ON','AV3456',12.3,12345.67,55555,'SR1'),('AV4','Borat Sagdiyev','69 Kazahstan St.','Kazahtown','ON','AV4567',23.4,23456.78,55555,'SR1'),('B.1','Jimmy','Lola','Hamilton','ON','L6T8X3',25.0,1720.75,2000,'SR2'),('B.2','Surabhi','Tiina hills','Georgetown','ON','L6Y4M6',12.0,1988.05,2200,'SR2'),('BB1','Brandon Brooks','433 George Street','Mississauga','On','J9gg59',12.1,12500.88,50000,'SR4'),('BB2','Fred Caron','12 Peter Street','Port Hope','On','k9d3f4',16.1,10232.48,10000,'SR5'),('BD5','Bradley Dixon','1711 Cypress Creek Drive','Cypress Creek','ONT','K7L3L7',0.0,0.00,1000,'SR3'),('BD6','Moe Sizlack','11 Main Street','Oakville','ONT','L7L6N4',0.0,500.00,0,'SR3'),('BG1','Brandon','7279 Corrine','Oakville','ON','L5N5C3',NULL,NULL,NULL,NULL),('BG2','Ken','789 Fake St.','Oakville','ON','L2M3N5',NULL,NULL,NULL,NULL),('BM4','Brent Munro','2100 Doherety Ln.','Burlington','Ont','L1P9G3',10.0,0.00,0,'SR3'),('BM8','Miles Davis','234 Canterbury Cr.','Burlington','Ont','L7R8Z0',5.0,0.00,1500,'SR3'),('C01','HAAKIM ROBERTS','17-2440 BROMSGROVE ROAD','MISSISSAUGA','ONT','L5J4J7',0.3,200.00,500,'SR1'),('C02','TOM BAKER','24 TRUSCOTT ROAD','MISSISSAUGA','ONT','L5J4J8',0.2,150.00,400,'SR2'),('CBB','WILMA C LIM','BRONTE SOUTH','MILTON','ONT','L9T5A8',10.0,2500.00,3000,'SR6'),('CH1','Cesar Hernandez','Trafalgar Rd','Oakville','ON','L1A5U8',0.1,100.32,400,'SR7'),('CH2','Jack K','Leslie St','Toronto','ON','M3L1L5',0.7,414.12,600,'SR6'),('CL3','Kristina Lyon','Winter Park','Mississauga','ONT','L5B4G6',10.0,1000.00,20000,'SR9'),('CL9','Curtis Lyon','Summer Park','Mississauga','ONT','L5B4E6',5.0,100.00,10000,'SR9'),('CP','COSMIN POPESCU','2045 REDSTONE','OAK','ONT','L6M5B1',NULL,NULL,NULL,'SR1'),('CP1','Carlos Pereira','Lakeshore','Mississauga','ON','L5G1H3',25.0,35.96,2000,'SR4'),('CX1','CJ Lee','218 Timeless Rd','Oakville','On','L9M5C1',15.0,0.00,50000,NULL),('CX2','John Smith','38 Victoria St','Hamilton','On','C8D4M1',10.0,1300.00,3000,'SR1'),('CXX','WILJEANSON C LIM','BRONTE SOUTH','MILTON','ONT','L9T5A8',5.0,1500.00,5000,'SR6'),('DC1','FRED COLLEN','BRAYSLANE','OAKVILLE','ON','L6M3J9',10.0,100.00,1000,'SR9'),('DC2','DEBORSHI CHOUDHURY','407 PARKLANE','OAKVILLE','ON','L6M4T9',10.0,200.00,4000,'SR9'),('DM1','David Min','6160 Fake Street','Mississauga','Ont','L5N5W5',0.0,9.99,10001,NULL),('DO4','DENISORELLANA','350CONSTITUTIONBLVRD','MISSISSAUGA','Ont','L4Y423',10.0,0.00,500,'SR6'),('DOJ','JIMENACILIA','2200IVERNIARD','MISSISSAUGA','Ont','L4Y43S',15.0,345.21,1000,'SR5'),('DS1','Laura Michaels','234 Willowbrance Drive','Toronto','ON','M9W7L3',5.0,834.12,500,'SR3'),('DS2','David Shiplo','34 Queen Street','Brampton','ON','H4M5M2',3.0,341.95,750,'SR3'),('EH9','Bobby Light','989 Nestle Dr.','Toronto','ONT','H7Y3B8',5.0,0.00,500,'SR1'),('EK1','Mr. Kwong','987 Threes Street','Toronto','ON','B1C1D1',10.0,100.00,100,'SR3'),('EK2','Ms. Wendy','654 Fours Street','Oakville','ON','C1D1E1',5.5,500.00,500,'SR3'),('FA6','FAHAD ANSARI','SPRUCE ST','BURLINGTON','ON','L7K6Y9',99.9,900.11,600,'SR6'),('FA7','JOHN WILLMER','GERRARD ST','TORONTO','ON','K0L8Y6',0.0,999.99,1,NULL),('FG1','Farzad Gharegozlo','23 Waterdale Rd','Brampton','ONT','L5V6B3',10.0,0.00,1000,'SR4'),('FG2','James Dean','64 Highland','Waterloo','ONT','N2V3B9',0.0,54.00,500,'SR4'),('FP1','Fil Pacheco','139 Vickies','Toronto','ON','L1L5K4',10.0,1000.00,NULL,NULL),('FP2','Jack Frost','139 Frostie Avenue','Vancouver','BC','Q5L544',15.0,100.00,NULL,NULL),('GA2','Amit','23 Dundas Road','Missisauga','ON','L4R1M8',1.8,45.00,50,'SR1'),('HC1','HARSHARANJIT','128 TRAFALGAR','OAKVILLE','ON','L5L2N8',3.0,300.00,1000,'SR4'),('HC2','SHIVDEEP','432 KESTELL BLVD','MISSISSAUGA','ON','L2B2A0',2.0,500.00,2000,'SR4'),('HSA','HARINDER SINGH','BLOOR STR','BRAMPTON','ON','L6Y4L6',10.2,0.00,1000,'SR4'),('HSB','MAT SMITH','MILLADY STR','OAKVILLE','ON','L4R3Z8',9.4,300.00,1000,'SR4'),('HV1','CROOK WINDY','1430 KERR ST','ACTON','QC','T2S4J5',10.0,2500.00,1000,'SR4'),('HV2','HARVINDER','25 TARFALGER RD','OAKVILLE','ON','L6Y5R4',22.1,500.00,10000,'SR4'),('JA','Jason Auckland','965 Princeton Blvd.','Toronto','ON','H6D2S1',10.0,200.50,0,'SR6'),('JA1','Fake Person','84 Chancery Lane East','Oakville','ON','L6J5P8',10.0,100.00,500,'SR6'),('JA2','Justin Abeto','902-1229 Marlborough Ct.','Oakville','ON','L6H3B6',10.0,200.00,500,'SR6'),('JA3','Fake Name','123 Fake St','Milton','ON','L6M2P2',5.0,0.00,0,'SR7'),('JA5','Jairus Abuya','12 King st','Toronto','ONT','M9C5H6',15.1,10.25,10000,'SR6'),('JA6','Nelson Mandela','13 Victory st','Joberg','MTL','N955H6',21.1,11.23,11000,'SRA'),('JA9','Martin Sheen','516 Whiteoaks Blvd.','Oakville','ON','L6H2V6',25.0,123.10,800,'SR6'),('JC4','Jonathan Clifford','8 Charles','Erin','ONT','553039',0.1,0.00,2000,'SR4'),('JC6','Clark Kent','Fortress of Solitude','Toronto','ONT','553040',0.2,200.00,2000,'SR4'),('JD2','Harold','547 Kreele Avenue','Missisauga','ON','L4R1M1',4.0,120.00,80,'SR4'),('JL1','Jason Li','101 Merton Street','Toronto','ON','M4W1J7',5.0,150.00,500,'SR5'),('JL2','James May','669 Bay Street','Toronto','ON','M5J2R8',8.0,180.00,500,'SR5'),('JL3','Jason Liu','3556 Fountain Park Boulvard','Brampton','ON','L5E6B1',10.0,55.78,5500,'SR5'),('JL4','Jack Gump','2234 Garden Road Avenue','Mississauga','ON','O5J3N9',4.0,155.78,7500,'SR5'),('JP4','Jason','513 Bagin St','Oakville','Ont','F5Y6V8',10.0,50.00,1000,'SRA'),('JP7','Fred','123 Wellington Dr','Bronte','Ont','D4R6G9',10.0,0.00,1500,'SRA'),('JS1','Jo ','2600 Don Mills Road','Toronto','ON','M2J3B4',2.0,400.00,1200,'SR5'),('JS2','Shane','67 Flower Blvd','Mississauga','ON','L5B2X9',1.5,1350.00,5000,'SR5'),('JS8','Jean-Luc Kirk','3242 Orionus St.','Toronto','ON','5K3N9B',98.9,5999.93,9000,NULL),('JS9','John-Stephen','6777 Ridgeway cres','Mississauga','ON','L7X3V9',99.9,9532.44,5000,'SRA'),('JSA','John-Stephen','6777 Ridgeway cres','Mississauga','ON','L7X3V9',99.9,9532.44,5000,'SRA'),('JSK','Jean-Luc Kirk','3242 Orionus St.','Toronto','ON','5K3N9B',98.9,5999.93,9000,NULL),('JTJ','Jason Tarr','205 My Own Street','Mississauga','ONT','L2M9k9',15.5,507.20,10000,'SRA'),('JTK','Martin Jones','333 Singleton Court','Toronto','ONT','L2J4G6',5.1,389.00,500,'SRB'),('K50','Kevin Teixeira','42 Springview Ave','Toronto','ON','M3M1B4',50.0,0.00,10,'SR5'),('K51','Jennifer Tavares','1221 Spadina Ave','Toronto','ON','M6H5B4',25.0,350.00,0,'SR5'),('KB','BILL GATES','001 SILICON VALEY','SAN-FRANCISCO','CAL','12LDD',10.0,2500.00,5000,'SRA'),('KD8','Nadira De Silva','12 Nasmith St','Brampton','Ont','L6S 4J',NULL,NULL,NULL,NULL),('KD9','Kushane De Silva','2 Nasmith St','Brampton','Ont','L6S 4Y',NULL,NULL,NULL,NULL),('KG3','Keegan Galea','Felan St.','Oakville','Ont','L6K3A9',70.5,10.00,99999,'SR3'),('KG4','Steegan Galmer','Bay St.','Toronto','Ont','H6D1B8',70.5,81.00,100,'SR2'),('KN7','Kevin','riverdale','mississuaga','ONT','L5M4R7',0.2,45.00,500,'SR5'),('KN9','Sauron','orcstreet','mount doom','HEL','L0L0L0',0.8,0.00,1000,'SR5'),('LA2','Luay','2134 hallow drive','Mississauga','ON','f3a2g8',0.1,300.00,40,'SRB'),('LA3','M/M','4256 array drive','Mississauga','ON','d3a1f4',0.2,350.00,45,'SRB'),('LD1','Luca DeCaprio','116 Seclusion Cresent','Brampton','ONT','2014',10.0,1200.34,5000,'SR5'),('LD2','John Smith','123 runaway lane','Toronto','ONT','1234',50.0,500.99,2302,'SR5'),('LG5','Leilani Graham','Horai-cho','Shimada','Shz','B0G0A3',35.0,NULL,3500,'SR6'),('LG6','Bobby Flay','Limderidge Rd','Hamilton','ON','G7H8I9',15.0,NULL,2200,'SR6'),('LR3','Lorenzo Ramos','1234 Fake Street','Oakville','Ont','L6H2L1',50.0,0.00,100,'SR8'),('LR4','Guy Incognito','1255 Hidden Road','Mystery Ville','Ont','B4V1G8',5.0,25.99,10,NULL),('MC1','Mr Curtis Lord of Humans','5639 Fields Drive','Mississauga','ON','L5N6B7',NULL,NULL,NULL,NULL),('MC2','MR Anderson','31 Spectrum Drive','Mississauga','ON','L2N3B4',NULL,NULL,NULL,NULL),('MG1','Matt Glover','2405-3575 Kaneff Cres','Mississauga','ON','L5A3Y5',0.1,99.87,1000,'SR1'),('MG2','Cheryl Gough','1611 King St E.','Hamilton','ON','L8K1T6',0.1,79.50,99999,'SR2'),('MH5','Michael Holt','1665 Covington Terrace','Mississauga','ON','l5m6l1',0.0,0.00,5000,'SR6'),('MH9','Wayne Gretzky','Some Street','LA','CAL','lfg6l1',0.0,0.00,5000,'SR6'),('MJ1','Mark Jacklin','Maple ave','Milton','Ont','L9T3X6',NULL,NULL,NULL,NULL),('MJ2','Brian Smith','Street St','Toronto','Ont','P6X9G5',NULL,NULL,NULL,NULL),('MK1','Michael Kreitzer','190 Kerr St','Oakville','ON','L6K3A9',4.3,106.58,500,'SR1'),('MK4','Munib Kaddafo','30 Lakeshore','Oakville','ON','L5L6N6',NULL,NULL,NULL,'SR6'),('MK5','Ozzy OZ','110 Duffren','Toronto','ON','M1M2S2',NULL,NULL,NULL,'SR6'),('MK7','Jose Cheeseburger','19 Victoria St','Anytown','ON','J7K3H9',14.3,1006.58,5000,'SR9'),('MS2','Maria Serratore','419 Lanor Ave','Toronto','ONT','M8W2R7',10.0,300.00,2000,'SR6'),('MS4','Bob Bramble','555 Yonge St.','Toronto','ONT','M9C5NY',20.0,300.00,1000,'SR6'),('MV1','MARK VIDA','55 HEROES LN','CALLIFORNIA','LA','20034T',5.0,1000.00,3500,'SR7'),('MV2','ROB LOVEIT','2 MARVEL ST','KNOXVILLE','TN','300B4R',5.0,500.00,1000,'SR7'),('ND1','NAWAB SINGH','REXDALE','BRAMPTON','ON','L6P2M5',5.5,50000.00,80000,'SR7'),('ND2','TAJINDER SINGH','WOODBRIDGE','VAUGHAN','ON','L6P2M5',7.0,60000.00,90000,'SR7'),('NK3','Nityan Khanna','1885 Main St.','Brampton','Ont','L6G7I8',13.1,555.10,12345,'SR7'),('NK4','John Smith','1 South St.','Mississauga','Ont','L5G3GR',15.5,653.70,73452,'SR7'),('NR7','Nevine','Dorval','Oakville','ON','L6Y1F8',10.0,0.00,0,'SR7'),('NR8','LUKE','Dundas','Oakville','ON','L6K5T9',0.0,500.00,0,NULL),('ns1','Mr. navi','bronte','oakville','ON','L8h8C4',9.5,3024.60,5000,NULL),('ns2','Mr. Singh','third line','oakville','ON','L8C9K2',7.5,2500.99,5000,'SR7'),('PC1','Pat Colangelo','The Beastly Beast Street','Cobourg','Ont','L6M2N7',11.2,200.20,200,'SR8'),('PL1','Pavlo Leheta','Main St','Mississauga','ON','L4Z1H8',10.0,0.00,5000,NULL),('PL2','James Howard','Bay St','Toronto','ON','M5M7N8',10.0,0.00,5000,'SR7'),('PO1','Patrick','1337Silversmith','Oakville','On','L6m2x4',5.0,0.00,0,'SR7'),('PO2','Carl','119brant','Toronto','On','Q2b2x8',0.0,0.00,0,'SR7'),('PS1','Paramveer','Charolais','Brampton','ON','L6Y2R9',20.0,150.00,1000,NULL),('PS2','Sham','Kingo','Brampton','ON','L5T5ES',30.0,100.00,1500,'SR7'),('QR4','qahtan','LakeShore','Mississauga','ON','G1L5S7',NULL,NULL,NULL,NULL),('QR5','Ahmed','Kipling','Etobicok','ON','M9V3Z8',NULL,NULL,NULL,NULL),('RD1','Rich Davidson','286 River Oakvs Blvd','Oakville','ON','L6H5T1',0.0,65.00,500,'SR7'),('RD2','Rose Daniels','Hurontario','Mississauga','ON','L5G1H3',10.0,100.00,1000,'SR6'),('RD4','Kirsten Davidson','286 River Oaks Blvd','Oakville','ON','L6H5T1',10.0,42.00,1000,'SR5'),('RD7','Ryan Dunn','64 Robinson Drive','Milton','On','L9T2E3',0.2,0.00,0,NULL),('RD8','George St-Pierre','2146 Parkway Street','Montreal','Qb','H3A6R6',0.1,0.00,0,NULL),('RE1','Ryan Egan','Yellow Brick Rd.','Oakville','ON','L6H1Y5',0.0,0.00,2000,'SR4'),('RE2','Bogus Face','Red Boy St.','Mississauga','ON','M2H1G5',0.0,0.00,2000,'SR4'),('RK7','Sukhdeep','citycenter','Missisaugga','ON','L6T7R5',32.0,1320.67,1300,'SR8'),('RK8','Kourr','sheridan','oakville','ON','L6Y5D4',14.0,13134.67,1310,'SR8'),('RM1','Jim','BROOK CRES','BRAMPTON','ON','L6Y3N4',10.0,250.00,1000,'SR8'),('RM2','RAZIA','DUNVEGAN CRES','BRAMPTON','ON','L9U3N9',5.0,260.00,500,'SR8'),('RN1','Rahul','Kingknoll','Brampton','ON','L6Y2K3',20.0,25.00,700,'SR8'),('RN2','Sean','Rolling','Brampton','ON','L7W3I1',40.0,15.00,850,'SR8'),('RP5','foo bar','King','Toronto','On','L5J2F5',8.9,785.50,5900,'SR8'),('RRW','Ryan Riddell','3232 Colonial Dr','Mississauga','ONT','L5L5K8',20.0,1323.98,12000,'SR8'),('RRZ','Chris Demelo','2040 Garthwood Rd','Mississauga','ONT','L5L2H8',5.5,2643.38,5000,'SR8'),('RS1','RS','matthew st','oakville','ON','l6h4r3',NULL,NULL,NULL,NULL),('RS2','RSneek','erin st','oakville','ON','l6h4r3',NULL,NULL,NULL,NULL),('RS3','Ravi','RockyPoint Cre','Brampton','ON','L6V4M4',5.0,0.00,3000,'SR8'),('RS4','David','Kennedy Road','Brampton','ON','L6V4M4',3.0,0.00,1000,'SR8'),('RS8','Stewie Griffin','31 Spooner Street','Quoahog','ONT','L3T4V1',10.0,150.95,5000,'SR8'),('RS9','Ryan Scully','16 Cardboard Box Way','Oakville','ONT','L8F3W3',25.5,125.50,2000,'SR8'),('SD2','Jack Arnold','Upper Middle Rd W','Oakville','ON','L1T3U5',0.0,39.99,0,'SR9'),('SD4','Simon Doyle','Francis Rd','Burlington','ON','L7T3X7',10.0,0.00,45,'SR9'),('SK1','Mrs. Simer','oakmead rd','oakville','ON','L8C5H2',10.5,5000.20,8000,NULL),('SK2','Mrs. kaur','pinecliff rd','oakville','ON','L6F8G2',9.5,4500.80,5000,'SR9'),('SK3','Shahryar Khalid','Maple Dr.','Oakville','ON','L6H4F8',5.0,0.00,400,'SR9'),('SK4','Chef Boyardee','Pasta Lane','Mississauga','ON','L4LJ8J',0.0,44.30,400,'SR9'),('SL1','Scott Latham','1165 Glenashton Drive','Oakville','ONT','L6H5L7',10.0,0.00,500,'SR5'),('SL2','Hayley Attwell','176 Mill Street','Acton','ONT','L6H3K2',10.0,7.26,500,'SR3'),('SM0','Steven Miller','286 Kent Cres.','Burlington','ON','L7L4T1',0.2,125.99,5000,'SR3'),('SM1','SHAMIL MALIKOV','1205 Bonin Crescent','Milton','ON','L9T7T6',5.5,0.00,5000,'SRB'),('SM2','REGINA ASKAROVA','205 Mail Crescent','Milton','ON','L9T8H6',2.5,1000.00,5000,'SRB'),('SM3','Nazem Kadri','43 Maple Leaf Rd.','Toronto','ON','T0R0N0',0.6,0.00,99999,'SR8'),('SM7','Sean Morris','454 Winston Rd.','Oakville','ON','L6L4W8',13.0,350.00,25,NULL),('SM9','Travis Tooler','419 Tree Ave.','Toronto','ON','L6E2N2',25.0,1760.00,45,NULL),('SMA','SAMI','MAIN ST','TORONTO','ON','L8V3G6',3.0,7.05,5,'SR9'),('SMB','GOSH','BAY ST','HAMILTON','ON','L8N2Z2',5.5,2.22,0,'SR9'),('SW8','Shem Wloczanko','2801 Awesome St','Mississauga','Ont','B8B8B8',50.1,120.15,50000,'SRB'),('SW9','Bobby Joe','6732 Something rd','Milton','Ont','G6G6G6',15.0,100.00,1000,'SRB'),('TB1','Tarndeep','Hendricks','Brampton','ON','L6Y4K9',30.0,0.00,500,'SRA'),('TB2','Mike','Mavis','Brampton','ON','L6R3J9',10.0,50.00,1000,'SRA'),('TB4','Sarah Thomas','Windy Way Rd.','Oakville','ON','l5lt6y',0.2,200.00,500,'SRA'),('TB6','Thomas Buss','Broad Hollow','Mississauga','ON','l5l5d2',0.1,0.00,1000,'SRA'),('TF1','TANIA FIORDIMONDO','85 EMMETT AVE','TORONTO','ON','M6M5A2',NULL,NULL,NULL,'SRA'),('TF2','RYAN EGAN','1268 REDBANK CREST','OAKVILLE','ON','L6HIY5',NULL,NULL,NULL,'SRA'),('TS3','Travis Shipley','9 Foord Rd','AJAX','ONT','L1S1K6',NULL,NULL,NULL,NULL),('TS4','Rocky Racoon','8 Penny Ln','Mining Hills','ONT','H1N1F0',NULL,NULL,NULL,NULL),('WD8','Ronald McDonald','111 King St W','Toronto','On','M4B1B4',0.3,100.00,1000,'SR5'),('WD9','Wesley','2347 Brookhurst rd','Mississauga','On','L5L2R2',0.5,0.00,6000,'SR2'),('YS1','Yibo','9999 ys st','Oakville','ON','L3H9A3',NULL,NULL,NULL,NULL),('YS2','Jack','5555 ys st','Toronto','ON','M3T3Y4',NULL,NULL,NULL,NULL),('ZQ1','Zain Qureshi','7174 Baskerville Run','Mississauga','ON','L5W1W3',0.3,1500.00,5000,'SRA'),('ZQ2','Ankush Jaswal','3 Waterfront Drive','Brampton','ON','L7A3M7',0.2,500.00,2500,'SRA');
INSERT INTO salesorder VALUES ('00123','2010-11-11','157'),('00250','2010-11-25','157'),('0055','2011-11-06','ND1'),('0056','2011-11-07','ND1'),('1','2011-12-30','1'),('10','2011-12-30','CP'),('1000','2011-11-12','K50'),('10000','2011-12-30','CP'),('1001','2011-11-12','K50'),('101','2000-11-04','102'),('1014','2011-12-30','219'),('102','2000-04-12','101'),('1080','2011-12-30','207'),('11223','2010-05-15','81'),('122','2010-11-08','999'),('12345','2005-10-12','213'),('12346','1989-12-12','875'),('123AE','2011-11-14','5D1'),('123CB','2011-11-14','9CB'),('12489','2010-10-25','124'),('12494','2010-11-05','124'),('124CB','2011-11-11','9CB'),('13136','1951-09-06','002'),('14235','2010-10-22','345'),('15272','2009-10-29','676'),('156','2010-11-09','999'),('1570','2009-07-26','542'),('16169','2010-11-11','286'),('17393','2009-01-11','806'),('18881','2009-03-03','391'),('19','2010-03-10','12'),('19841','2010-11-02','345'),('2','2011-12-30','2'),('21548','2009-12-28','512'),('22','2010-12-26','10'),('222','2011-01-11','621'),('223','2011-01-11','621'),('22322','2010-08-02','257'),('22334','2010-07-19','81'),('22345','2005-10-12','213'),('22423','2009-10-25','688'),('23026','2009-11-09','982'),('23223','2010-10-22','511'),('242','2010-10-31','324'),('24325','2010-06-22','287'),('25014','2009-11-18','414'),('2653','2011-11-18','ADB'),('2654','2011-11-18','ADB'),('266','2009-11-12','644'),('27442','2009-01-01','413'),('28024','2009-11-17','414'),('28303','2009-06-06','391'),('30004','2009-09-12','570'),('30433','2010-10-24','511'),('30964','2009-11-12','644'),('321','2010-08-24','65'),('34137','2010-11-11','286'),('35176','2008-01-01','366'),('36673','2009-11-10','669'),('36881','2009-09-26','575'),('37478','2009-11-16','241'),('37706','2007-11-29','428'),('39687','2009-11-12','2'),('39849','2007-12-06','687'),('41223','2011-12-30','991'),('41224','2011-12-30','991'),('41707','2005-06-15','675'),('41823','2009-11-12','2'),('42279','2009-11-12','868'),('42374','2009-11-14','706'),('44669','2008-03-20','158'),('44916','2009-11-15','676'),('456','2010-10-12','64'),('456OF','2011-11-14','5D1'),('46','2000-11-04','JD2'),('48162','2007-07-11','428'),('50','2008-11-05','45'),('50316','2008-03-20','158'),('50859','2009-11-27','675'),('52771','2009-11-14','868'),('53075','2009-05-05','416'),('55555','1989-11-11','875'),('56025','2009-07-26','542'),('57077','2009-10-08','677'),('58654','2009-09-30','575'),('58747','1991-08-11','584'),('58748','1991-05-20','584'),('59163','2009-11-17','241'),('60','2010-10-12','45'),('60558','2009-11-15','701'),('60748','2009-11-10','669'),('64329','2010-11-11','747'),('67199','2009-11-14','706'),('67437','2009-11-15','73'),('680','2009-11-16','73'),('69825','2009-06-06','416'),('6j432','2010-10-31','424'),('6j53f','2010-11-09','421'),('75305','2009-10-16','43'),('76105','2009-01-10','806'),('7825','2009-11-11','512'),('78446','2009-10-10','43'),('79483','2010-11-11','747'),('82404','2009-02-02','819'),('83764','2009-12-27','982'),('83882','2009-11-12','677'),('84360','2007-12-05','687'),('8452','2009-03-30','413'),('85425','2008-03-01','366'),('86727','2009-02-02','3'),('876','2010-11-10','324'),('87748','2009-09-04','570'),('9023','2009-05-08','688'),('94523','2009-11-15','701'),('96949','2008-04-16','819'),('9817','2009-03-02','3'),('99999','2007-08-06','001'),('AE001','2011-11-11','AE4'),('AE002','2011-11-11','AE4'),('AI10','2010-10-31','AI7'),('AI9','2010-11-09','AI7'),('AIo01','2011-01-11','AI1'),('AIo02','2000-05-21','AI2'),('AN582','2011-08-01','AN1'),('AN595','2011-10-10','AN1'),('AO001','2011-11-11','AC1'),('AO002','2012-11-11','AC1'),('AO003','2012-11-11','AC2'),('AP623','2011-01-20','198'),('AT1','2010-07-30','AT1'),('AT2','2010-12-17','AT2'),('AV123','2010-01-01','AV3'),('AV234','2010-02-02','AV3'),('BB21','2010-08-24','BB1'),('BB46','2010-10-12','BB2'),('BD22','2011-10-31','BD5'),('BD23','2011-11-09','BD5'),('BG001','2011-12-30','BG1'),('BG002','2011-12-30','BG2'),('BG004','2011-11-29','KB'),('BM215','2008-11-11','BM4'),('BM216','2008-11-16','BM4'),('CB2','2011-09-02','434'),('CB3','2011-09-03','434'),('CH1','2010-11-09','CH1'),('CH2','2010-09-12','CH1'),('CL012','2010-11-12','CL9'),('CL111','2010-11-12','CL3'),('CPA45','2011-10-20','CP1'),('CPA46','2011-10-22','CP1'),('CXO01','2009-04-30','CX1'),('CXO02','2010-02-15','CX1'),('DCOR1','2010-11-10','DC2'),('DCOR2','2010-11-13','DC2'),('DM001','2010-08-27','DM1'),('DM002','2010-08-27','DM1'),('DO3ER','2010-11-08','DO4'),('DS123','2010-10-22','DS2'),('DS456','2011-05-13','DS2'),('EKo01','2011-11-09','EK1'),('EKo02','2011-11-10','EK1'),('FA001','2010-10-10','FA6'),('FA002','2010-09-08','FA7'),('FG642','2011-11-10','FG1'),('FG643','2011-11-11','FG1'),('FP176','2010-12-01','FP1'),('FP177','2010-11-02','FP2'),('GA101','2000-10-08','GA2'),('GA125','2000-12-05','GA2'),('HK001','2011-11-11','HC1'),('HK002','2010-10-11','HC2'),('HS004','2011-11-01','HSA'),('HS438','2011-11-10','HSB'),('HV3T4','2011-12-30','HV2'),('HV4R1','2011-04-12','HV2'),('HW234','2011-09-10','123'),('JA001','1999-10-15','JA5'),('JA002','1995-10-25','JA6'),('JA111','2010-12-25','JA1'),('JA112','2009-12-22','JA2'),('JA453','2010-03-03','JA2'),('JA543','2010-03-03','JA2'),('JC2','2011-12-30','JC4'),('JC9','2011-12-30','JC4'),('JD102','2000-04-12','46'),('JL001','2002-11-11','JL1'),('JL002','2002-11-11','JL2'),('JLO1','2010-11-10','JL3'),('JLO2','2010-12-11','JL4'),('JP1','2010-05-02','JP4'),('JP2','2010-05-03','JP4'),('JS001','2011-11-11','JS1'),('JS002','2013-11-11','JS2'),('JS345','2010-10-01','JS9'),('JS346','2010-09-27','JS8'),('JT11','2010-11-30','JTJ'),('JT22','2010-12-01','JTJ'),('KD001','2011-12-30','KD9'),('KD002','2011-12-30','KD9'),('KG124','2010-11-16','KG3'),('KG125','2010-08-20','KG3'),('KI10','2011-11-28','001'),('KI11','2011-11-15','001'),('KI345','2011-04-15','123'),('KN485','2012-02-13','KN7'),('KN738','2013-05-02','KN9'),('LAA01','2010-11-12','LA2'),('LAA02','2010-11-13','LA2'),('LD111','2009-12-11','LD1'),('LD222','2011-01-01','LD2'),('LG011','2011-05-10','LG5'),('LG022','2010-12-07','LG6'),('LLL10','2011-12-12','CBB'),('LLL11','2011-12-28','CBB'),('LR001','2010-11-09','LR3'),('LR002','2010-11-09','LR3'),('MC121','2011-12-30','MC1'),('MC122','2011-12-30','MC1'),('MG101','2010-11-16','MG1'),('MG201','2010-11-16','MG2'),('MH321','2011-11-14','MH5'),('MH345','2011-11-14','MH5'),('MJ1','2011-11-12','MJ1'),('MJ2','2011-11-12','MJ1'),('MK1','2012-10-20','MK1'),('MK2','2012-10-22','MK1'),('MK246','2011-11-12','MK4'),('MK568','2011-11-22','MK4'),('MS344','2011-08-05','MS2'),('MS345','2011-10-10','MS2'),('MV11','2010-10-11','MV1'),('MV12','2011-12-30','MV1'),('NK001','2015-09-11','NK3'),('NK531','2021-10-11','NK3'),('NR567','2011-11-11','NR7'),('NR765','2011-11-11','NR7'),('nso1','2011-10-02','ns1'),('nso2','2011-09-15','ns2'),('O0011','2010-11-01','C01'),('O0020','2010-11-05','C01'),('O2277','2011-10-11','277'),('O2777','2011-10-11','277'),('PC001','2010-10-10','PC1'),('PC002','2010-11-10','PC1'),('PL001','2011-11-13','PL1'),('PL002','2011-11-14','PL1'),('po.1','2011-11-11','B.1'),('po.2','2011-11-11','B.2'),('PS1O','2011-10-10','PS1'),('PS2O','2011-11-10','PS2'),('QR123','2009-11-23','QR4'),('QR456','2009-12-23','QR4'),('RD321','2011-12-30','RD4'),('RD345','2011-12-30','RD1'),('RD471','2010-08-20','RD7'),('RD493','2010-08-23','RD8'),('RE001','2008-10-10','RE1'),('RE002','2009-11-11','RE1'),('RK10','2011-11-14','RK8'),('RK123','2011-12-25','786'),('RK465','2011-10-02','786'),('RK9','2011-11-14','RK7'),('RM001','1989-10-05','RM2'),('RM002','1989-10-20','RM2'),('RN1','2011-09-12','RN1'),('RN2','2011-07-18','RN1'),('RR347','2011-11-14','RRW'),('RR743','2011-11-12','RRW'),('RS101','2011-11-12','RS3'),('RS102','2011-11-13','RS3'),('RS601','2011-12-30','RS9'),('RS602','2011-12-30','RS9'),('RSOR1','2011-03-16','RS1'),('RSOR2','2011-05-25','RS1'),('SD123','2011-12-30','SD4'),('SD124','2011-12-30','SD4'),('SJM00','2010-11-12','SM0'),('SJM01','2010-11-11','SM0'),('SK111','2011-04-28','SK3'),('SK112','2011-05-22','SK3'),('SKor1','2011-11-02','SK1'),('SKor2','2011-10-22','SK2'),('SL001','2010-09-21','SL1'),('SL002','2010-09-22','SL1'),('SM001','2010-12-10','SM7'),('SM002','2010-12-10','SM7'),('SM0A1','2011-11-11','SMA'),('SM0B1','2011-11-15','SMB'),('SM101','2010-08-22','SM1'),('SM202','2010-08-25','SM1'),('SW4','2008-11-10','SW8'),('SW5','2008-11-10','SW8'),('TB1','2011-10-11','TB1'),('TB2','2011-11-20','TB1'),('TB333','2011-11-15','TB4'),('TB666','2011-11-24','TB4'),('TF025','2011-05-28','TF1'),('TF037','2011-11-10','TF1'),('TS111','2011-11-16','TS3'),('TS112','2011-11-16','TS3'),('WD001','2010-11-15','WD9'),('WD002','2010-11-16','WD9'),('YSOD1','2011-12-30','YS1'),('YSOD2','2011-12-30','YS1'),('ZQ001','2011-11-19','ZQ1'),('ZQ002','2011-11-19','ZQ1');
INSERT INTO orderprod VALUES ('00123','1001',500,4.50),('00250','1002',300,8.50),('0055','N13',15,20000.00),('0056','N14',20,30000.00),('1','CH1',2,64.00),('10','CPUS',10,200.00),('1000','101',2,25.00),('10000','GPUS',10,450.00),('1001','104',1,150.00),('101','1',12,420.00),('1014','9109',5,99.95),('102','2',25,450.00),('1080','9034',3,149.97),('11223','123',1,150.00),('122','5525',1,269.99),('12345','3564',2,2.10),('12346','9998',12,2111.12),('123AE','5G2A',1,49.99),('123CB','02CB',2,5.99),('12489','AX12',10,2495.00),('12494','BA74',5,149.75),('124CB','03CB',2,4.99),('13136','KI13',13,13.13),('14235','BS12',8,311.60),('15272','353',10,23.45),('15272','5705',19,66.39),('15272','7165',41,51.34),('156','2212',4,57.57),('1570','1818',99,15.99),('1570','4685',89,10.00),('1570','7639',58,50.99),('16169','2743',33,19.99),('16169','737',32,8.99),('17393','2426',78,46.99),('17393','8268',40,79.64),('17393','8458',67,149.99),('18881','9231',83,70.00),('18881','9521',42,80.00),('19','118',2,175.98),('19841','CD34',10,129.50),('2','CH2',5,615.00),('21548','5050',53,2.25),('21548','7695',60,3.50),('21548','9346',91,6.53),('22','122',1,22.99),('222','113',1,798.00),('223','114',1,1999.99),('22322','1956',33,46.33),('22334','125',1,100.00),('22345','3564',3,1.20),('22423','512',17,499.99),('22423','6646',53,29.99),('22423','7461',65,699.99),('23026','3285',60,599.99),('23026','5138',52,99.99),('23223','372',2,4.28),('242','EP82',1,2012.05),('24325','1234',21,45.33),('25014','6595',78,44.99),('25014','8964',32,2.99),('25014','9101',41,29.99),('2653','FB',2,50.00),('2654','HH',1,50.00),('266','1346',52,50.00),('266','3865',48,70.00),('27442','1709',21,200.00),('27442','4717',4,160.00),('28024','5380',38,129.99),('28024','6595',41,44.99),('28303','2944',33,300.00),('28303','3750',56,30.00),('28303','9231',19,70.00),('30004','430',83,12.29),('30004','519',65,5.50),('30004','7184',62,142.19),('30433','9393',1,11.76),('30964','1346',79,50.00),('30964','4114',3,60.00),('30964','473',96,800.00),('321','5433',4,599.96),('34137','2743',62,19.99),('34137','5925',82,2000.00),('34137','9539',7,199.99),('35176','8032',90,49.98),('35176','8449',44,399.98),('35176','9550',87,1999.98),('36673','1104',86,499.99),('36673','4564',83,24.99),('36673','6648',4,19.99),('36881','2479',19,0.99),('36881','4791',86,999.99),('37478','2667',49,1000.00),('37478','3367',72,200.00),('37478','581',54,100.00),('37706','7307',75,180.00),('37706','8556',49,25.00),('37706','9197',21,100.00),('39687','1240',59,1900.99),('39687','451',97,1100.00),('39849','585',91,100.00),('39849','8268',95,300.00),('41223','5111',1,5.00),('41224','3324',1,750.00),('41707','6338',34,10.99),('41707','6958',91,25.99),('41823','2886',46,900.99),('41823','369',36,1300.50),('41823','451',43,1100.00),('42279','2361',59,3.00),('42279','7860',76,179.00),('42374','4222',59,64.25),('42374','4452',47,50.00),('42374','4844',18,45.50),('44669','6785',85,80.99),('44669','8764',73,99.99),('44916','353',56,23.45),('44916','4707',41,109.15),('456','5678',1,2499.99),('456OF','0D1C',1,149.99),('46','JD1',12,420.00),('48162','2827',24,160.00),('48162','7307',24,180.00),('50','4963',29,2009.27),('50316','2559',94,986.60),('50316','3284',22,2231.99),('50316','8764',83,99.99),('50859','559',6,32.99),('50859','6958',50,25.99),('50859','8413',51,50.99),('52771','2361',14,3.00),('52771','341',69,189.00),('52771','3657',15,3.00),('53075','2324',74,129.00),('53075','776',98,1049.00),('55555','9997',4,141.00),('56025','7639',62,50.99),('56025','7703',57,108.99),('57077','1523',21,3500.90),('57077','2633',14,8500.00),('57077','8092',91,9000.00),('58654','3118',60,29.99),('58654','4791',48,999.99),('58654','9436',81,8.99),('58747','2349',5,9.99),('58748','2427',2,45.99),('59163','2667',9,1000.00),('59163','764',21,500.00),('60','2576',1,70.00),('60558','4663',52,2299.00),('60558','7816',32,1499.00),('60558','8478',11,649.99),('60748','2999',89,10.99),('60748','4564',39,24.99),('64329','5485',21,1500.00),('64329','9745',51,2500.00),('67199','2586',4,127.60),('67199','4452',61,50.00),('67437','3733',90,1000.00),('67437','4970',76,2000.00),('67437','7622',86,8000.00),('680','3733',74,1000.00),('680','8914',54,4000.00),('69825','3322',74,1449.00),('69825','776',15,1049.00),('69825','8044',38,125.00),('6j432','1362',1,279.99),('6j53f','1111',4,4273.72),('75305','3960',73,500.00),('75305','9405',4,10.00),('76105','2426',73,46.99),('76105','6738',98,169.99),('7825','2134',72,3.10),('7825','5050',20,2.25),('78446','3960',33,500.00),('78446','5717',82,200.00),('78446','5932',73,40.00),('79483','4291',22,4500.00),('79483','4840',41,8000.00),('79483','9745',55,2500.00),('82404','2600',99,999.99),('82404','7485',35,19.99),('83764','255',43,399.99),('83764','3285',83,599.99),('83764','4357',72,299.99),('83882','1523',27,3500.90),('83882','5594',22,6500.00),('84360','3287',49,400.00),('84360','4478',61,200.00),('84360','585',99,100.00),('8452','1709',17,200.00),('8452','8507',88,560.00),('8452','9998',58,987.00),('85425','9550',74,1999.98),('85425','9923',8,99.98),('86727','4461',53,1299.99),('86727','8167',57,499.99),('876','EP12',2,67.21),('87748','3507',44,1.14),('87748','430',6,12.29),('9023','7014',50,9.99),('9023','7461',48,699.99),('94523','4663',80,2299.00),('94523','7503',31,929.99),('96949','2600',36,999.99),('96949','555',77,14.99),('96949','8943',79,49.99),('9817','6123',49,399.99),('9817','8167',58,499.99),('9817','8406',49,1.99),('99999','SP66',200,24.95),('AE001','AE01',1,12.99),('AE002','AE02',2,11.38),('AI10','AI1',2,179.99),('AI9','AI4',1,799.99),('AIo01','AIp1',2,5000.00),('AIo01','AIp2',3,900.00),('AN582','AN64',1,9999.00),('AN595','AN18',2,200.00),('AO001','AP10',2,50.00),('AO001','AP11',1,725.00),('AO002','AP12',10,20.00),('AT1','AT01',2,5.00),('AT2','AT03',2,40.00),('AV123','AV11',1,1234.56),('AV234','AV22',1,2345.67),('BB21','BB53',4,599.96),('BB46','BB57',1,2499.99),('BD22','BDF2',1,45.00),('BD22','BDM4',1,599.00),('BD23','BDA3',1,45.00),('BG001','BGP1',1,0.99),('BG002','BGP3',1,2.99),('BM215','BM71',1,19.99),('BM216','BM04',2,13.98),('CH1','CH2',13,400.50),('CH2','CH3',9,8000.50),('CL012','CL01',300,6000.00),('CL111','CL03',100,400.00),('CPA45','HA4',2,21.98),('CPA46','SD7',2,13.98),('CXO01','CX02',2,204.00),('CXO02','CX04',1,323.00),('DCOR1','DC53',4,129.99),('DCOR2','DC51',1,349.99),('DO3ER','DOAS',1,65.28),('DO3ER','DOE4',2,55.36),('DS123','DS34',314,742.98),('DS456','DS12',98,129.32),('EKo01','EK01',10,5.50),('EKo02','EK02',5,20.00),('FA001','FA13',13,1052.45),('FA002','FA14',4,23.99),('FG642','FG13',1,59.99),('FG643','FG24',1,64.49),('FP176','FP1',15,500.00),('FP176','FP2',5,450.00),('GA101','GA1',12,120.00),('GA125','GA3',5,25.00),('HK001','HK01',5,49.99),('HK001','HK02',11,34.22),('HS004','HS01',4,45.90),('HS438','HS03',20,3.70),('HV3T4','HV2',11,11.90),('HV4R1','HV2',15,22.30),('HW234','H329',2,8.68),('JA001','JA01',15,15.25),('JA002','JA02',19,15.70),('JA111','JA12',1,300.00),('JA112','JA13',1,40.00),('JA453','JA03',10,6.90),('JA543','JA03',1,128.00),('JC2','JC10',47,10.00),('JC9','JC42',2,40.00),('JD102','JD2',25,450.00),('JL001','JL2',1,50.00),('JL002','JL1',1,50.00),('JLO1','JLP1',1,259.99),('JLO2','JLP3',1,24.99),('JP1','JP12',5,459.99),('JP2','JP32',10,559.99),('JS001','JS01',20,50.00),('JS002','JS02',45,66.87),('JS345','JS13',4,5000.00),('JS346','JS11',5,6000.00),('JT11','JT56',1,9.99),('JT22','JT34',5,54.95),('JT22','JT78',3,11.97),('KD001','KD01',1,14.99),('KD002','KD03',2,19.99),('KG124','KG67',15,45.00),('KG125','KG64',3,251.00),('KI10','SP66',200,28.00),('KI345','K287',2,19.80),('KN485','KN12',15,44.85),('KN738','KN46',19,59.85),('LAA01','LAA3',3,94.99),('LAA02','LAA4',2,120.34),('LD111','LD01',1,19.99),('LD222','LD02',3,109.99),('LG011','LG02',5,449.95),('LG022','LG01',2,259.98),('LLL10','LIM1',20,1500.50),('LLL11','LIM2',40,1000.50),('LR001','LR04',1,89.99),('LR002','LR03',1,499.99),('MC121','MC51',2,800.00),('MC122','MC54',4,80.00),('MG101','MG01',1,49.99),('MG201','MG02',2,69.99),('MH321','MH94',1,149.99),('MH345','MH34',2,51.98),('MJ1','MJ1',3,30.00),('MJ2','MJ3',1,600.00),('MK1','MK01',34,4.00),('MK2','MK01',100,4.00),('MK246','MKA1',10,3409.90),('MK568','MKA2',2,201.90),('MS344','MS34',2,3.00),('MS345','MS45',3,5.00),('MV11','MV03',4,48.00),('MV12','MV02',8,320.00),('NK001','NK34',3,450.00),('NK001','NK35',1,199.99),('NR567','NR34',5,60.00),('NR765','NR12',1,200.00),('nso1','ns10',400,400.45),('nso2','ns40',350,500.90),('O0011','B001',2,13.00),('O0020','B003',5,98.75),('O2277','2713',5,99.95),('O2777','2710',5,1250.00),('PC001','PC01',2,200.10),('PC002','PC02',2,300.20),('PL001','PL04',1,9.99),('PL002','PL01',1,0.99),('po.1','A001',200,20000.00),('po.2','A001',5,22000.00),('PS1O','PS1P',2,110.00),('PS2O','PS4P',5,75.50),('QR123','QR34',50,NULL),('QR456','QR34',25,NULL),('RD321','6666',2,500.00),('RD345','5555',10,15.00),('RD471','RD14',1,389.99),('RD493','RD13',1,189.39),('RE001','RE01',5,5.99),('RE001','RE02',5,6.99),('RE002','RE04',3,0.99),('RK10','RK2',3,33400.00),('RK123','RP34',458,789.52),('RK465','RP35',49,89.20),('RK9','RK1',300,13000.00),('RM001','RM3',1,150.00),('RM002','RM1',2,80.00),('RN1','RN3',7,400.00),('RN2','RN4',5,350.00),('RR347','RR09',2,31.68),('RR743','RRM8',3,83.24),('RS101','RS22',1,2199.99),('RS102','RS52',1,299.99),('RS601','RS62',1,459.95),('RS601','RS63',8,12.95),('RS602','RS64',1,149.95),('RS602','RS65',3,6.95),('RSOR1','RS1',2,NULL),('RSOR2','RS8',5,NULL),('SD123','SD13',1,34.99),('SD123','SD78',1,6.99),('SJM00','SJM0',1,99.99),('SJM01','SJM3',2,119.94),('SK111','SK01',2,29.99),('SK111','SK02',1,12.99),('SK112','SK04',3,5.99),('SKor1','SK3',450,500.99),('SKor2','SK6',300,300.76),('SL001','SL1',10,146.20),('SL002','SL2',1,99.72),('SM001','SM13',2,169.99),('SM002','SM05',4,74.99),('SM0A1','SM02',10,3.00),('SM0B1','SM04',8,1.50),('SM101','SM92',1,80.50),('SM101','SM94',10,559.90),('SM202','SM93',5,325.00),('SM202','SM94',1,55.99),('SW4','SW11',1,15.00),('SW5','SW12',1,20.00),('TB1','TB3',5,240.00),('TB2','TB4',2,100.00),('TB333','TB70',1,2.33),('TB666','TB69',2,7.98),('TF025','TF02',5,55.00),('TS111','TS89',2,10.00),('TS112','TS29',3,18.00),('WD001','WD2',2,199.98),('WD002','WD1',1,13.99),('YSOD1','YSP2',3,170.29),('YSOD2','YSP5',2,100.00),('ZQ001','ZQ53',4,67.75),('ZQ002','ZQ64',1,28.24);
INSERT INTO invoice VALUES ('00255','2010-11-09','00123'),('00SJM','2010-11-12','SJM00'),('1','2011-12-30','1'),('10','2011-11-13','1000'),('10279','2011-10-11','O2777'),('11','2000-05-12','101'),('11111','2010-11-11','99999'),('1122','2011-11-12','0056'),('12','2010-04-25','321'),('12111','2010-10-23','23223'),('1212','2011-11-18','2654'),('12121','1989-11-12','12346'),('1234','2011-11-14','123AE'),('12345','2011-12-30','41224'),('123758','2009-09-10','75305'),('14357','2010-11-18','14235'),('154328','2010-11-10','876'),('163708','2009-01-01','27442'),('1CB','2011-11-15','123CB'),('20','2010-12-26','19'),('210487','2007-12-05','48162'),('234','2011-09-02','CB2'),('243749','2009-09-04','87748'),('250686','2009-10-27','9023'),('25255','2010-11-08','12489'),('2608','2011-12-30','1080'),('264485','2009-11-09','23026'),('293','2010-11-09','122'),('303369','2009-11-12','42279'),('309555','2009-11-17','28024'),('326233','2009-11-14','67199'),('34wr23','2010-10-26','6j53f'),('365413','2009-11-17','94523'),('371535','2009-11-12','39687'),('37405','2008-03-20','44669'),('384089','2009-10-01','36881'),('433243','2010-06-22','24325'),('43719','2005-06-15','41707'),('43n34j','2010-10-28','6j432'),('482260','2009-11-12','60748'),('4939','1991-05-23','58747'),('567042','2009-02-03','82404'),('5678','2011-11-14','456OF'),('618141','2010-11-11','16169'),('635779','2010-11-11','64329'),('658285','2009-11-15','44916'),('684182','2009-12-20','18881'),('693599','2009-01-11','76105'),('698908','2009-11-12','7825'),('707378','2007-12-10','39849'),('743244','2009-05-02','86727'),('7685','2010-10-12','60'),('779802','2008-01-02','85425'),('783272','2009-11-05','680'),('787286','2009-07-26','56025'),('817332','2009-11-17','59163'),('8975','2008-11-05','50'),('960560','2009-11-13','83882'),('966317','2009-05-05','53075'),('974145','2009-11-12','266'),('AE111','2011-12-11','AE001'),('AI01','2011-11-11','AO002'),('AI13','2010-11-09','AI9'),('AIi01','2011-01-16','AIo01'),('AN123','2011-11-11','AN595'),('AT1','2010-01-30','AT1'),('AVIN1','2010-01-01','AV123'),('BB12','2010-04-25','BB21'),('BD98','2011-10-31','BD22'),('BGI001','2011-11-14','BG001'),('BM001','2008-11-11','BM215'),('CH1','2010-11-09','CH1'),('CL11','2010-11-12','CL111'),('CP1','2011-06-05','10'),('CPAI1','2011-10-26','CPA45'),('CXI01','2009-04-30','CXO01'),('DCV1','2010-11-13','DCOR2'),('DM0001','2010-02-13','DM001'),('DO23ER','2010-11-08','DO3ER'),('DS8','2010-07-12','DS123'),('EH345','2010-07-22','22334'),('EKi01','2011-11-10','EKo01'),('FA123','2010-10-10','FA001'),('FG642','2011-10-10','FG642'),('FP10','2010-11-10','FP176'),('GA21','2000-11-11','GA101'),('GA29','2000-08-11','GA125'),('HK001','2011-11-11','HK002'),('HSIN1','2011-11-01','HS004'),('I0011','2010-11-01','O0011'),('I0020','2010-11-05','O0020'),('IA123','2011-09-10','HW234'),('IKI10','2011-11-30','KI10'),('JA005','1999-10-15','JA001'),('JA222','2010-12-25','JA111'),('JA632','2010-03-03','JA453'),('JC2','2011-12-30','JC9'),('JD11','2000-05-12','46'),('JD12','2000-06-06','JD102'),('JL001','2010-11-10','JLO1'),('JL003','2010-11-11','JL001'),('JL004','2010-11-11','JL002'),('JP5','2010-05-02','JP1'),('JS01','2011-11-11','JS001'),('JS2','2010-10-01','JS345'),('JT33','2010-12-15','JT11'),('KD09','2011-12-30','KD001'),('KG225','2010-08-21','KG125'),('KG226','2010-11-17','KG124'),('KN111','2011-05-22','KN485'),('kourr','2011-11-14','RK9'),('LA101','2010-11-12','LAA02'),('LD001','2011-11-13','LD111'),('LG123','2011-05-11','LG011'),('LR111','2010-11-09','LR001'),('MC444','2011-12-30','MC122'),('MG30','2010-11-12','MG101'),('MH3244','2011-11-14','MH345'),('MH4239','2011-11-14','MH321'),('MJ1','2011-11-12','MJ1'),('MK001','2012-10-24','MK1'),('MK008','2011-11-15','MK246'),('MS555','2011-11-11','MS344'),('MV0A','2010-10-11','MV11'),('MV0B','2011-12-30','MV12'),('N2462','2011-11-13','RS101'),('NK243','2005-10-11','NK001'),('NR500','2011-11-11','NR567'),('ns20','2011-10-14','nso1'),('ns21','2011-09-20','nso2'),('PC01','2010-05-05','PC001'),('PL111','2011-11-13','PL001'),('PS1I','2011-11-05','PS1O'),('QR1123','2009-11-23','QR456'),('RD222','2011-12-30','RD345'),('RD490','2010-08-23','RD493'),('RE001','2010-11-12','RE001'),('RK234','2011-12-03','RK123'),('RM1','1989-10-05','RM001'),('RM2','1989-10-20','RM002'),('RN1','2011-06-25','RN2'),('RR623','2011-11-15','RR347'),('RS785','2011-12-30','RS601'),('RSX3','2011-12-30','RSOR1'),('sam','2011-11-11','po.1'),('SD49','2011-12-30','SD123'),('SK200','2011-11-06','SKor1'),('SK201','2011-11-26','SKor2'),('SK222','2011-04-29','SK111'),('SL001','2010-09-24','SL001'),('SM00X','2011-11-15','SM0A1'),('SM101','2010-12-10','SM001'),('SM25','2010-09-01','SM202'),('SW87','2008-11-10','SW4'),('TB1','2011-11-20','TB2'),('TB8970','2011-11-25','TB666'),('TF123','2011-05-28','TF025'),('TS211','2011-11-16','TS111'),('TT7864','2011-06-12','HV4R1'),('WD100','2010-11-12','WD001'),('WLIM4','2012-12-28','LLL11'),('YSIV1','2011-11-11','YSOD1'),('ZQ001','2011-11-19','ZQ001'),('ZQ002','2011-11-19','ZQ002');
INSERT INTO invprod VALUES ('00255','1002',800),('00SJM','SJM0',1),('1','CH1',2),('10','101',2),('10279','2710',5),('11','1',10),('11111','SP66',200),('1122','N14',20),('12','2',21),('12','5678',1),('12111','372',2),('1212','HH',1),('12121','9997',4),('1234','5G2A',1),('12345','3324',1),('123758','3960',9),('123758','9405',1),('14357','BS12',8),('154328','EP12',4),('163708','1709',8),('163708','4717',4),('1CB','02CB',2),('20','118',2),('210487','2827',11),('210487','7307',10),('243749','3507',36),('243749','430',5),('250686','7014',17),('250686','7461',47),('25255','AX12',10),('2608','9034',3),('264485','3285',49),('264485','5138',21),('293','5525',1),('303369','2361',41),('303369','7860',58),('309555','5380',5),('309555','6595',32),('326233','2586',3),('326233','4452',61),('34wr23','1112',1),('365413','4663',36),('365413','7503',12),('371535','1240',24),('371535','451',62),('37405','6785',56),('37405','8764',27),('384089','2479',4),('384089','4791',59),('433243','1956',33),('43719','6338',4),('43719','6958',14),('43n34j','1111',1),('482260','2999',50),('482260','4564',18),('4939','2349',34),('567042','2600',55),('567042','7485',2),('5678','0D1C',1),('618141','2743',24),('618141','737',10),('635779','5485',12),('635779','9745',46),('658285','353',12),('658285','4707',20),('684182','9231',53),('684182','9521',37),('693599','2426',25),('693599','6738',70),('698908','2134',48),('698908','5050',5),('707378','585',60),('707378','8268',81),('743244','4461',9),('743244','8167',10),('7685','2576',1),('779802','9550',68),('779802','9923',1),('783272','3733',6),('783272','8914',12),('787286','7639',45),('787286','7703',21),('817332','2667',1),('817332','764',13),('8975','4963',9),('960560','1523',1),('960560','5594',14),('966317','2324',26),('966317','776',6),('974145','1346',28),('974145','3865',15),('AE111','AE01',1),('AI01','AP12',1),('AI13','AI4',1),('AIi01','AIp1',15),('AN123','AN18',2),('AT1','AT01',2),('AVIN1','AV11',2),('BB12','BB57',1),('BD98','BDF2',0),('BD98','BDM4',1),('BGI001','BGP1',1),('BM001','BM71',1),('CH1','CH2',5),('CL11','CL03',100),('CP1','CPUS',NULL),('CPAI1','HA4',2),('CXI01','CX02',2),('DCV1','DC51',1),('DM0001','DM02',79),('DO23ER','DOE4',1),('DS8','DS34',314),('EH345','125',5),('EKi01','EK01',5),('FA123','FA13',10),('FG642','FG13',1),('FP10','FP1',15),('GA21','GA4',10),('GA29','GA3',21),('HK001','HK02',1),('HSIN1','HS01',3),('I0011','B001',2),('I0020','B003',5),('IA123','H329',2),('IKI10','SP66',300),('JA005','JA01',3),('JA222','JA12',1),('JA632','JA03',1),('JC2','JC47',2),('JD11','JD1',10),('JD12','JD2',21),('JL001','JLP1',1),('JL003','JL1',1),('JL004','JL2',1),('JP5','JP12',5),('JS01','JS02',44),('JS2','JS13',4),('JT33','JT56',1),('KD09','KD01',1),('KG225','KG64',3),('KG226','KG67',15),('KN111','KN12',15),('kourr','RK1',2),('LA101','LAA4',4),('LD001','LD01',1),('LG123','LG02',3),('LR111','LR04',1),('MC444','MC54',1),('MG30','MG01',1),('MH3244','MH34',1),('MH4239','MH94',1),('MJ1','MJ1',3),('MK001','MK01',2),('MK008','MKA1',10),('MS555','MS34',1),('MV0A','MV03',4),('MV0B','MV02',8),('N2462','RS22',1),('NK243','NK34',3),('NR500','NR34',5),('ns20','ns10',250),('ns21','ns40',400),('PC01','PC01',2),('PL111','PL01',1),('PS1I','PS4P',4),('QR1123','QR34',33),('RD222','5555',7),('RD490','RD13',1),('RE001','RE01',1),('RK234','RP34',324445),('RM1','RM1',1),('RM2','RM4',2),('RN1','RN3',5),('RR623','RRM8',2),('RS785','RS62',1),('RS785','RS63',8),('RSX3','RS5',5),('sam','A001',2),('SD49','SD78',7),('SK200','SK3',359),('SK201','SK6',450),('SK222','SK01',2),('SK222','SK02',1),('SL001','SL1',10),('SM00X','SM01',20),('SM101','SM13',2),('SM25','SM93',4),('SW87','SW11',1),('TB1','TB4',2),('TB8970','TB69',10),('TF123','TF02',5),('TS211','TS89',NULL),('TT7864','HV2',55),('WD100','WD2',2),('WLIM4','LIM2',40),('YSIV1','YSP2',3),('ZQ001','ZQ53',4),('ZQ002','ZQ64',1);