Petstore data script 2

insert into Supplier values(1,'Hardin','Fannie','606-568-1851','8999 Weeping Willow Road','40403',7926);
insert into Supplier values(2,'Fugate','Jody','615-625-9479','787 Park Street','37172',10896);
insert into Supplier values(3,'Murphy','Faye','402-477-9061','4218 Industrial Drive','68108',9208);
insert into Supplier values(4,'Frost','Kaye','606-630-0346','7049 Carrington Road','40965',7972);
insert into Supplier values(5,'Sims','Stephanie','615-048-9494','4696 Green Street','37167',10893);
insert into Supplier values(6,'Mason','Whitney','307-645-4066','5230 Pleasant Valley Drive','82001',11694);
insert into Supplier values(7,'Lamb','Malcolm','502-787-8033','4379 Greensburg Street','40218',7979);
insert into Supplier values(8,'Roberts','Jody','907-797-6770','527 Mud River Valley Road','99502',5855);
insert into Supplier values(9,'Dillard','George','803-448-2061','9713 Wildwood Street','29201',10740);
insert into Supplier values(10,'Rhodes','Brad','308-466-7092','633 West Street','68847',9198);
insert into Supplier values(11,'Parrish','Mandy','606-033-1460','9641 Elm Street','40422',7935);
insert into Supplier values(12,'Love','David','606-282-6165','5745 Mud River Valley Road','40330',7955);
insert into Supplier values(13,'Hughes','Natasha','615-798-8614','5610 Church Street','38501',10830);
insert into Supplier values(14,'Harrison','Angela','606-121-7621','8558 N. Main Street','41075',7949);
insert into Supplier values(15,'Osborne','Christine','615-245-8406','1565 Sunnyhill Trace','37087',10862);
commit;insert into Supplier values(1,'Hardin','Fannie','606-568-1851','8999 Weeping Willow Road','40403',7926);
insert into Supplier values(2,'Fugate','Jody','615-625-9479','787 Park Street','37172',10896);
insert into Supplier values(3,'Murphy','Faye','402-477-9061','4218 Industrial Drive','68108',9208);
insert into Supplier values(4,'Frost','Kaye','606-630-0346','7049 Carrington Road','40965',7972);
insert into Supplier values(5,'Sims','Stephanie','615-048-9494','4696 Green Street','37167',10893);
insert into Supplier values(6,'Mason','Whitney','307-645-4066','5230 Pleasant Valley Drive','82001',11694);
insert into Supplier values(7,'Lamb','Malcolm','502-787-8033','4379 Greensburg Street','40218',7979);
insert into Supplier values(8,'Roberts','Jody','907-797-6770','527 Mud River Valley Road','99502',5855);
insert into Supplier values(9,'Dillard','George','803-448-2061','9713 Wildwood Street','29201',10740);
insert into Supplier values(10,'Rhodes','Brad','308-466-7092','633 West Street','68847',9198);
insert into Supplier values(11,'Parrish','Mandy','606-033-1460','9641 Elm Street','40422',7935);
insert into Supplier values(12,'Love','David','606-282-6165','5745 Mud River Valley Road','40330',7955);
insert into Supplier values(13,'Hughes','Natasha','615-798-8614','5610 Church Street','38501',10830);
insert into Supplier values(14,'Harrison','Angela','606-121-7621','8558 N. Main Street','41075',7949);
insert into Supplier values(15,'Osborne','Christine','615-245-8406','1565 Sunnyhill Trace','37087',10862);
commit;

insert into Employee values(1,'Reeves','Keith','402-146-7714','4714 Countrywood Drive','68501',11060,'387-39-3938','29-Jan-2004',null,11,15,'Manager');
insert into Employee values (2,'Gibson','Bill','919-245-0526','7140 Blackjack Road','27842',9146,'151-23-1243','31-Mar-2004',null,1,12,'Manager');
insert into Employee values (3,'Reasoner','Katy','413-414-8275','7660 Trail East Drive','01101',8313,'623-46-2346','17-Feb-2004',null,1,11,'Manager');
insert into Employee values (4,'Hopkins','Alan','412-524-9814','3331 Union Road','15219',10641,'234-62-3463','8-Feb-2004',null,3,3,'Worker');
insert into Employee values (5,'James','Leisha','407-026-6653','6363 Springhill Avenue','32802',7083,'472-45-6456','6-Jan-2004',null,2,3,'Animal Friend');
insert into Employee values (6,'Eaton','Anissa','906-446-7957','9127 Jackson Avenue','49930',8676,'245-72-4564','23-Aug-2004',null,2,4,'Animal Friend');
insert into Employee values (7,'Farris','Dustin','615-891-5545','9145 Liberty Street','37202',10878,'946-54-5635','28-Mar-2004',null,2,3,'Animal Friend');
insert into Employee values (8,'Carpenter','Carlos','215-545-8897','4098 Locust Street','19104',10592,'247-24-5765','29-Dec-2004',null,3,7,'Worker');
insert into Employee values (9,'OConnor','Jessica','203-170-0146','6824 Longview Drive','06101',6731,'834-57-3457','23-Jul-2004',null,2,5,'Animal Friend');
insert into Employee values (10,'Shields','Howard','304-607-9081','315 Horseshoe Road','26003',11692,'245-74-5776','13-Jul-2004',null,2,4,'Animal Friend');
insert into Employee values (11,'Smith','Sally','860-333-9872','87 S. State Street','06101',6731,'111-33-5555','1-Jan-2004',null,0,30,'Owner');
commit;

insert into Category values ('Bird',null);
insert into Category values ('Cat','CFA');
insert into Category values ('Dog','AKC');
insert into Category values ('Fish',null);
insert into Category values ('Mammal','Misc');
insert into Category values ('Other','Unknown');
insert into Category values ('Reptile',null);
insert into Category values ('Spider',null);

insert into Breed values ('Bird','African Grey');
insert into Breed values ('Bird','Canary');
insert into Breed values ('Bird','Cockatiel');
insert into Breed values ('Bird','Lovebird');
insert into Breed values ('Bird','Other');
insert into Breed values ('Bird','Parakeet');
insert into Breed values ('Bird','Parrot');
insert into Breed values ('Cat','Abyssinian');
insert into Breed values ('Cat','American Shorthair');
insert into Breed values ('Cat','American Wirehair');
insert into Breed values ('Cat','Angora');
insert into Breed values ('Cat','Bombay');
insert into Breed values ('Cat','British Blue');
insert into Breed values ('Cat','Burmese');
insert into Breed values ('Cat','Canadian Hairless');
insert into Breed values ('Cat','Chartreux');
insert into Breed values ('Cat','Havana');
insert into Breed values ('Cat','Japanese Bobtail');
insert into Breed values ('Cat','Korat');
insert into Breed values ('Cat','Longhair');
insert into Breed values ('Cat','Maine Coon');
insert into Breed values ('Cat','Manx');
insert into Breed values ('Cat','Oriental Shorthair');
insert into Breed values ('Cat','Other');
insert into Breed values ('Cat','Persian');
insert into Breed values ('Cat','Russian Blue');
insert into Breed values ('Cat','Scottish Fold');
insert into Breed values ('Cat','Siamese');
insert into Breed values ('Cat','Snow-Shoe');
insert into Breed values ('Cat','Sphynx');
insert into Breed values ('Cat','Tonkinese');
insert into Breed values ('Dog','Afghan');
insert into Breed values ('Dog','Airedale');
insert into Breed values ('Dog','Akita');
insert into Breed values ('Dog','Alaskan Malamute');
insert into Breed values ('Dog','Australian Shepherd');
insert into Breed values ('Dog','Bassett Hound');
insert into Breed values ('Dog','Beagle');
insert into Breed values ('Dog','Bichon Frise');
insert into Breed values ('Dog','Bloodhound');
insert into Breed values ('Dog','Border Collie');
insert into Breed values ('Dog','Boston Terrier');
insert into Breed values ('Dog','Boxer');
insert into Breed values ('Dog','Bulldog');
insert into Breed values ('Dog','Cairn Terrier');
insert into Breed values ('Dog','Chihuahua');
insert into Breed values ('Dog','Chinese Shar Pei');
insert into Breed values ('Dog','Chow Chow');
insert into Breed values ('Dog','Cock A Poo');
insert into Breed values ('Dog','Cocker Spaniel');
insert into Breed values ('Dog','Collie');
insert into Breed values ('Dog','Coon Hound');
insert into Breed values ('Dog','Dachshund');
insert into Breed values ('Dog','Dalmation');
insert into Breed values ('Dog','Doberman');
insert into Breed values ('Dog','English Bulldog');
insert into Breed values ('Dog','German Shepherd');
insert into Breed values ('Dog','Golden Retriever');
insert into Breed values ('Dog','Great Dane');
insert into Breed values ('Dog','Great Pyrenees');
insert into Breed values ('Dog','Greyhound');
insert into Breed values ('Dog','Jack Russell Terrier');
insert into Breed values ('Dog','Keeshond');
insert into Breed values ('Dog','Labrador Retriever');
insert into Breed values ('Dog','Lhasa Apso');
insert into Breed values ('Dog','Maltese');
insert into Breed values ('Dog','Maltipoos');
insert into Breed values ('Dog','Mastiff');
insert into Breed values ('Dog','Minature Pinschers');
insert into Breed values ('Dog','Norfolk Terrier');
insert into Breed values ('Dog','Other');
insert into Breed values ('Dog','Pekingese');
insert into Breed values ('Dog','Pit Bull');
insert into Breed values ('Dog','Pointer');
insert into Breed values ('Dog','Pomeranian');
insert into Breed values ('Dog','Poodle');
insert into Breed values ('Dog','Poodle-Toy');
insert into Breed values ('Dog','Rottweiler');
insert into Breed values ('Dog','Schnauzer');
insert into Breed values ('Dog','Scottish Terrier');
insert into Breed values ('Dog','Shetland Sheepdog');
insert into Breed values ('Dog','Shihtzu');
insert into Breed values ('Dog','Siberian Huskie');
insert into Breed values ('Dog','St Bernard');
insert into Breed values ('Dog','Vizsla');
insert into Breed values ('Dog','Weimaraner');
insert into Breed values ('Dog','Wire Fox Terrier');
insert into Breed values ('Dog','Yorkshire Terrier');
insert into Breed values ('Fish','Angel');
insert into Breed values ('Fish','Guppy');
insert into Breed values ('Fish','Other');
insert into Breed values ('Fish','Shark');
insert into Breed values ('Fish','Snail');
insert into Breed values ('Fish','Starfish');
insert into Breed values ('Fish','Tetra');
insert into Breed values ('Mammal','Ferret');
insert into Breed values ('Mammal','Hamster');
insert into Breed values ('Other','Other');
insert into Breed values ('Reptile','Boa Constrictor');
insert into Breed values ('Reptile','Gila Monster');
insert into Breed values ('Reptile','Other');
insert into Breed values ('Reptile','Python');
insert into Breed values ('Spider','Other');
insert into Breed values ('Spider','Scorpion');
insert into Breed values ('Spider','Tarantula');

insert into Animal values(2,null,'Fish','Angel','5-May-2004','Male',null,'Black',12.00,null,null,null,null);
insert into Animal values(4,'Simon','Dog','Vizsla','2-Mar-2004','Male',null,'Red Brown',174.06,null,'Images/A000002.jpg',418,183);
insert into Animal values(5,null,'Fish','Shark','1-Jan-2004','Female',null,'Gray',22.00,null,null,null,null);
insert into Animal values(6,'Rosie','Cat','Oriental Shorthair','2-Aug-2004','Female','CFA','Gray',193.31,null,null,null,null);
insert into Animal values(7,'Eugene','Cat','Bombay','25-Jan-2004','Male','CFA','Black',279.54,null,null,null,null);
insert into Animal values(8,'Miranda','Dog','Norfolk Terrier','4-May-2004','Female','AKC','Red',203.75,null,null,null,null);
insert into Animal values(9,null,'Fish','Guppy','10-Mar-2004','Male',null,'Gold',2.00,null,null,null,null);
insert into Animal values(10,'Sherri','Dog','Siberian Huskie','13-Sep-2004','Female','AKC','Black/White',166.79,null,null,null,null);
insert into Animal values(11,'Susan','Dog','Dalmation','22-Jan-2004','Female','AKC','Spotted',164.96,null,null,null,null);
insert into Animal values(12,'Leisha','Dog','Rottweiler','13-Jun-2004','Female','AKC','Brown',164.06,null,null,null,null);
insert into Animal values(13,null,'Fish','Tetra','1-Mar-2004','Male',null,'Red',12.00,null,null,null,null);
insert into Animal values(14,'Tina','Cat','Sphynx','6-Jan-2004','Female','CFA','Gold',143.94,null,null,null,null);
insert into Animal values(15,'Bonita','Dog','Cocker Spaniel','21-Oct-2004','Female','AKC','Gold',284.85,null,null,null,null);
insert into Animal values(16,'Lisa','Dog','Great Pyrenees','5-Jan-2004','Female','AKC','Brown',274.35,null,null,null,null);
insert into Animal values(17,'Jackie','Dog','Doberman','12-Apr-2004','Male','AKC','Black',165.73,null,null,null,null);
insert into Animal values(18,'Allison','Cat','Manx','21-Apr-2004','Female','CFA','Black',215.92,null,null,null,null);
insert into Animal values(19,'Gene','Dog','Wire Fox Terrier','11-May-2004','Male','AKC','White',210.65,null,null,null,null);
insert into Animal values(20,'Buck','Cat','Bombay','30-Apr-2004','Male','CFA','Black',213.18,null,null,null,null);
insert into Animal values(21,'Debbie','Bird','Cockatiel','14-Jan-2004','Female',null,'Blue',177.88,null,null,null,null);
insert into Animal values(23,'Craig','Dog','Poodle','17-Mar-2004','Male','AKC','White',108.32,null,null,null,null);
insert into Animal values(24,'Carla','Cat','Maine Coon','11-Apr-2004','Female','CFA','Brown\Red',163.97,null,null,null,null);
insert into Animal values(25,'Vivian','Dog','Cocker Spaniel','24-Apr-2004','Female',null,'Red',128.18,null,null,null,null);
insert into Animal values(26,'Orville','Dog','Shetland Sheepdog','6-Jul-2004','Male','AKC','Gray',242.00,null,null,null,null);
insert into Animal values(27,null,'Reptile','Gila Monster','11-Mar-2004','Male',null,'Green',192.08,null,null,null,null);
insert into Animal values(28,null,'Spider','Tarantula','7-Feb-2004','Male',null,'Black',45.00,null,null,null,null);
insert into Animal values(29,null,'Fish','Snail','15-Jun-2004','Male',null,'White',15.00,null,null,null,null);
insert into Animal values(30,'Golda','Dog','Bloodhound','6-Jan-2004','Female','AKC','Brown',187.62,null,null,null,null);
insert into Animal values(31,'Taylor','Dog','Mastiff','15-Feb-2004','Male','AKC','Brown',164.70,null,null,null,null);
insert into Animal values(32,'Cathy','Cat','Scottish Fold','5-Jun-2004','Female','CFA','White',138.91,null,null,null,null);
insert into Animal values(33,'Kent','Dog','Poodle-Toy','30-May-2004','Male','AKC','Gray/Blue',122.36,null,null,null,null);
insert into Animal values(34,'Rhonda','Dog','Maltipoos','16-Jul-2004','Female','AKC','Gray',199.49,null,null,null,null);
insert into Animal values(35,'Charles','Bird','Parakeet','9-Apr-2004','Male',null,'Blue/Gold',203.10,null,null,null,null);
insert into Animal values(36,'Connie','Dog','Poodle-Toy','14-Oct-2004','Female','AKC','White',190.46,null,null,null,null);
insert into Animal values(37,'Hunter','Dog','Bassett Hound','4-May-2004','Male','AKC','Brown',115.39,null,null,null,null);
insert into Animal values(39,'Doris','Dog','Rottweiler','27-Mar-2004','Female','AKC','Red',211.28,null,null,null,null);
insert into Animal values(40,'Hunter','Dog','Weimaraner','2-Apr-2004','Male','AKC','Brown',214.82,null,null,null,null);
insert into Animal values(41,'Claudia','Dog','Boston Terrier','5-Jan-2004','Female','AKC','Black',179.92,null,null,null,null);
insert into Animal values(42,'Lloyd','Dog','Bassett Hound','19-May-2004','Male','AKC','Brown/Black',193.63,null,null,null,null);
insert into Animal values(43,'Chelsea','Reptile','Python','10-Feb-2004','Female',null,'Black/Gold',237.90,null,null,null,null);
insert into Animal values(44,'Melanie','Dog','Mastiff','18-Jun-2004','Female','AKC','Black',141.17,null,null,null,null);
insert into Animal values(45,'Bernard','Cat','American Shorthair','8-Aug-2004','Male','CFA','Gray',182.77,null,null,null,null);
insert into Animal values(46,'Lou Ann','Dog','Chinese Shar Pei','8-Jan-2004','Female',null,'Gold',254.85,null,null,null,null);
insert into Animal values(47,'Brian','Dog','Cock A Poo','3-Mar-2004','Male','AKC','Black',206.07,null,null,null,null);
insert into Animal values(48,'Anthony','Cat','Japanese Bobtail','16-Jun-2004','Male','CFA','White',226.54,null,null,null,null);
insert into Animal values(49,'Martha','Cat','Korat','16-Mar-2004','Female',null,'Gray/Blue',218.95,null,null,null,null);
insert into Animal values(50,'Arnold','Dog','Pomeranian','18-May-2004','Male','AKC','Gray/Blue',267.05,null,null,null,null);
insert into Animal values(51,'Kelly','Dog','Golden Retriever','16-Jan-2004','Male',null,'Gold',246.05,null,null,null,null);
insert into Animal values(52,'Buck','Dog','St Bernard','1-Jan-2004','Male','AKC','Brown/White',231.44,null,null,null,null);
insert into Animal values(53,null,'Fish','Starfish','23-Jun-2004','Female',null,'Blue',52.00,null,null,null,null);
insert into Animal values(54,'Sandy','Bird','Parrot','23-Jan-2004','Female',null,'Blue/Red',107.52,null,null,null,null);
insert into Animal values(55,'Alice','Dog','Cairn Terrier','3-Jan-2004','Female','AKC','Gray/Blue',204.72,null,null,null,null);
insert into Animal values(56,'Lillie','Cat','Abyssinian','3-Apr-2004','Female','CFA','White',227.39,null,null,null,null);
insert into Animal values(57,'Darcy','Dog','Akita','2-Jan-2004','Male','AKC','White/Black',237.10,null,null,null,null);
insert into Animal values(58,'Curtis','Bird','Parakeet','28-Apr-2004','Male',null,'Gold/Red',146.87,null,null,null,null);
insert into Animal values(59,'Gaylen','Dog','Dalmation','10-May-2004','Male','AKC','Spotted',199.52,null,null,null,null);
insert into Animal values(60,'Everett','Dog','Australian Shepherd','20-May-2004','Male','AKC','Brown/White',325.69,null,null,null,null);
insert into Animal values(61,'Sandy','Dog','Chinese Shar Pei','1-Jun-2004','Female',null,'Brown',221.55,null,null,null,null);
insert into Animal values(62,'Linda','Cat','Russian Blue','22-Aug-2004','Female','CFA','Gray/Blue',96.73,null,null,null,null);
insert into Animal values(63,'Sandy','Cat','Persian','19-Feb-2004','Female','CFA','White',191.27,null,null,null,null);
insert into Animal values(64,null,'Reptile','Python','11-Apr-2004','Female',null,'Black',255.25,null,null,null,null);
insert into Animal values(65,'Bryce','Cat','Persian','23-Jun-2004','Male','CFA','White/Black',133.24,null,null,null,null);
insert into Animal values(66,'Seth','Cat','Russian Blue','9-Jan-2004','Male','CFA','Gray/Blue',275.10,null,null,null,null);
insert into Animal values(67,'Ara','Cat','Manx','29-Jan-2004','Male','CFA','White',179.05,null,null,null,null);
insert into Animal values(68,'Hoyt','Bird','Parrot','28-Mar-2004','Male',null,'Blue/Red',235.27,null,null,null,null);
insert into Animal values(69,'Inez','Dog','Border Collie','24-Feb-2004','Female','AKC','Brown/White',104.88,null,null,null,null);
insert into Animal values(70,'Chris','Dog','Akita','8-Feb-2004','Male',null,'White/Black',206.57,null,null,null,null);
insert into Animal values(71,'Cora','Dog','Keeshond','2-Oct-2004','Female','AKC','Brown',119.67,null,null,null,null);
insert into Animal values(72,null,'Mammal','Hamster','27-Jun-2004','Male',null,'Brown/White',13.00,null,null,null,null);
insert into Animal values(73,'Janet','Dog','Coon Hound','24-Feb-2004','Female','AKC','Brown',123.65,null,null,null,null);
insert into Animal values(74,'Gina','Dog','Lhasa Apso','25-Jan-2004','Female','AKC','Brown/White',128.08,null,null,null,null);
insert into Animal values(75,'Ella','Dog','Chinese Shar Pei','8-Feb-2004','Female','AKC','Brown',131.83,null,null,null,null);
insert into Animal values(77,'Damon','Cat','Bombay','17-Jan-2004','Male','CFA','Black',178.16,null,null,null,null);
insert into Animal values(78,'Hunter','Dog','Great Dane','2-Jan-2004','Male','AKC','Brown',215.74,null,null,null,null);
insert into Animal values(79,null,'Bird','Cockatiel','26-Feb-2004','Male',null,'Brown/Blue',224.47,null,null,null,null);
insert into Animal values(80,'Oakley','Dog','Jack Russell Terrier','9-Aug-2004','Female','AKC','Brown/White',84.45,null,null,null,null);
insert into Animal values(81,null,'Bird','Canary','29-Jul-2004','Female',null,'Yellow',229.44,null,null,null,null);
insert into Animal values(82,null,'Mammal','Ferret','21-Jul-2004','Male',null,'Brown',125.00,null,null,null,null);
insert into Animal values(83,'Laura','Dog','Chihuahua','25-Jan-2004','Female','AKC','Brown',155.46,null,null,null,null);
insert into Animal values(84,'Patricia','Cat','Angora','26-Feb-2004','Female',null,'White',294.26,null,null,null,null);
insert into Animal values(85,'Dwight','Dog','Dachshund','3-Mar-2004','Male','AKC','Brown',178.64,null,null,null,null);
insert into Animal values(86,null,'Fish','Tetra','2-Jan-2004','Female',null,'Black',22.00,null,null,null,null);
insert into Animal values(87,'Christine','Dog','Norfolk Terrier','14-Aug-2004','Female','AKC','Red',208.12,null,null,null,null);
insert into Animal values(88,'Brandy','Dog','Cocker Spaniel','9-Jul-2004','Female','AKC','Brown',189.06,null,null,null,null);
insert into Animal values(89,'Ben','Dog','German Shepherd','10-Jan-2004','Male',null,'Black/White',153.94,null,null,null,null);
insert into Animal values(90,'Chad','Dog','Great Dane','15-Jun-2004','Male',null,'Black',223.97,null,null,null,null);
insert into Animal values(91,'Russell','Dog','Pit Bull','23-May-2004','Male','AKC','Brown',171.59,null,null,null,null);
insert into Animal values(92,'Terry','Bird','Lovebird','4-Feb-2004','Male',null,'White',180.16,null,null,null,null);
insert into Animal values(93,'Trina','Dog','Greyhound','5-Jan-2004','Female','AKC','Gray',143.07,null,null,null,null);
insert into Animal values(94,'Jean','Dog','Siberian Huskie','1-Jul-2004','Female','AKC','White/Brown',223.38,null,null,null,null);
insert into Animal values(95,'Ashley','Cat','Sphynx','25-Jan-2004','Female','CFA','White',183.48,null,null,null,null);
insert into Animal values(96,'Stan','Cat','Sphynx','1-Jan-2004','Male','CFA','Black',241.67,null,null,null,null);
insert into Animal values(97,'Ernest','Dog','Dachshund','21-Jan-2004','Male','AKC','Black',141.95,null,null,null,null);
insert into Animal values(98,'Ricardo','Dog','Bulldog','3-Feb-2004','Male','AKC','Black',177.20,null,null,null,null);
insert into Animal values(99,null,'Mammal','Ferret','27-Jul-2004','Male',null,'Black',230.89,null,null,null,null);
insert into Animal values(100,'Bill','Cat','Scottish Fold','6-Aug-2004','Male','CFA','Gray',132.79,null,null,null,null);
insert into Animal values(101,'Bessie','Dog','Australian Shepherd','3-Jan-2004','Female','AKC','White/Brown',216.10,null,null,null,null);
insert into Animal values(102,'Leonard','Dog','Mastiff','18-Sep-2004','Male','AKC','Brown',197.31,null,null,null,null);
insert into Animal values(103,'Lee','Cat','Siamese','17-Jul-2004','Male','CFA','White/Black',232.90,null,null,null,null);
insert into Animal values(104,'Julie','Cat','Longhair','18-Feb-2004','Female','CFA','Yellow',180.38,null,null,null,null);
insert into Animal values(105,'Beth','Dog','Akita','6-Feb-2004','Female','AKC','White/Brown',177.06,null,null,null,null);
insert into Animal values(106,'Taylor','Cat','Oriental Shorthair','21-Feb-2004','Male','CFA','Yellow/Black',220.94,null,null,null,null);
insert into Animal values(108,'Anissa','Dog','Bloodhound','4-Apr-2004','Female','AKC','Brown',169.13,null,null,null,null);
insert into Animal values(109,null,'Fish','Angel','5-Apr-2004','Female',null,'Yellow',128.22,null,null,null,null);
insert into Animal values(110,'Cathy','Bird','African Grey','5-Jul-2004','Female',null,'Gray/Red',192.77,null,null,null,null);
insert into Animal values(111,'Martin','Dog','Keeshond','8-Mar-2004','Male','AKC','Black',238.55,null,null,null,null);
insert into Animal values(112,'Elizabeth','Cat','Persian','15-Jan-2004','Female','CFA','Gray',145.33,null,null,null,null);
insert into Animal values(113,'Courtney','Dog','Boston Terrier','12-Mar-2004','Female','AKC','Black',142.61,null,null,null,null);
insert into Animal values(115,'Jewell','Cat','Korat','15-Jan-2004','Female','CFA','Black',210.88,null,null,null,null);
insert into Animal values(116,null,'Bird','Parrot','1-Jun-2004','Male',null,'Blue/Gold',133.01,null,null,null,null);
insert into Animal values(117,'Wallace','Cat','Other','9-Aug-2004','Male','CFA','Brown',50.00,null,null,null,null);
insert into Animal values(118,null,'Fish','Guppy','5-May-2004','Female',null,'Brown',4.00,null,null,null,null);
insert into Animal values(119,'DuJuan','Reptile','Boa Constrictor','26-Apr-2004','Male',null,'Brown/Gold',202.56,null,null,null,null);
insert into Animal values(120,'Chester','Dog','Keeshond','25-Feb-2004','Male','AKC','Black',216.91,null,null,null,null);
insert into Animal values(121,'Rachel','Dog','Norfolk Terrier','2-Aug-2004','Female','AKC','Gray',284.54,null,null,null,null);
insert into Animal values(122,'Gayle','Cat','Bombay','14-Feb-2004','Female','CFA','Black',282.84,null,null,null,null);
insert into Animal values(124,'Trina','Cat','Oriental Shorthair','25-May-2004','Female','CFA','Gray',187.70,null,null,null,null);
insert into Animal values(125,'Harlen','Dog','Cocker Spaniel','17-Mar-2004','Male','AKC','Yellow',193.08,null,null,null,null);
insert into Animal values(126,'Pierre','Cat','Maine Coon','11-Apr-2004','Male','CFA','Brown/Yellow',189.27,null,null,null,null);
insert into Animal values(127,'Beth','Cat','British Blue','9-Jan-2004','Female','CFA','Gray/Blue',195.72,null,null,null,null);
insert into Animal values(128,'Henry','Dog','German Shepherd','16-Jul-2004','Male','AKC','Black/White',155.95,null,null,null,null);
insert into Animal values(129,null,'Fish','Snail','2-Aug-2004','Male',null,'Yellow',16.00,null,null,null,null);
insert into Animal values(130,'Darrell','Dog','Greyhound','14-Jul-2004','Male','AKC','Gray',157.83,null,null,null,null);
insert into Animal values(131,'Elvis','Dog','Mastiff','11-Mar-2004','Male','AKC','Black',214.39,null,null,null,null);
insert into Animal values(132,'Dennis','Cat','Angora','13-Jul-2004','Male',null,'White',157.01,null,null,null,null);
insert into Animal values(133,'Anissa','Cat','Canadian Hairless','13-Jul-2004','Female','CFA','Gray',328.17,null,null,null,null);
insert into Animal values(134,null,'Reptile','Gila Monster','8-Feb-2004','Male',null,'Brown',182.36,null,null,null,null);
insert into Animal values(135,null,'Mammal','Ferret','24-Jul-2004','Female',null,'Brown',125.23,null,null,null,null);
insert into Animal values(136,null,'Bird','Other','11-Aug-2004','Male',null,'White',206.77,null,null,null,null);
insert into Animal values(137,null,'Fish','Shark','24-Jan-2004','Female',null,'Gray',238.52,null,null,null,null);
insert into Animal values(138,'Owen','Cat','Japanese Bobtail','21-May-2004','Male','CFA','White',232.46,null,null,null,null);
insert into Animal values(139,'Claudia','Dog','Doberman','2-Aug-2004','Female','AKC','Black',220.97,null,null,null,null);
insert into Animal values(140,'Cal','Cat','Persian','21-Jul-2004','Male','CFA','White',134.80,null,null,null,null);
insert into Animal values(141,'MaryJo','Dog','Pit Bull','22-Jun-2004','Female','AKC','Brown',234.51,null,null,null,null);
insert into Animal values(142,'Susan','Dog','Siberian Huskie','3-Aug-2004','Female','AKC','White',180.93,null,null,null,null);
insert into Animal values(143,'Leisha','Cat','Korat','20-May-2004','Female','CFA','Brown',163.07,null,null,null,null);
insert into Animal values(144,'Dewey','Dog','Poodle-Toy','7-May-2004','Male','AKC','Black',182.60,null,null,null,null);
insert into Animal values(145,'Ruby','Dog','Weimaraner','23-Mar-2004','Female','AKC','Brown',201.85,null,null,null,null);
insert into Animal values(146,'Kevin','Cat','Siamese','24-Mar-2004','Male','CFA','White',93.07,null,null,null,null);
insert into Animal values(147,'Kelly','Dog','Alaskan Malamute','25-Mar-2004','Male','AKC','White',272.52,null,null,null,null);
insert into Animal values(148,'Wayne','Dog','Akita','9-Feb-2004','Male','AKC','White',257.89,null,null,null,null);
insert into Animal values(149,'Elizabeth','Cat','Tonkinese','6-Jun-2004','Female','CFA','Yellow',138.82,null,null,null,null);
insert into Animal values(150,'Brian','Dog','Norfolk Terrier','3-Jan-2004','Male','AKC','Yellow',168.80,null,null,null,null);
insert into Animal values(151,'Lester','Bird','Parrot','9-Apr-2004','Male',null,'Red',244.19,null,null,null,null);
insert into Animal values(152,'Heather','Dog','Collie','3-Jun-2004','Female','AKC','Brown/Yellow',218.83,null,null,null,null);
insert into Animal values(153,'Owen','Cat','Manx','28-Jun-2004','Male',null,'Yellow',234.54,null,null,null,null);
insert into Animal values(154,'Orville','Dog','English Bulldog','15-Apr-2004','Male','AKC','Yellow',197.01,null,null,null,null);
insert into Animal values(155,'Stephen','Cat','Siamese','28-Feb-2004','Male',null,'White',222.93,null,null,null,null);
insert into Animal values(156,'Alvin','Dog','Collie','21-Jan-2004','Male','AKC','Yellow',280.59,null,null,null,null);
insert into Animal values(157,null,'Bird','Parrot','12-Apr-2004','Male',null,'Red',237.81,null,null,null,null);
insert into Animal values(158,'Russell','Dog','Shetland Sheepdog','20-Mar-2004','Male','AKC','White/Brown',167.16,null,null,null,null);
insert into Animal values(159,null,'Reptile','Python','13-Jan-2004','Male',null,'Black',141.98,null,null,null,null);
insert into Animal values(160,'Rufus','Dog','Cocker Spaniel','2-Jan-2004','Male','AKC','Yellow',176.79,null,null,null,null);
insert into Animal values(161,'Bernard','Dog','Keeshond','11-May-2004','Male',null,'Red',244.90,null,null,null,null);
insert into Animal values(162,'Basil','Cat','Japanese Bobtail','8-May-2004','Male','CFA','Red',133.19,null,null,null,null);
insert into Animal values(163,'Bruce','Dog','Jack Russell Terrier','20-Sep-2004','Male','AKC','Brown/White',261.02,null,null,null,null);
insert into Animal values(164,'Ruby','Bird','Parakeet','19-Jan-2004','Female',null,'Red',253.43,null,null,null,null);
insert into Animal values(165,'Julie','Dog','Dalmation','28-Aug-2004','Female','AKC','Spotted',172.37,null,null,null,null);
insert into Animal values(166,'Katy','Cat','Japanese Bobtail','25-Mar-2004','Female','CFA','Yellow',163.72,null,null,null,null);
insert into Animal values(168,'Ray','Cat','Japanese Bobtail','4-Jun-2004','Male','CFA','Black',225.68,null,null,null,null);
insert into Animal values(169,'Lorene','Dog','Coon Hound','11-Sep-2004','Female',null,'Yellow',132.48,null,null,null,null);
insert into Animal values(170,'Sarah','Dog','Poodle','15-Mar-2004','Female','AKC','White',250.81,null,null,null,null);
insert into Animal values(171,'Glen','Dog','Chihuahua','18-Apr-2004','Male','AKC','Yellow',232.26,null,null,null,null);
insert into Animal values(172,'Jackie','Dog','Boston Terrier','13-Aug-2004','Female','AKC','Gray',242.28,null,null,null,null);
insert into Animal values(173,null,'Mammal','Hamster','6-Jun-2004','Female',null,'Yellow',22.00,null,null,null,null);
insert into Animal values(174,'Lisa','Dog','Doberman','24-Feb-2004','Female','AKC','Brown',184.95,null,null,null,null);
insert into Animal values(175,'Donald','Cat','Canadian Hairless','9-Jul-2004','Male','CFA','Brown',193.14,null,null,null,null);
insert into Animal values(176,'DuJuan','Dog','Coon Hound','14-May-2004','Male','AKC','Brown',295.28,null,null,null,null);
insert into Animal values(177,'Jennifer','Dog','Siberian Huskie','23-Apr-2004','Female','AKC','White',205.75,null,null,null,null);
insert into Animal values(178,'Leisha','Dog','Scottish Terrier','26-May-2004','Female','AKC','Gray',164.63,null,null,null,null);
insert into Animal values(179,'Cassy','Dog','Keeshond','5-Jan-2004','Female','AKC','Red',139.61,null,null,null,null);
insert into Animal values(180,null,'Fish','Angel','1-Apr-2004','Female',null,'Yellow',27.00,null,null,null,null);
insert into Animal values(181,null,'Fish','Tetra','16-Jun-2004','Male',null,'Brown/Red',23.00,null,null,null,null);
insert into Animal values(182,'Duane','Dog','Rottweiler','28-May-2004','Male','AKC','Red',218.49,null,null,null,null);
insert into Animal values(183,null,'Spider','Scorpion','2-Feb-2004','Male',null,'Black',127.00,null,null,null,null);
insert into Animal values(184,null,'Fish','Tetra','21-May-2004','Male',null,'Black/Blue',25.00,null,null,null,null);
insert into Animal values(185,'Ricardo','Dog','Airedale','21-Jun-2004','Male','AKC','Gray',164.14,null,null,null,null);
insert into Animal values(186,'Francis','Dog','Chinese Shar Pei','29-Jan-2004','Female','AKC','Brown',240.40,null,null,null,null);
insert into Animal values(187,'Martha','Dog','Poodle','15-May-2004','Female',null,'White',133.65,null,null,null,null);
insert into Animal values(188,'Angela','Dog','Chow Chow','26-Jun-2004','Female','AKC','Yellow',234.97,null,null,null,null);
insert into Animal values(189,'Emma','Bird','Parrot','6-Sep-2004','Female',null,'Yellow',170.08,null,null,null,null);
insert into Animal values(190,'Wendell','Dog','Minature Pinschers','30-Mar-2004','Male','AKC','Red',163.60,null,null,null,null);
insert into Animal values(191,'Cassy','Dog','Collie','13-Feb-2004','Female','AKC','Brown/White',233.43,null,null,null,null);
insert into Animal values(192,'Sally','Cat','American Shorthair','26-Jun-2004','Female','CFA','Black',196.87,null,null,null,null);
insert into Animal values(193,'Kevin','Cat','Sphynx','20-Sep-2004','Male','CFA','Yellow',240.05,null,null,null,null);
insert into Animal values(195,'Tom','Dog','Dalmation','5-Jun-2004','Male','AKC','Spotted',195.52,null,null,null,null);
insert into Animal values(196,'Buck','Dog','Doberman','5-Jun-2004','Male',null,'Black',253.54,null,null,null,null);
insert into Animal values(197,null,'Spider','Tarantula','10-Jun-2004','Female',null,'Black',221.85,null,null,null,null);
insert into Animal values(198,'Curtis','Dog','Maltese','4-Jan-2004','Male','AKC','Black',142.67,null,null,null,null);
insert into Animal values(199,'Herbert','Cat','Abyssinian','23-Jan-2004','Male','CFA','White',163.73,null,null,null,null);
insert into Animal values(200,'Brandy','Dog','Mastiff','1-Aug-2004','Female','AKC','Brown',120.36,null,null,null,null);
insert into Animal values(201,null,'Mammal','Hamster','22-Feb-2004','Male',null,'Brown',22.00,null,null,null,null);

insert into Merchandise values (1,'Dog Kennel-Small',11,45.00,'Dog');
insert into Merchandise values (2,'Dog Kennel-Medium',12,65.00,'Dog');
insert into Merchandise values (3,'Dog Kennel-Large',13,85.00,'Dog');
insert into Merchandise values (4,'Dog Kennel-Extra Large',6,110.00,'Dog');
insert into Merchandise values (5,'Cat Bed-Small',36,25.00,'Cat');
insert into Merchandise values (6,'Cat Bed-Medium',35,35.00,'Cat');
insert into Merchandise values (7,'Dog Toy',134,4.00,'Dog');
insert into Merchandise values (8,'Cat Toy',182,3.00,'Cat');
insert into Merchandise values (9,'Dog Food-Dry-10 pound',211,7.50,'Dog');
insert into Merchandise values (10,'Dog Food-Dry-25 pound',100,16.00,'Dog');
insert into Merchandise values (11,'Dog Food-Dry-50 pound',373,30.00,'Dog');
insert into Merchandise values (12,'Cat Food-Dry-5 pound',413,7.00,'Cat');
insert into Merchandise values (13,'Cat Food-Dry-10 pound',224,10.00,'Cat');
insert into Merchandise values (14,'Cat Food-Dry-25 pound',300,18.00,'Cat');
insert into Merchandise values (15,'Dog Food-Can-Regular',452,0.40,'Dog');
insert into Merchandise values (16,'Dog Food-Can-Premium',1179,0.80,'Dog');
insert into Merchandise values (17,'Cat Food-Can-Regular',7470,0.50,'Cat');
insert into Merchandise values (18,'Cat Food-Can-Premium',1874,1.00,'Cat');
insert into Merchandise values (19,'Cat Litter-10 pound',128,8.00,'Cat');
insert into Merchandise values (20,'Wood Shavings/Bedding',141,10.00,'Mammal');
insert into Merchandise values (21,'Bird Cage-Medium',5,25.00,'Bird');
insert into Merchandise values (22,'Bird Cage-Large',15,75.00,'Bird');
insert into Merchandise values (23,'Aquarium-25 gal',28,75.00,'Fish');
insert into Merchandise values (24,'Aquarium-100 gal',11,150.00,'Fish');
insert into Merchandise values (25,'Fish Food',113,3.00,'Fish');
insert into Merchandise values (26,'Aquarium Decoration',48,6.00,'Fish');
insert into Merchandise values (27,'Aquarium Filter + Pump',18,35.00,'Fish');
insert into Merchandise values (28,'Aquarium Light',65,25.00,'Fish');
insert into Merchandise values (29,'Flea Collar-Cat',240,6.00,'Cat');
insert into Merchandise values (30,'Flea Collar-Dog-Medium',429,7.00,'Dog');
insert into Merchandise values (31,'Flea Collar-Dog-Large',1018,8.50,'Dog');
insert into Merchandise values (32,'Collar-Dog-Small',47,12.00,'Dog');
insert into Merchandise values (33,'Collar-Dog-Medium',92,15.00,'Dog');
insert into Merchandise values (34,'Collar-Dog-Large',132,20.00,'Dog');
insert into Merchandise values (35,'Collar-Cat',150,8.00,'Cat');
insert into Merchandise values (36,'Leash',172,22.00,'Dog');
insert into Merchandise values (37,'Brush-Stiff',34,8.00,'Dog');
insert into Merchandise values (38,'Brush-Soft',50,8.00,'Cat');
insert into Merchandise values (39,'Litter Box',131,8.00,'Cat');
insert into Merchandise values (40,'Litter Box-Covered',20,15.00,'Cat');
commit;

insert into Customer values(1,null,'Walkin','Walkin',null,null,0);
insert into Customer values(2,'(808) 801-9830','Brent','Cummings','9197 Hatchet Drive','96815',7347);
insert into Customer values(3,'(617) 843-6488','Dwight','Logan','1760 Clearview Street','02109',8133);
insert into Customer values(4,'(502) 007-0907','Shatika','Gilbert','4407 Green Street','40342',7963);
insert into Customer values(5,'(701) 384-5623','Charlotte','Anderson','4333 Highland Court','58102',9175);
insert into Customer values(6,'(606) 740-3304','Searoba','Hopkins','3183 Highland Court','40330',7955);
insert into Customer values(7,'(408) 104-9807','Anita','Robinson','8177 Horse Park Lane','95035',6366);
insert into Customer values(8,'(606) 688-8141','Cora','Reid','8351 Locust Street','41073',7925);
insert into Customer values(9,'(702) 533-3419','Elwood','Henson','4042 West Ridge Drive','89125',9636);
insert into Customer values(10,'(302) 701-7398','Kaye','Maynard','5095 Sugar Grove Road','19901',6829);
insert into Customer values(11,'(502) 444-1587','Lee','Gentry','5744 High Street','40342',7963);
insert into Customer values(12,'(608) 006-2256','Chris','Haley','6087 Spring Street','54601',11596);
insert into Customer values(13,'(304) 477-6629','Jolene','Garrison','1830 Glenview Drive','26261',11673);
insert into Customer values(14,'(614) 721-2870','Beth','Patterson','3688 Long Hollow Pike','43216',10031);
insert into Customer values(15,'(409) 116-3589','Connie','Fisher','4491 Evergreen Circle','77550',11013);
insert into Customer values(16,'(502) 863-3037','Rosie','Wade','7661 Trident Place','42240',7960);
insert into Customer values(17,'(606) 634-7076','Carly','Embry','2869 Sanders Ferry Road','40383',8000);
insert into Customer values(18,'(414) 331-5679','David','Lawrence','9326 Halltown Road','53916',11559);
insert into Customer values(19,'(505) 825-4065','Lisa','Zhang','477 Rolling Acres Drive','87501',9616);
insert into Customer values(20,'(207) 585-7583','Reva','Kidd','5594 Halltown Road','04401',8525);
insert into Customer values(21,'(615) 646-9874','Sarah','Mills','8904 Horseshoe Road','37167',10893);
insert into Customer values(22,'(706) 977-4337','Inga','Adkins','8831 Cardinal Lane','30720',7244);
insert into Customer values(23,'(606) 084-6983','Jerome','Cummings','2501 Club Circle','41101',8002);
insert into Customer values(24,'(615) 969-8901','Floyd','Young','969 Windsor Park Lane','37130',10877);
insert into Customer values(25,'(502) 863-8898','Gaylen','Wilson','1221 Johnson Drive','40229',7959);
insert into Customer values(26,'(606) 691-9745','Trina','Howe','2821 35th Street','40701',7932);
insert into Customer values(27,'(608) 825-3740','Archie','Mitchell','1326 Cedar Avenue','53590',11647);
insert into Customer values(28,'(408) 575-7000','Gina','Samuels','2026 Homewood Blvd.','95035',6366);
insert into Customer values(29,'(802) 078-4749','Kelly','Moore','6116 Clearview Street','05753',11393);
insert into Customer values(30,'(919) 014-7544','Rodney','Edmunds','5560 Greenfield Lane','27514',9090);
insert into Customer values(31,'(313) 260-7386','Nancy','Froedge','1399 Williamsburg Drive','48152',8688);
insert into Customer values(32,'(619) 281-2485','Searoba','Allbright','5260 College Street','92109',6175);
insert into Customer values(33,'(314) 510-5228','Colleen','Latham','2864 Dolhous Drive','63366',8962);
insert into Customer values(34,'(414) 168-2952','Cathy','Hampton','7295 Hazel Path','53203',11610);
insert into Customer values(35,'(406) 987-9338','Kimberly','Adams','5064 Pleasant Valley Drive','59901',9069);
insert into Customer values(36,'(501) 071-2650','Lloyd','Holland','9011 Bayshore Drive','72201',5984);
insert into Customer values(37,'(517) 039-8300','Fannie','McPherson','4184 Tick Ridge Road','48924',8665);
insert into Customer values(38,'(307) 477-8112','Jay','Franklin','9105 Ridge Top Road','82070',11701);
insert into Customer values(39,'(304) 352-8602','Dorothy','Williams','9286 Jackson Avenue','25550',11689);
insert into Customer values(40,'(612) 089-0074','Darrell','Oberhausen','9556 Cumberland Hills Drive','55101',8864);
insert into Customer values(41,'(502) 691-7565','Melinda','Craig','9217 Blue Lake Way','40218',7979);
insert into Customer values(42,'(615) 041-1934','Jackie','Froedge','243 West Ridge Drive','37027',10819);
insert into Customer values(43,'(517) 057-3491','Jasper','Killen','4869 Sequoia Lane','48924',8665);
insert into Customer values(44,'(412) 933-3710','Dale','Hammer','9707 Elm Hill Circle','15106',10617);
insert into Customer values(45,'(606) 372-0229','Shirley','Gregory','8982 Circle Drive','40356',7981);
insert into Customer values(46,'(201) 654-2441','Cassy','Tuck','7977 Fairways Drive','07015',9322);
insert into Customer values(47,'(804) 020-5842','Bernice','Carver','8170 Roberts Road','23320',11276);
insert into Customer values(48,'(508) 201-2483','Dwight','Parrish','9904 Plum Springs Road','01613',8363);
insert into Customer values(49,'(210) 851-7566','Wallace','Galloway','4358 Cherokee Road','78284',11067);
insert into Customer values(50,'(704) 979-1610','Lenny','Lee','9940 Girkin Road','28204',9091);
insert into Customer values(51,'(715) 483-7737','Clyde','Jernigan','5325 Cherry Street','54022',11636);
insert into Customer values(52,'(919) 289-1383','Gladys','Pendleton','1805 Sunset Place','27611',9144);
insert into Customer values(53,'(414) 331-5679','David','Lawrence','9326 Halltown Road','53916',11559);
insert into Customer values(54,'(502) 971-2715','Mark','Green','8968 Camino Circle','40291',7943);
insert into Customer values(55,'(606) 375-0721','Wendell','Thomas','8963 Pine Branch Trace','40330',7955);
insert into Customer values(56,'(507) 437-0059','Sidney','Hughes','4386 Sherwood Lane','56007',8771);
insert into Customer values(57,'(219) 263-2040','Phillip','Carter','20 Green Street','27514',9090);
insert into Customer values(58,'(703) 543-0176','Sam','McCain','445 Industrial Drive','22101',11368);
insert into Customer values(59,'(360) 917-7520','Cindy','Rhodes','7425 Virginia Street','98501',11533);
insert into Customer values(60,'(502) 029-3909','Lou Ann','Baez','2528 Hot Springs Avenue','42718',7930);
insert into Customer values(61,'(304) 416-1309','Marvin','McDonald','8045 Lovers Lane','25301',11671);
insert into Customer values(62,'(913) 496-1897','Phyllis','Tuck','2150 Volunteer Drive','66502',7901);
insert into Customer values(63,'(301) 485-6261','Earl','Grimes','6485 Pepper Street','21701',8426);
insert into Customer values(64,'(502) 135-7679','Conrad','Fowler','8114 Cherry Street','42420',7957);
insert into Customer values(65,'(817) 528-7955','Linda','Riggs','593 White Oak Court','76101',11189);
insert into Customer values(66,'(606) 683-4113','Adrian','Greer','6597 Skyline Drive','40422',7935);
insert into Customer values(67,'(414) 715-7191','Floyd','Kennedy','3566 Elementary Drive','54305',11557);
insert into Customer values(68,'(901) 312-1555','Ella','Kidd','3626 Webster Road','38101',10871);
insert into Customer values(69,'(919) 205-8147','Mandy','Elliott','4839 Long Hollow Pike','27514',9090);
insert into Customer values(70,'(313) 438-8733','Jerry','Poe','5879 Dixie Way','48233',8628);
insert into Customer values(71,'(702) 867-1893','Herman','Moseley','4461 Southern Drive','89114',9628);
insert into Customer values(72,'(360) 649-9754','Gayle','Bailey','8233 Whisper Woods Road','98201',11522);
insert into Customer values(73,'(603) 075-7437','Hershel','Keen','8124 Industrial Drive','03060',9261);
insert into Customer values(74,'(606) 241-3182','Frieda','Hinton','9015 Cherokee Road','41042',7945);
insert into Customer values(75,'(802) 433-5007','Sharon','Sexton','2551 Elementary Drive','05641',11382);
insert into Customer values(76,'(304) 062-1621','Evelyn','Montgomery','6386 Main Street','25550',11689);
insert into Customer values(77,'(520) 520-8733','Bart','Gillespie','3422 Breeder Road','85726',6067);
insert into Customer values(78,'(505) 646-2748','Elaine','Hall','1790 Cedar Avenue','88310',9586);
insert into Customer values(79,'(317) 995-8449','Darcy','Pitts','523 Shoreside Drive','46206',7808);
insert into Customer values(80,'(515) 846-5222','Juanita','Vance','8916 High Street','50010',7378);
insert into Customer values(81,'(606) 661-2765','Bessie','Baez','7313 Humble Avenue','41031',7934);
insert into Customer values(82,'(307) 448-5424','Basil','Davidson','9102 Rocky Mound Road','82071',11701);
insert into Customer values(83,'(414) 334-8130','Ada','Jones','4590 Tobacco Road','54956',11614);
insert into Customer values(84,'(617) 467-3438','David','Sims','6623 Glenview Drive','02116',8133);
insert into Customer values(85,'(502) 595-1052','Glen','Cartwright','448 Sanders Ferry Road','42001',7984);
insert into Customer values(86,'(618) 109-9250','Bert','Hooks','9801 Hatchet Drive','62269',7661);
insert into Customer values(87,'(606) 793-3172','Lucille','Cummings','1209 Center Point Road','40391',8004);
insert into Customer values(88,'(703) 611-2557','Christa','Mallory','6370 N. Main Street','22101',11368);
insert into Customer values(89,'(308) 873-1375','Kaye','Foster','520 Pace Street','68847',9198);
insert into Customer values(90,'(408) 427-2162','Connie','Nichols','4039 Greensburg Street','95035',6366);
insert into Customer values(91,'(502) 882-7631','Conrad','Ferguson','6300 Dorcas Drive','40207',7993);
insert into Customer values(92,'(608) 481-3369','Tim','Zeller','9682 Ridge Top Road','53701',11575);
insert into Customer values(93,'(314) 242-5743','Floyd','Dye','7730 Crosby Drive','63155',8898);
insert into Customer values(94,'(802) 458-4329','Dan','Kennedy','3108 Troon Court','05401',11402);
insert into Customer values(95,'(715) 140-4710','Clarence','Kinser','6964 Poplar Ridge Road','54701',11572);
insert into Customer values(96,'(913) 344-4761','Inez','Maynard','3832 College Street','66502',7901);
insert into Customer values(97,'(715) 623-0861','Adam','Rich','2759 Peterson Avenue','54401',11657);
insert into Customer values(98,'(701) 691-3002','Wilmer','Pardue','1790 N. Main Street','58102',9175);
insert into Customer values(99,'(717) 244-3484','Luther','Bell','5703 Cave Springs Road','17325',10493);
insert into Customer values(100,'(606) 326-9807','Reva','Killen','5442 Halltown Road','41056',7971);
commit;

insert into AnimalOrder values (1,'11-Jun-2004','23-Jun-2004',4,32.06,5);
insert into AnimalOrder values (2,'30-Jan-2004','31-Aug-2004',2,50.81,1);
insert into AnimalOrder values (3,'7-Mar-2004','1-Aug-2004',4,42.37,3);
insert into AnimalOrder values (4,'6-Mar-2004','26-Oct-2004',9,62.20,8);
insert into AnimalOrder values (5,'21-Apr-2004','28-Apr-2004',5,68.24,3);
insert into AnimalOrder values (6,'11-Jan-2004','3-May-2004',7,43.27,4);
insert into AnimalOrder values (7,'6-Apr-2004','1-May-2004',11,51.03,9);
insert into AnimalOrder values (8,'22-Feb-2004','17-Mar-2004',7,62.90,4);
insert into AnimalOrder values (9,'15-Jan-2004','14-Mar-2004',3,46.19,9);
insert into AnimalOrder values (10,'17-Feb-2004','24-Sep-2004',8,63.26,7);
insert into AnimalOrder values (11,'25-Feb-2004','16-Jul-2004',2,47.45,7);
insert into AnimalOrder values (12,'13-Jan-2004','18-Feb-2004',11,52.36,6);
insert into AnimalOrder values (13,'27-Feb-2004','17-Mar-2004',12,45.75,5);
insert into AnimalOrder values (14,'3-Apr-2004','16-Aug-2004',3,52.07,9);
insert into AnimalOrder values (15,'30-Jan-2004','19-Jun-2004',7,61.46,5);
insert into AnimalOrder values (16,'2-Feb-2004','26-Feb-2004',6,51.55,5);
insert into AnimalOrder values (17,'8-Apr-2004','19-Oct-2004',2,52.62,2);
insert into AnimalOrder values (18,'19-May-2004','5-Sep-2004',5,40.65,5);
insert into AnimalOrder values (19,'19-Mar-2004','24-Mar-2004',9,49.20,3);
insert into AnimalOrder values (20,'17-Feb-2004','25-Feb-2004',9,55.28,7);
insert into AnimalOrder values (21,'29-Jan-2004','3-Oct-2004',4,49.07,2);
insert into AnimalOrder values (22,'10-Apr-2004','3-Jul-2004',2,48.07,3);
insert into AnimalOrder values (23,'20-Jan-2004','4-Mar-2004',7,45.14,5);
insert into AnimalOrder values (24,'22-Apr-2004','16-Jul-2004',6,60.20,5);
insert into AnimalOrder values (25,'4-Jan-2004','30-Jun-2004',12,40.57,3);
insert into AnimalOrder values (26,'10-May-2004','11-May-2004',1,40.35,6);
insert into AnimalOrder values (27,'10-Jan-2004','27-Jul-2004',4,53.22,5);
insert into AnimalOrder values (28,'22-Jan-2004','20-Feb-2004',3,54.09,3);
insert into AnimalOrder values (29,'27-Jan-2004','30-Oct-2004',9,50.49,3);
insert into AnimalOrder values (30,'28-Jan-2004','22-Apr-2004',3,61.02,3);
insert into AnimalOrder values (31,'18-Feb-2004','4-Jul-2004',2,47.67,9);
insert into AnimalOrder values (32,'8-Feb-2004','24-Jul-2004',3,57.44,8);
insert into AnimalOrder values (33,'23-Jan-2004','29-Apr-2004',11,53.73,2);
insert into AnimalOrder values (34,'2-May-2004','8-May-2004',7,46.35,9);
insert into AnimalOrder values (35,'1-Mar-2004','11-Jul-2004',5,47.47,5);
insert into AnimalOrder values (36,'21-Jan-2004','16-Mar-2004',8,40.73,7);
insert into AnimalOrder values (37,'3-Jul-2004','18-Sep-2004',3,38.64,4);
insert into AnimalOrder values (38,'16-Feb-2004','20-Feb-2004',3,62.10,8);
insert into AnimalOrder values (39,'5-Feb-2004','31-Mar-2004',4,44.33,8);
insert into AnimalOrder values (40,'15-Feb-2004','16-Jun-2004',7,61.22,5);
insert into AnimalOrder values (41,'10-Feb-2004','2-May-2004',7,44.98,4);
insert into AnimalOrder values (42,'14-Feb-2004','16-Apr-2004',8,46.39,3);
insert into AnimalOrder values (43,'23-Feb-2004','22-Aug-2004',4,39.34,6);
insert into AnimalOrder values (44,'21-Feb-2004','13-May-2004',6,56.22,1);
insert into AnimalOrder values (45,'14-Mar-2004','28-Apr-2004',9,61.06,4);
insert into AnimalOrder values (46,'10-Feb-2004','6-Oct-2004',7,60.87,1);
insert into AnimalOrder values (47,'4-Jan-2004','28-Jun-2004',6,39.68,2);
insert into AnimalOrder values (48,'9-Apr-2004','10-Sep-2004',1,54.86,3);
insert into AnimalOrder values (49,'11-Jul-2004','15-Jul-2004',5,53.88,2);
insert into AnimalOrder values (50,'12-Feb-2004','17-Feb-2004',3,48.16,3);
commit;

insert into MerchandiseOrder values (1,'6-Mar-2004','8-Mar-2004',10,4,33.54);
insert into MerchandiseOrder values (2,'28-May-2004','4-Jun-2004',11,3,28.64);
insert into MerchandiseOrder values (3,'19-Aug-2004','22-Aug-2004',15,4,39.02);
insert into MerchandiseOrder values (4,'18-Apr-2004','30-Apr-2004',14,5,42.08);
insert into MerchandiseOrder values (5,'18-Aug-2004','25-Aug-2004',10,8,32.33);
insert into MerchandiseOrder values (6,'22-Apr-2004','29-Apr-2004',13,9,21.87);
insert into MerchandiseOrder values (7,'7-Jun-2004','18-Jun-2004',14,7,14.22);
insert into MerchandiseOrder values (8,'1-Jul-2004','3-Jul-2004',11,1,39.30);
insert into MerchandiseOrder values (9,'27-Apr-2004','3-May-2004',11,3,33.89);
insert into MerchandiseOrder values (10,'4-May-2004','8-May-2004',13,3,31.04);
insert into MerchandiseOrder values (11,'18-Jun-2004','22-Jun-2004',11,5,25.38);
insert into MerchandiseOrder values (12,'6-Oct-2004','7-Oct-2004',13,8,33.76);
insert into MerchandiseOrder values (13,'6-Oct-2004','9-Oct-2004',12,7,40.39);
insert into MerchandiseOrder values (14,'20-May-2004','22-May-2004',12,5,29.27);
insert into MerchandiseOrder values (15,'30-Sep-2004','4-Oct-2004',10,9,37.98);
insert into MerchandiseOrder values (16,'27-Feb-2004','4-Mar-2004',12,5,32.42);
insert into MerchandiseOrder values (17,'9-Aug-2004','15-Aug-2004',14,7,42.25);
insert into MerchandiseOrder values (18,'27-Mar-2004','4-Apr-2004',14,5,60.13);
insert into MerchandiseOrder values (19,'4-Feb-2004','6-Feb-2004',14,2,29.94);
insert into MerchandiseOrder values (20,'11-Aug-2004','16-Aug-2004',13,8,21.68);
insert into MerchandiseOrder values (21,'29-Jun-2004','30-Jun-2004',15,8,46.91);
insert into MerchandiseOrder values (22,'25-Feb-2004',null,12,5,32.55);
insert into MerchandiseOrder values (23,'19-Sep-2004','22-Sep-2004',13,3,43.64);
insert into MerchandiseOrder values (24,'27-Oct-2004','29-Oct-2004',11,9,18.69);
insert into MerchandiseOrder values (25,'31-Aug-2004','15-Sep-2004',11,6,28.35);

insert into AnimalOrderItem values (1,59,131.46);
insert into AnimalOrderItem values (2,27,34.25);
insert into AnimalOrderItem values (2,30,74.65);
insert into AnimalOrderItem values (2,79,153.74);
insert into AnimalOrderItem values (2,126,51.01);
insert into AnimalOrderItem values (2,171,127.91);
insert into AnimalOrderItem values (2,200,89.52);
insert into AnimalOrderItem values (3,69,60.83);
insert into AnimalOrderItem values (3,125,77.04);
insert into AnimalOrderItem values (3,173,9.73);
insert into AnimalOrderItem values (3,192,63.00);
insert into AnimalOrderItem values (4,47,95.99);
insert into AnimalOrderItem values (4,120,202.62);
insert into AnimalOrderItem values (4,132,73.07);
insert into AnimalOrderItem values (4,152,143.29);
insert into AnimalOrderItem values (4,154,119.90);
insert into AnimalOrderItem values (4,163,216.65);
insert into AnimalOrderItem values (5,68,66.28);
insert into AnimalOrderItem values (6,16,123.84);
insert into AnimalOrderItem values (6,58,110.20);
insert into AnimalOrderItem values (6,67,139.09);
insert into AnimalOrderItem values (6,104,69.56);
insert into AnimalOrderItem values (6,146,35.81);
insert into AnimalOrderItem values (7,10,138.44);
insert into AnimalOrderItem values (7,145,67.18);
insert into AnimalOrderItem values (8,25,14.28);
insert into AnimalOrderItem values (8,32,54.98);
insert into AnimalOrderItem values (8,87,168.58);
insert into AnimalOrderItem values (8,148,154.74);
insert into AnimalOrderItem values (9,5,8.09);
insert into AnimalOrderItem values (9,39,104.90);
insert into AnimalOrderItem values (9,78,120.08);
insert into AnimalOrderItem values (9,116,36.76);
insert into AnimalOrderItem values (9,183,59.17);
insert into AnimalOrderItem values (10,108,109.40);
insert into AnimalOrderItem values (10,136,119.43);
insert into AnimalOrderItem values (11,44,73.01);
insert into AnimalOrderItem values (11,65,106.84);
insert into AnimalOrderItem values (11,196,129.13);
insert into AnimalOrderItem values (12,41,68.75);
insert into AnimalOrderItem values (12,94,142.25);
insert into AnimalOrderItem values (12,134,32.37);
insert into AnimalOrderItem values (12,164,124.84);
insert into AnimalOrderItem values (13,9,0.89);
insert into AnimalOrderItem values (13,37,50.58);
insert into AnimalOrderItem values (13,122,199.83);
insert into AnimalOrderItem values (14,26,89.35);
insert into AnimalOrderItem values (15,57,32.89);
insert into AnimalOrderItem values (15,95,91.76);
insert into AnimalOrderItem values (15,176,200.53);
insert into AnimalOrderItem values (16,7,103.65);
insert into AnimalOrderItem values (16,106,83.74);
insert into AnimalOrderItem values (16,199,30.59);
insert into AnimalOrderItem values (17,15,173.56);
insert into AnimalOrderItem values (17,109,91.04);
insert into AnimalOrderItem values (17,131,76.28);
insert into AnimalOrderItem values (17,169,80.27);
insert into AnimalOrderItem values (18,99,92.08);
insert into AnimalOrderItem values (18,100,72.44);
insert into AnimalOrderItem values (19,149,52.91);
insert into AnimalOrderItem values (19,158,90.27);
insert into AnimalOrderItem values (19,201,5.79);
insert into AnimalOrderItem values (20,8,98.21);
insert into AnimalOrderItem values (20,71,84.11);
insert into AnimalOrderItem values (20,73,30.15);
insert into AnimalOrderItem values (20,159,67.54);
insert into AnimalOrderItem values (21,33,49.33);
insert into AnimalOrderItem values (21,74,67.60);
insert into AnimalOrderItem values (21,91,78.04);
insert into AnimalOrderItem values (21,96,158.03);
insert into AnimalOrderItem values (21,112,47.47);
insert into AnimalOrderItem values (21,119,155.81);
insert into AnimalOrderItem values (21,135,41.45);
insert into AnimalOrderItem values (21,141,105.91);
insert into AnimalOrderItem values (21,165,120.73);
insert into AnimalOrderItem values (22,35,158.42);
insert into AnimalOrderItem values (22,124,113.35);
insert into AnimalOrderItem values (22,184,16.50);
insert into AnimalOrderItem values (23,45,94.00);
insert into AnimalOrderItem values (23,85,104.94);
insert into AnimalOrderItem values (23,150,61.90);
insert into AnimalOrderItem values (23,175,108.39);
insert into AnimalOrderItem values (23,186,227.47);
insert into AnimalOrderItem values (24,18,54.63);
insert into AnimalOrderItem values (24,61,114.79);
insert into AnimalOrderItem values (24,62,65.72);
insert into AnimalOrderItem values (24,139,78.03);
insert into AnimalOrderItem values (24,181,18.30);
insert into AnimalOrderItem values (25,49,122.14);
insert into AnimalOrderItem values (25,52,88.53);
insert into AnimalOrderItem values (25,55,149.28);
insert into AnimalOrderItem values (25,66,156.34);
insert into AnimalOrderItem values (25,77,128.39);
insert into AnimalOrderItem values (25,81,147.99);
insert into AnimalOrderItem values (25,138,163.10);
insert into AnimalOrderItem values (26,64,122.72);
insert into AnimalOrderItem values (27,177,125.24);
insert into AnimalOrderItem values (27,179,28.84);
insert into AnimalOrderItem values (27,185,57.39);
insert into AnimalOrderItem values (28,84,120.77);
insert into AnimalOrderItem values (28,97,69.13);
insert into AnimalOrderItem values (29,46,130.89);
insert into AnimalOrderItem values (29,75,68.87);
insert into AnimalOrderItem values (29,155,129.41);
insert into AnimalOrderItem values (29,166,48.66);
insert into AnimalOrderItem values (29,193,141.03);
insert into AnimalOrderItem values (30,21,32.96);
insert into AnimalOrderItem values (30,80,62.41);
insert into AnimalOrderItem values (30,88,47.38);
insert into AnimalOrderItem values (30,92,72.19);
insert into AnimalOrderItem values (30,127,71.91);
insert into AnimalOrderItem values (30,170,202.76);
insert into AnimalOrderItem values (31,98,111.02);
insert into AnimalOrderItem values (31,142,47.26);
insert into AnimalOrderItem values (31,156,109.80);
insert into AnimalOrderItem values (31,168,132.95);
insert into AnimalOrderItem values (32,11,84.30);
insert into AnimalOrderItem values (32,50,197.03);
insert into AnimalOrderItem values (32,53,10.59);
insert into AnimalOrderItem values (33,42,59.06);
insert into AnimalOrderItem values (33,89,79.23);
insert into AnimalOrderItem values (33,172,150.12);
insert into AnimalOrderItem values (33,178,128.79);
insert into AnimalOrderItem values (33,190,146.84);
insert into AnimalOrderItem values (34,29,13.40);
insert into AnimalOrderItem values (34,130,84.54);
insert into AnimalOrderItem values (34,151,53.36);
insert into AnimalOrderItem values (35,17,65.77);
insert into AnimalOrderItem values (35,56,102.53);
insert into AnimalOrderItem values (35,83,94.90);
insert into AnimalOrderItem values (35,90,60.29);
insert into AnimalOrderItem values (35,182,52.81);
insert into AnimalOrderItem values (35,195,142.13);
insert into AnimalOrderItem values (36,20,90.80);
insert into AnimalOrderItem values (36,63,124.29);
insert into AnimalOrderItem values (36,70,165.04);
insert into AnimalOrderItem values (36,93,91.30);
insert into AnimalOrderItem values (36,153,115.98);
insert into AnimalOrderItem values (36,162,64.76);
insert into AnimalOrderItem values (36,188,75.40);
insert into AnimalOrderItem values (36,191,102.15);
insert into AnimalOrderItem values (37,110,54.63);
insert into AnimalOrderItem values (37,117,3.32);
insert into AnimalOrderItem values (38,43,129.52);
insert into AnimalOrderItem values (38,115,98.44);
insert into AnimalOrderItem values (39,40,94.78);
insert into AnimalOrderItem values (39,51,42.64);
insert into AnimalOrderItem values (39,113,73.86);
insert into AnimalOrderItem values (39,128,62.20);
insert into AnimalOrderItem values (39,174,33.74);
insert into AnimalOrderItem values (40,28,32.47);
insert into AnimalOrderItem values (40,129,14.12);
insert into AnimalOrderItem values (40,140,82.57);
insert into AnimalOrderItem values (40,161,70.21);
insert into AnimalOrderItem values (41,24,43.83);
insert into AnimalOrderItem values (41,36,108.83);
insert into AnimalOrderItem values (41,54,60.72);
insert into AnimalOrderItem values (41,180,15.37);
insert into AnimalOrderItem values (42,14,60.62);
insert into AnimalOrderItem values (42,48,117.98);
insert into AnimalOrderItem values (42,111,148.00);
insert into AnimalOrderItem values (43,31,114.71);
insert into AnimalOrderItem values (43,133,211.22);
insert into AnimalOrderItem values (44,23,79.51);
insert into AnimalOrderItem values (44,60,130.28);
insert into AnimalOrderItem values (44,102,84.95);
insert into AnimalOrderItem values (44,105,43.40);
insert into AnimalOrderItem values (44,137,97.84);
insert into AnimalOrderItem values (44,143,87.18);
insert into AnimalOrderItem values (44,144,89.77);
insert into AnimalOrderItem values (44,157,199.82);
insert into AnimalOrderItem values (45,147,271.11);
insert into AnimalOrderItem values (46,19,91.26);
insert into AnimalOrderItem values (46,72,7.74);
insert into AnimalOrderItem values (46,86,18.58);
insert into AnimalOrderItem values (46,103,168.91);
insert into AnimalOrderItem values (46,118,2.84);
insert into AnimalOrderItem values (46,189,59.89);
insert into AnimalOrderItem values (47,13,2.75);
insert into AnimalOrderItem values (47,101,200.48);
insert into AnimalOrderItem values (47,160,138.20);
insert into AnimalOrderItem values (47,187,56.15);
insert into AnimalOrderItem values (48,121,148.11);
insert into AnimalOrderItem values (49,34,75.97);
insert into AnimalOrderItem values (49,197,94.87);
insert into AnimalOrderItem values (50,6,36.09);
insert into AnimalOrderItem values (50,12,106.67);
insert into AnimalOrderItem values (50,82,69.13);
insert into AnimalOrderItem values (50,198,113.01);

insert into OrderItem values(1,27,8.00,24.65);
insert into OrderItem values(1,30,208.00,4.42);
insert into OrderItem values(2,4,6.00,85.67);
insert into OrderItem values(2,17,1546.00,0.36);
insert into OrderItem values(2,18,321.00,0.80);
insert into OrderItem values(2,19,128.00,6.45);
insert into OrderItem values(3,3,5.00,67.84);
insert into OrderItem values(3,32,47.00,8.86);
insert into OrderItem values(3,36,42.00,21.22);
insert into OrderItem values(4,16,179.00,0.60);
insert into OrderItem values(4,28,14.00,17.87);
insert into OrderItem values(4,36,34.00,20.28);
insert into OrderItem values(5,6,12.00,25.76);
insert into OrderItem values(5,37,16.00,7.07);
insert into OrderItem values(6,9,55.00,5.21);
insert into OrderItem values(6,11,103.00,23.78);
insert into OrderItem values(6,17,1482.00,0.41);
insert into OrderItem values(6,21,5.00,17.64);
insert into OrderItem values(6,23,9.00,41.50);
insert into OrderItem values(6,24,3.00,124.20);
insert into OrderItem values(6,37,18.00,5.17);
insert into OrderItem values(7,20,66.00,7.99);
insert into OrderItem values(7,24,4.00,93.15);
insert into OrderItem values(8,16,233.00,0.47);
insert into OrderItem values(8,18,292.00,0.78);
insert into OrderItem values(8,30,221.00,6.09);
insert into OrderItem values(8,38,13.00,6.01);
insert into OrderItem values(9,28,12.00,13.74);
insert into OrderItem values(10,5,19.00,17.45);
insert into OrderItem values(10,16,205.00,0.66);
insert into OrderItem values(10,18,312.00,0.81);
insert into OrderItem values(10,31,328.00,7.83);
insert into OrderItem values(11,17,1424.00,0.39);
insert into OrderItem values(11,28,14.00,18.92);
insert into OrderItem values(11,33,92.00,12.09);
insert into OrderItem values(12,2,7.00,45.18);
insert into OrderItem values(12,16,185.00,0.59);
insert into OrderItem values(12,23,9.00,42.40);
insert into OrderItem values(12,28,13.00,22.07);
insert into OrderItem values(13,11,88.00,21.98);
insert into OrderItem values(13,15,452.00,0.27);
insert into OrderItem values(13,18,332.00,0.69);
insert into OrderItem values(13,29,115.00,4.80);
insert into OrderItem values(13,38,13.00,7.26);
insert into OrderItem values(14,2,7.00,50.63);
insert into OrderItem values(14,9,48.00,6.81);
insert into OrderItem values(14,17,1307.00,0.39);
insert into OrderItem values(14,29,125.00,4.62);
insert into OrderItem values(14,39,25.00,6.82);
insert into OrderItem values(15,6,12.00,31.01);
insert into OrderItem values(15,7,134.00,3.08);
insert into OrderItem values(15,38,11.00,5.37);
insert into OrderItem values(16,8,85.00,2.33);
insert into OrderItem values(16,16,178.00,0.55);
insert into OrderItem values(16,25,39.00,2.18);
insert into OrderItem values(16,26,48.00,4.57);
insert into OrderItem values(16,39,24.00,6.55);
insert into OrderItem values(17,5,17.00,19.01);
insert into OrderItem values(17,11,94.00,21.41);
insert into OrderItem values(17,18,301.00,0.77);
insert into OrderItem values(17,23,10.00,35.75);
insert into OrderItem values(17,24,4.00,134.73);
insert into OrderItem values(17,27,10.00,25.13);
insert into OrderItem values(17,31,359.00,6.17);
insert into OrderItem values(18,25,39.00,2.84);
insert into OrderItem values(19,31,331.00,5.68);
insert into OrderItem values(19,36,48.00,17.97);
insert into OrderItem values(20,9,57.00,5.52);
insert into OrderItem values(20,11,88.00,21.30);
insert into OrderItem values(21,18,316.00,0.78);
insert into OrderItem values(21,34,132.00,16.14);
insert into OrderItem values(21,38,13.00,4.46);
insert into OrderItem values(21,39,27.00,5.27);
insert into OrderItem values(22,1,14.00,30.94);
insert into OrderItem values(22,9,51.00,6.69);
insert into OrderItem values(22,28,12.00,14.46);
insert into OrderItem values(22,36,48.00,14.92);
insert into OrderItem values(22,39,25.00,5.37);
insert into OrderItem values(23,3,5.00,65.13);
insert into OrderItem values(23,17,1711.00,0.42);
insert into OrderItem values(23,39,30.00,4.69);
insert into OrderItem values(24,6,11.00,22.67);
insert into OrderItem values(24,8,97.00,2.27);
insert into OrderItem values(24,20,75.00,8.56);
insert into OrderItem values(24,40,20.00,13.44);
insert into OrderItem values(25,16,199.00,0.64);
insert into OrderItem values(25,25,35.00,1.99);
commit;

insert into Sale values(4,'14-Aug-2004',3,18,14.62);
insert into Sale values(5,'31-Oct-2004',2,21,6.86);
insert into Sale values(6,'15-Sep-2004',5,44,9.82);
insert into Sale values(7,'10-Feb-2004',4,42,12.31);
insert into Sale values(8,'10-Mar-2004',1,15,17.58);
insert into Sale values(9,'10-Feb-2004',3,16,2.81);
insert into Sale values(10,'1-Nov-2004',8,53,7.83);
insert into Sale values(11,'24-Dec-2004',8,60,3.67);
insert into Sale values(12,'15-Aug-2004',2,53,1.19);
insert into Sale values(13,'30-Jan-2004',7,49,14.81);
insert into Sale values(14,'18-Sep-2004',2,9,3.56);
insert into Sale values(15,'20-Jul-2004',9,39,1.13);
insert into Sale values(16,'18-Sep-2004',8,62,12.96);
insert into Sale values(17,'12-Feb-2004',4,71,16.31);
insert into Sale values(18,'21-Dec-2004',5,35,14.95);
insert into Sale values(19,'14-Feb-2004',7,14,15.72);
insert into Sale values(20,'9-Mar-2004',5,2,12.96);
insert into Sale values(21,'23-Apr-2004',2,61,20.14);
insert into Sale values(22,'27-Nov-2004',2,16,9.67);
insert into Sale values(23,'8-Jul-2004',6,27,10.53);
insert into Sale values(24,'24-Aug-2004',2,99,3.02);
insert into Sale values(25,'17-Feb-2004',6,85,15.10);
insert into Sale values(26,'11-Jan-2004',5,49,14.49);
insert into Sale values(27,'25-Oct-2004',2,47,32.80);
insert into Sale values(28,'12-Feb-2004',6,24,10.28);
insert into Sale values(29,'16-Jun-2004',7,82,15.38);
insert into Sale values(30,'15-Oct-2004',4,26,8.14);
insert into Sale values(31,'22-Apr-2004',7,19,13.69);
insert into Sale values(32,'9-Mar-2004',3,72,15.95);
insert into Sale values(33,'15-Mar-2004',1,78,20.73);
insert into Sale values(34,'6-Apr-2004',8,35,16.84);
insert into Sale values(35,'2-Jun-2004',9,38,0.65);
insert into Sale values(36,'18-Mar-2004',1,88,8.95);
insert into Sale values(37,'17-Mar-2004',6,21,11.51);
insert into Sale values(38,'10-Feb-2004',1,94,5.91);
insert into Sale values(39,'19-Oct-2004',4,51,0.49);
insert into Sale values(40,'7-Apr-2004',5,9,17.87);
insert into Sale values(41,'9-Jun-2004',3,38,10.37);
insert into Sale values(42,'21-Mar-2004',3,3,7.02);
insert into Sale values(43,'11-Apr-2004',8,72,10.51);
insert into Sale values(44,'17-Feb-2004',2,22,0.00);
insert into Sale values(45,'13-Mar-2004',3,28,10.77);
insert into Sale values(46,'2-Jun-2004',5,23,20.40);
insert into Sale values(47,'21-Sep-2004',8,38,0.00);
insert into Sale values(48,'16-Feb-2004',9,69,10.50);
insert into Sale values(49,'16-Sep-2004',8,66,2.70);
insert into Sale values(50,'28-Sep-2004',9,82,13.11);
insert into Sale values(51,'19-Jun-2004',6,80,10.13);
insert into Sale values(52,'18-Jun-2004',9,57,11.60);
insert into Sale values(53,'5-Feb-2004',5,43,7.85);
insert into Sale values(54,'1-Nov-2004',3,8,23.19);
insert into Sale values(55,'15-Jan-2004',5,22,12.32);
insert into Sale values(56,'22-Dec-2004',6,99,12.23);
insert into Sale values(57,'16-Feb-2004',5,25,22.84);
insert into Sale values(58,'24-Oct-2004',7,74,0.00);
insert into Sale values(59,'23-Aug-2004',3,1,11.41);
insert into Sale values(60,'9-Mar-2004',7,86,11.68);
insert into Sale values(61,'8-Feb-2004',8,43,11.82);
insert into Sale values(62,'8-Feb-2004',4,91,12.50);
insert into Sale values(63,'9-Dec-2004',4,20,0.27);
insert into Sale values(64,'18-Feb-2004',8,74,17.07);
insert into Sale values(65,'13-Feb-2004',4,95,7.16);
insert into Sale values(66,'21-Mar-2004',6,99,14.93);
insert into Sale values(67,'9-Mar-2004',7,19,31.68);
insert into Sale values(68,'11-Jan-2004',2,8,12.80);
insert into Sale values(69,'4-Mar-2004',9,94,24.98);
insert into Sale values(70,'13-Apr-2004',8,11,14.86);
insert into Sale values(71,'26-Jul-2004',8,75,9.02);
insert into Sale values(72,'4-Nov-2004',7,55,17.59);
insert into Sale values(73,'15-Aug-2004',6,20,7.61);
insert into Sale values(74,'17-Apr-2004',5,50,10.46);
insert into Sale values(75,'21-Jun-2004',2,24,16.96);
insert into Sale values(76,'18-Feb-2004',3,79,6.46);
insert into Sale values(77,'8-Nov-2004',1,7,5.94);
insert into Sale values(78,'8-Aug-2004',3,48,12.71);
insert into Sale values(79,'4-Jan-2004',2,9,9.18);
insert into Sale values(80,'5-Nov-2004',1,32,9.40);
insert into Sale values(81,'6-Jun-2004',7,55,16.17);
insert into Sale values(82,'5-May-2004',5,36,7.12);
insert into Sale values(83,'16-Nov-2004',6,56,13.18);
insert into Sale values(84,'21-Oct-2004',7,66,7.11);
insert into Sale values(85,'28-Mar-2004',2,71,6.48);
insert into Sale values(86,'28-Mar-2004',2,81,12.39);
insert into Sale values(87,'17-Feb-2004',4,68,9.43);
insert into Sale values(88,'28-Jan-2004',2,81,17.07);
insert into Sale values(89,'11-Mar-2004',4,23,10.61);
insert into Sale values(90,'28-Jan-2004',6,40,9.93);
insert into Sale values(91,'16-Feb-2004',5,56,16.46);
insert into Sale values(92,'20-Sep-2004',4,90,9.27);
insert into Sale values(93,'12-Feb-2004',2,25,17.64);
insert into Sale values(94,'13-Jan-2004',7,35,7.99);
insert into Sale values(95,'19-May-2004',7,78,13.89);
insert into Sale values(96,'24-Oct-2004',1,12,11.96);
insert into Sale values(97,'1-Jun-2004',2,56,17.06);
insert into Sale values(98,'13-Aug-2004',8,63,11.24);
insert into Sale values(99,'11-Jan-2004',8,19,16.26);
insert into Sale values(100,'13-Sep-2004',4,84,14.40);
insert into Sale values(101,'9-Aug-2004',9,90,22.62);
insert into Sale values(102,'31-May-2004',9,26,7.17);
insert into Sale values(103,'3-Dec-2004',7,86,12.61);
insert into Sale values(104,'13-Feb-2004',4,13,13.39);
insert into Sale values(105,'14-Feb-2004',5,57,6.92);
insert into Sale values(106,'17-Feb-2004',2,79,9.67);
insert into Sale values(107,'10-Feb-2004',4,38,10.66);
insert into Sale values(108,'15-Jul-2004',5,34,14.46);
insert into Sale values(109,'29-Jan-2004',3,30,27.07);
insert into Sale values(110,'5-Mar-2004',6,19,9.13);
insert into Sale values(111,'10-Feb-2004',2,23,7.18);
insert into Sale values(112,'19-Feb-2004',5,9,7.99);
insert into Sale values(113,'16-Feb-2004',4,37,11.67);
insert into Sale values(114,'8-Oct-2004',8,80,12.06);
insert into Sale values(115,'4-Jun-2004',3,60,2.70);
insert into Sale values(116,'20-Sep-2004',7,38,10.94);
insert into Sale values(117,'20-Aug-2004',9,95,10.14);
insert into Sale values(118,'30-Jan-2004',2,72,16.19);
insert into Sale values(119,'2-Jun-2004',3,39,10.22);
insert into Sale values(120,'20-Jun-2004',3,6,9.70);
insert into Sale values(121,'6-Jun-2004',4,73,14.20);
insert into Sale values(122,'11-Oct-2004',8,29,15.37);
insert into Sale values(123,'5-Apr-2004',3,35,2.21);
insert into Sale values(124,'17-Feb-2004',6,48,11.93);
insert into Sale values(125,'11-Jun-2004',8,76,10.57);
insert into Sale values(126,'9-Nov-2004',8,90,17.72);
insert into Sale values(127,'17-Oct-2004',7,65,14.44);
insert into Sale values(128,'9-Apr-2004',4,43,13.98);
insert into Sale values(129,'24-Sep-2004',10,58,11.08);
insert into Sale values(130,'6-Mar-2004',3,9,11.17);
insert into Sale values(131,'23-Apr-2004',9,59,8.91);
insert into Sale values(132,'17-Feb-2004',8,28,11.58);
insert into Sale values(133,'19-Mar-2004',4,54,14.66);
insert into Sale values(134,'18-Feb-2004',7,75,13.85);
insert into Sale values(135,'11-Oct-2004',2,58,16.57);
insert into Sale values(136,'21-Feb-2004',9,42,12.88);
insert into Sale values(137,'26-Oct-2004',3,46,22.19);
insert into Sale values(138,'16-Aug-2004',2,74,10.43);
insert into Sale values(139,'14-Mar-2004',9,36,11.74);
insert into Sale values(140,'14-Mar-2004',7,95,5.03);
insert into Sale values(141,'19-Mar-2004',5,46,13.93);
insert into Sale values(142,'30-Jan-2004',7,69,24.39);
insert into Sale values(143,'17-Feb-2004',8,51,8.11);
insert into Sale values(144,'27-Jan-2004',8,59,17.24);
insert into Sale values(145,'25-Mar-2004',2,8,26.37);
insert into Sale values(146,'19-Mar-2004',7,98,7.28);
insert into Sale values(147,'19-Mar-2004',2,18,18.01);
insert into Sale values(148,'29-Jul-2004',9,80,12.63);
insert into Sale values(149,'30-May-2004',6,60,12.55);
insert into Sale values(150,'9-May-2004',3,14,12.64);
insert into Sale values(151,'30-Jul-2004',3,5,11.82);
insert into Sale values(152,'2-Jun-2004',5,30,24.79);
insert into Sale values(153,'18-Feb-2004',10,75,10.20);
insert into Sale values(154,'5-Nov-2004',1,27,9.86);
insert into Sale values(155,'19-Mar-2004',4,58,16.89);
insert into Sale values(156,'15-May-2004',4,66,14.79);
insert into Sale values(157,'19-Mar-2004',4,44,10.86);
insert into Sale values(158,'24-Mar-2004',8,94,20.08);
insert into Sale values(159,'17-Sep-2004',4,53,15.25);
insert into Sale values(160,'24-Aug-2004',3,27,16.18);
insert into Sale values(161,'13-Jun-2004',2,96,7.15);
insert into Sale values(162,'10-Mar-2004',5,22,30.31);
insert into Sale values(163,'30-Sep-2004',5,63,13.54);
insert into Sale values(164,'30-May-2004',5,47,14.47);
insert into Sale values(165,'16-Mar-2004',3,33,31.23);
insert into Sale values(166,'16-Feb-2004',4,92,10.43);
insert into Sale values(167,'10-Mar-2004',3,60,20.59);
insert into Sale values(168,'23-Jan-2004',7,3,17.05);
insert into Sale values(169,'25-Feb-2004',4,84,7.54);
insert into Sale values(170,'27-Feb-2004',9,21,16.44);
insert into Sale values(171,'12-Mar-2004',7,40,11.80);
insert into Sale values(172,'9-Mar-2004',10,73,15.98);
insert into Sale values(173,'25-Feb-2004',7,2,10.63);
insert into Sale values(174,'18-Jun-2004',9,34,5.78);
insert into Sale values(176,'8-Jan-2004',2,1,2.32);
insert into Sale values(177,'12-Jan-2004',2,1,2.05);
insert into Sale values(178,'8-Jan-2004',3,1,5.94);
insert into Sale values(179,'8-Jan-2004',3,1,3.94);
insert into Sale values(180,'8-Jan-2004',3,1,2.54);
insert into Sale values(181,'8-Jan-2004',3,1,10.96);
insert into Sale values(182,'12-Jan-2004',2,1,1.73);
insert into Sale values(183,'12-Jan-2004',2,1,2.32);
insert into Sale values(184,'12-Jan-2004',2,1,4.32);
insert into Sale values(185,'15-Feb-2004',1,1,11.07);
insert into Sale values(186,'15-Feb-2004',1,1,7.61);
insert into Sale values(187,'8-Jan-2004',1,1,13.23);
insert into Sale values(188,'15-Feb-2004',1,1,14.31);
insert into Sale values(189,'15-Mar-2004',4,1,8.91);
insert into Sale values(190,'15-Mar-2004',4,1,8.42);
insert into Sale values(191,'15-Mar-2004',4,1,4.27);
insert into Sale values(192,'15-Mar-2004',4,1,11.93);
insert into Sale values(193,'15-Mar-2004',4,1,4.75);
insert into Sale values(194,'15-Mar-2004',4,1,4.37);
insert into Sale values(195,'15-Mar-2004',4,1,6.40);
insert into Sale values(196,'1-Jan-2004',2,1,1.62);
insert into Sale values(197,'12-Jan-2004',3,1,0.43);
insert into Sale values(198,'5-May-2000',1,1,3.00);
insert into Sale values(199,'11-Apr-2000',1,4,0.00);
insert into Sale values(200,'5-May-2000',3,1,0.00);
commit;

insert into SaleAnimal values(4,8,183.38);
insert into SaleAnimal values(5,183,114.30);
insert into SaleAnimal values(6,58,132.19);
insert into SaleAnimal values(7,24,147.58);
insert into SaleAnimal values(8,42,174.27);
insert into SaleAnimal values(9,53,46.80);
insert into SaleAnimal values(10,9,1.80);
insert into SaleAnimal values(12,5,19.80);
insert into SaleAnimal values(13,162,119.88);
insert into SaleAnimal values(13,199,100.00);
insert into SaleAnimal values(15,13,10.80);
insert into SaleAnimal values(16,193,216.05);
insert into SaleAnimal values(17,11,148.47);
insert into SaleAnimal values(18,10,150.11);
insert into SaleAnimal values(19,47,185.47);
insert into SaleAnimal values(20,13,10.80);
insert into SaleAnimal values(20,18,194.33);
insert into SaleAnimal values(21,163,234.93);
insert into SaleAnimal values(22,67,161.15);
insert into SaleAnimal values(23,189,153.07);
insert into SaleAnimal values(25,7,251.59);
insert into SaleAnimal values(26,64,229.73);
insert into SaleAnimal values(26,72,11.70);
insert into SaleAnimal values(27,6,173.99);
insert into SaleAnimal values(27,47,185.47);
insert into SaleAnimal values(28,36,171.41);
insert into SaleAnimal values(29,15,256.37);
insert into SaleAnimal values(30,198,128.41);
insert into SaleAnimal values(31,59,179.57);
insert into SaleAnimal values(32,16,246.92);
insert into SaleAnimal values(33,90,201.57);
insert into SaleAnimal values(34,46,229.37);
insert into SaleAnimal values(36,17,149.16);
insert into SaleAnimal values(37,20,191.87);
insert into SaleAnimal values(38,23,97.49);
insert into SaleAnimal values(40,26,217.80);
insert into SaleAnimal values(41,27,172.88);
insert into SaleAnimal values(42,28,40.50);
insert into SaleAnimal values(43,31,148.23);
insert into SaleAnimal values(44,70,185.92);
insert into SaleAnimal values(45,196,179.55);
insert into SaleAnimal values(46,14,129.55);
insert into SaleAnimal values(46,45,164.50);
insert into SaleAnimal values(47,21,160.10);
insert into SaleAnimal values(47,32,125.03);
insert into SaleAnimal values(48,174,166.46);
insert into SaleAnimal values(49,29,13.50);
insert into SaleAnimal values(50,33,110.13);
insert into SaleAnimal values(50,200,108.33);
insert into SaleAnimal values(51,30,168.86);
insert into SaleAnimal values(52,40,193.34);
insert into SaleAnimal values(53,112,130.81);
insert into SaleAnimal values(54,37,103.86);
insert into SaleAnimal values(54,95,165.14);
insert into SaleAnimal values(55,35,182.80);
insert into SaleAnimal values(56,48,203.89);
insert into SaleAnimal values(57,43,214.12);
insert into SaleAnimal values(58,44,127.05);
insert into SaleAnimal values(59,39,190.16);
insert into SaleAnimal values(60,195,175.97);
insert into SaleAnimal values(61,49,197.06);
insert into SaleAnimal values(62,52,208.30);
insert into SaleAnimal values(64,50,240.35);
insert into SaleAnimal values(65,54,96.78);
insert into SaleAnimal values(66,147,245.27);
insert into SaleAnimal values(67,41,161.94);
insert into SaleAnimal values(67,55,184.25);
insert into SaleAnimal values(68,57,213.39);
insert into SaleAnimal values(69,56,204.66);
insert into SaleAnimal values(69,65,119.92);
insert into SaleAnimal values(70,66,247.60);
insert into SaleAnimal values(71,97,127.76);
insert into SaleAnimal values(72,60,293.13);
insert into SaleAnimal values(73,69,94.39);
insert into SaleAnimal values(74,63,172.15);
insert into SaleAnimal values(75,51,221.45);
insert into SaleAnimal values(76,71,107.71);
insert into SaleAnimal values(78,68,211.75);
insert into SaleAnimal values(79,74,115.28);
insert into SaleAnimal values(81,79,202.03);
insert into SaleAnimal values(82,75,118.65);
insert into SaleAnimal values(83,82,112.50);
insert into SaleAnimal values(84,62,87.06);
insert into SaleAnimal values(85,80,76.01);
insert into SaleAnimal values(86,81,206.50);
insert into SaleAnimal values(87,73,111.29);
insert into SaleAnimal values(88,77,160.35);
insert into SaleAnimal values(88,86,19.80);
insert into SaleAnimal values(89,83,139.92);
insert into SaleAnimal values(90,89,138.55);
insert into SaleAnimal values(91,84,264.84);
insert into SaleAnimal values(92,91,154.44);
insert into SaleAnimal values(93,78,194.17);
insert into SaleAnimal values(94,93,128.77);
insert into SaleAnimal values(95,98,159.48);
insert into SaleAnimal values(96,61,199.40);
insert into SaleAnimal values(97,99,207.81);
insert into SaleAnimal values(98,87,187.31);
insert into SaleAnimal values(99,101,194.49);
insert into SaleAnimal values(100,96,217.51);
insert into SaleAnimal values(101,104,162.35);
insert into SaleAnimal values(101,111,214.70);
insert into SaleAnimal values(102,100,119.52);
insert into SaleAnimal values(103,191,210.09);
insert into SaleAnimal values(104,103,209.62);
insert into SaleAnimal values(105,109,115.40);
insert into SaleAnimal values(106,105,159.36);
insert into SaleAnimal values(107,102,177.59);
insert into SaleAnimal values(108,110,173.50);
insert into SaleAnimal values(109,115,189.79);
insert into SaleAnimal values(109,164,228.09);
insert into SaleAnimal values(110,108,152.22);
insert into SaleAnimal values(111,116,119.71);
insert into SaleAnimal values(112,118,3.60);
insert into SaleAnimal values(113,85,160.78);
insert into SaleAnimal values(114,94,201.04);
insert into SaleAnimal values(115,117,45.00);
insert into SaleAnimal values(116,119,182.31);
insert into SaleAnimal values(117,124,168.93);
insert into SaleAnimal values(118,122,254.56);
insert into SaleAnimal values(119,126,170.34);
insert into SaleAnimal values(120,113,128.36);
insert into SaleAnimal values(121,128,140.36);
insert into SaleAnimal values(122,121,256.09);
insert into SaleAnimal values(123,129,14.40);
insert into SaleAnimal values(124,106,198.85);
insert into SaleAnimal values(125,127,176.15);
insert into SaleAnimal values(126,133,295.36);
insert into SaleAnimal values(127,134,164.13);
insert into SaleAnimal values(128,120,195.23);
insert into SaleAnimal values(129,92,162.15);
insert into SaleAnimal values(130,136,186.10);
insert into SaleAnimal values(131,132,141.31);
insert into SaleAnimal values(132,131,192.96);
insert into SaleAnimal values(133,139,198.88);
insert into SaleAnimal values(134,141,211.06);
insert into SaleAnimal values(135,197,199.67);
insert into SaleAnimal values(136,137,214.67);
insert into SaleAnimal values(137,130,142.05);
insert into SaleAnimal values(137,143,146.76);
insert into SaleAnimal values(138,125,173.77);
insert into SaleAnimal values(139,145,181.67);
insert into SaleAnimal values(140,146,83.77);
insert into SaleAnimal values(141,148,232.11);
insert into SaleAnimal values(142,150,151.92);
insert into SaleAnimal values(142,160,159.12);
insert into SaleAnimal values(143,135,112.71);
insert into SaleAnimal values(144,151,219.78);
insert into SaleAnimal values(145,149,124.94);
insert into SaleAnimal values(145,153,211.09);
insert into SaleAnimal values(146,140,121.33);
insert into SaleAnimal values(147,156,252.53);
insert into SaleAnimal values(148,176,162.84);
insert into SaleAnimal values(149,138,209.22);
insert into SaleAnimal values(150,154,177.31);
insert into SaleAnimal values(151,152,196.95);
insert into SaleAnimal values(152,155,200.64);
insert into SaleAnimal values(152,166,147.35);
insert into SaleAnimal values(153,142,162.84);
insert into SaleAnimal values(154,144,164.34);
insert into SaleAnimal values(155,157,214.04);
insert into SaleAnimal values(156,159,127.78);
insert into SaleAnimal values(157,158,150.45);
insert into SaleAnimal values(158,161,220.41);
insert into SaleAnimal values(159,165,155.14);
insert into SaleAnimal values(160,168,203.12);
insert into SaleAnimal values(160,173,19.80);
insert into SaleAnimal values(161,169,119.24);
insert into SaleAnimal values(162,171,209.04);
insert into SaleAnimal values(162,172,218.06);
insert into SaleAnimal values(163,170,225.73);
insert into SaleAnimal values(164,180,24.30);
insert into SaleAnimal values(164,184,22.50);
insert into SaleAnimal values(165,178,148.17);
insert into SaleAnimal values(165,185,147.73);
insert into SaleAnimal values(166,175,173.83);
insert into SaleAnimal values(167,187,120.29);
insert into SaleAnimal values(167,190,147.24);
insert into SaleAnimal values(168,177,185.18);
insert into SaleAnimal values(169,179,125.65);
insert into SaleAnimal values(170,186,216.37);
insert into SaleAnimal values(171,182,196.64);
insert into SaleAnimal values(172,188,211.48);
insert into SaleAnimal values(173,192,177.19);
insert into SaleAnimal values(174,201,19.80);
commit;

insert into SaleItem values(4,1,1,16.00);
insert into SaleItem values(4,36,1,19.80);
insert into SaleItem values(6,20,1,9.00);
insert into SaleItem values(6,21,1,22.50);
insert into SaleItem values(7,5,1,22.50);
insert into SaleItem values(7,19,3,7.20);
insert into SaleItem values(7,40,1,13.50);
insert into SaleItem values(8,11,1,27.00);
insert into SaleItem values(8,16,100,0.72);
insert into SaleItem values(8,36,1,19.80);
insert into SaleItem values(10,23,1,67.50);
insert into SaleItem values(10,25,5,2.70);
insert into SaleItem values(10,26,3,5.40);
insert into SaleItem values(10,27,1,31.50);
insert into SaleItem values(11,11,2,27.00);
insert into SaleItem values(11,15,20,0.36);
insert into SaleItem values(13,8,2,2.70);
insert into SaleItem values(13,38,1,7.20);
insert into SaleItem values(13,39,2,7.20);
insert into SaleItem values(14,18,50,0.90);
insert into SaleItem values(14,19,2,7.20);
insert into SaleItem values(15,25,1,2.70);
insert into SaleItem values(15,26,1,5.40);
insert into SaleItem values(17,3,1,76.50);
insert into SaleItem values(17,30,1,6.30);
insert into SaleItem values(17,33,1,13.50);
insert into SaleItem values(17,36,1,19.80);
insert into SaleItem values(17,37,1,7.20);
insert into SaleItem values(18,4,1,99.00);
insert into SaleItem values(19,3,1,76.50);
insert into SaleItem values(20,25,4,2.70);
insert into SaleItem values(21,11,3,27.00);
insert into SaleItem values(21,36,1,19.80);
insert into SaleItem values(23,21,1,22.50);
insert into SaleItem values(24,25,3,2.70);
insert into SaleItem values(24,26,2,5.40);
insert into SaleItem values(24,27,1,31.50);
insert into SaleItem values(27,3,1,76.50);
insert into SaleItem values(27,5,1,22.50);
insert into SaleItem values(27,11,2,27.00);
insert into SaleItem values(27,15,50,0.36);
insert into SaleItem values(27,18,10,0.90);
insert into SaleItem values(27,38,1,7.20);
insert into SaleItem values(30,37,1,7.20);
insert into SaleItem values(31,31,2,7.65);
insert into SaleItem values(31,33,1,13.50);
insert into SaleItem values(31,36,1,19.80);
insert into SaleItem values(32,30,3,6.30);
insert into SaleItem values(33,11,4,27.00);
insert into SaleItem values(33,15,100,0.36);
insert into SaleItem values(34,1,1,40.50);
insert into SaleItem values(34,32,1,10.80);
insert into SaleItem values(38,15,1,0.36);
insert into SaleItem values(38,16,1,0.72);
insert into SaleItem values(39,15,10,0.36);
insert into SaleItem values(39,17,10,0.45);
insert into SaleItem values(40,3,1,76.50);
insert into SaleItem values(40,16,5,0.72);
insert into SaleItem values(42,20,1,9.00);
insert into SaleItem values(42,23,1,67.50);
insert into SaleItem values(43,11,1,27.00);
insert into SaleItem values(44,34,1,18.00);
insert into SaleItem values(46,6,1,31.50);
insert into SaleItem values(46,18,1,0.90);
insert into SaleItem values(46,36,1,13.50);
insert into SaleItem values(47,21,1,22.50);
insert into SaleItem values(48,9,1,6.75);
insert into SaleItem values(48,15,5,0.36);
insert into SaleItem values(49,27,1,31.50);
insert into SaleItem values(54,1,1,40.50);
insert into SaleItem values(54,2,1,58.50);
insert into SaleItem values(54,17,1,0.45);
insert into SaleItem values(54,32,1,10.80);
insert into SaleItem values(54,38,1,7.20);
insert into SaleItem values(55,21,1,22.50);
insert into SaleItem values(57,20,1,9.00);
insert into SaleItem values(57,24,1,135.00);
insert into SaleItem values(57,28,1,22.50);
insert into SaleItem values(58,4,1,99.00);
insert into SaleItem values(58,11,1,27.00);
insert into SaleItem values(58,16,100,0.72);
insert into SaleItem values(60,10,1,14.40);
insert into SaleItem values(60,16,6,0.72);
insert into SaleItem values(63,17,10,0.45);
insert into SaleItem values(64,1,1,40.50);
insert into SaleItem values(64,7,1,3.60);
insert into SaleItem values(65,21,1,22.50);
insert into SaleItem values(66,7,1,3.60);
insert into SaleItem values(67,1,1,40.50);
insert into SaleItem values(67,2,1,58.50);
insert into SaleItem values(67,11,1,27.00);
insert into SaleItem values(67,16,12,0.72);
insert into SaleItem values(67,31,1,7.65);
insert into SaleItem values(67,36,2,19.80);
insert into SaleItem values(69,6,2,31.50);
insert into SaleItem values(69,8,2,2.70);
insert into SaleItem values(69,18,10,0.90);
insert into SaleItem values(69,38,2,7.20);
insert into SaleItem values(71,5,1,22.50);
insert into SaleItem values(73,10,1,14.40);
insert into SaleItem values(73,34,1,18.00);
insert into SaleItem values(74,17,5,0.45);
insert into SaleItem values(75,7,3,13.50);
insert into SaleItem values(75,33,1,13.50);
insert into SaleItem values(75,38,1,7.20);
insert into SaleItem values(77,23,1,67.50);
insert into SaleItem values(77,27,1,31.50);
insert into SaleItem values(79,16,20,0.90);
insert into SaleItem values(79,18,10,0.90);
insert into SaleItem values(79,32,1,10.80);
insert into SaleItem values(81,22,1,67.50);
insert into SaleItem values(83,2,1,58.50);
insert into SaleItem values(83,18,10,0.90);
insert into SaleItem values(83,20,1,9.00);
insert into SaleItem values(83,32,1,10.80);
insert into SaleItem values(83,36,1,19.80);
insert into SaleItem values(84,6,1,31.50);
insert into SaleItem values(85,9,1,6.75);
insert into SaleItem values(85,16,10,0.72);
insert into SaleItem values(85,32,1,10.80);
insert into SaleItem values(85,37,1,7.20);
insert into SaleItem values(87,30,2,6.30);
insert into SaleItem values(87,33,1,13.50);
insert into SaleItem values(87,36,1,19.80);
insert into SaleItem values(88,23,1,67.50);
insert into SaleItem values(88,26,1,5.40);
insert into SaleItem values(88,27,1,31.50);
insert into SaleItem values(89,5,1,22.50);
insert into SaleItem values(89,10,1,14.40);
insert into SaleItem values(90,7,2,3.60);
insert into SaleItem values(90,36,1,19.80);
insert into SaleItem values(91,17,5,0.45);
insert into SaleItem values(91,38,1,7.20);
insert into SaleItem values(93,10,1,14.40);
insert into SaleItem values(93,34,1,18.00);
insert into SaleItem values(93,36,1,67.50);
insert into SaleItem values(94,16,6,0.72);
insert into SaleItem values(95,2,1,58.50);
insert into SaleItem values(95,33,1,13.50);
insert into SaleItem values(97,20,1,9.00);
insert into SaleItem values(97,23,1,67.50);
insert into SaleItem values(99,3,1,76.50);
insert into SaleItem values(100,5,1,22.50);
insert into SaleItem values(104,18,7,0.90);
insert into SaleItem values(104,38,1,7.20);
insert into SaleItem values(106,17,4,0.45);
insert into SaleItem values(108,22,1,67.50);
insert into SaleItem values(109,8,1,2.70);
insert into SaleItem values(109,18,1,0.90);
insert into SaleItem values(109,21,1,22.50);
insert into SaleItem values(109,38,1,7.20);
insert into SaleItem values(112,23,1,67.50);
insert into SaleItem values(112,25,3,2.70);
insert into SaleItem values(112,27,1,31.50);
insert into SaleItem values(112,28,1,22.50);
insert into SaleItem values(113,6,1,31.50);
insert into SaleItem values(113,15,6,0.36);
insert into SaleItem values(118,18,1,0.90);
insert into SaleItem values(118,35,1,7.20);
insert into SaleItem values(118,38,1,7.20);
insert into SaleItem values(120,33,1,13.50);
insert into SaleItem values(120,36,1,19.80);
insert into SaleItem values(121,3,1,58.50);
insert into SaleItem values(121,34,1,18.00);
insert into SaleItem values(121,36,1,19.80);
insert into SaleItem values(123,28,1,22.50);
insert into SaleItem values(127,20,1,9.00);
insert into SaleItem values(127,23,1,67.50);
insert into SaleItem values(128,34,1,18.00);
insert into SaleItem values(128,36,1,19.80);
insert into SaleItem values(129,21,1,22.50);
insert into SaleItem values(131,37,1,7.20);
insert into SaleItem values(133,31,1,7.65);
insert into SaleItem values(133,34,1,18.00);
insert into SaleItem values(133,36,1,19.80);
insert into SaleItem values(134,36,1,19.80);
insert into SaleItem values(135,20,1,9.00);
insert into SaleItem values(135,23,1,67.50);
insert into SaleItem values(137,11,1,27.00);
insert into SaleItem values(137,14,1,16.20);
insert into SaleItem values(137,34,1,18.00);
insert into SaleItem values(137,36,1,19.80);
insert into SaleItem values(139,9,1,6.75);
insert into SaleItem values(139,38,1,7.20);
insert into SaleItem values(142,7,2,3.60);
insert into SaleItem values(142,11,1,27.00);
insert into SaleItem values(142,32,2,10.80);
insert into SaleItem values(142,36,2,19.80);
insert into SaleItem values(143,21,1,22.50);
insert into SaleItem values(144,22,1,67.50);
insert into SaleItem values(145,6,2,31.50);
insert into SaleItem values(145,8,3,2.70);
insert into SaleItem values(145,18,20,0.90);
insert into SaleItem values(145,38,2,7.20);
insert into SaleItem values(147,10,1,14.40);
insert into SaleItem values(147,33,1,13.50);
insert into SaleItem values(147,36,1,19.80);
insert into SaleItem values(148,10,1,14.40);
insert into SaleItem values(148,33,1,13.50);
insert into SaleItem values(148,36,1,19.80);
insert into SaleItem values(150,33,1,13.50);
insert into SaleItem values(150,36,1,19.80);
insert into SaleItem values(152,6,2,31.50);
insert into SaleItem values(152,17,5,0.45);
insert into SaleItem values(153,16,10,0.72);
insert into SaleItem values(155,22,1,67.50);
insert into SaleItem values(156,4,1,99.00);
insert into SaleItem values(156,14,2,6.30);
insert into SaleItem values(156,16,10,0.72);
insert into SaleItem values(157,34,1,10.80);
insert into SaleItem values(157,36,1,19.80);
insert into SaleItem values(158,4,1,76.50);
insert into SaleItem values(158,34,1,18.00);
insert into SaleItem values(158,36,1,19.80);
insert into SaleItem values(159,4,1,99.00);
insert into SaleItem values(160,1,1,40.50);
insert into SaleItem values(162,7,2,3.60);
insert into SaleItem values(162,15,12,0.36);
insert into SaleItem values(162,33,2,13.50);
insert into SaleItem values(162,36,2,19.80);
insert into SaleItem values(164,24,1,135.00);
insert into SaleItem values(164,26,1,5.40);
insert into SaleItem values(164,27,1,31.50);
insert into SaleItem values(164,28,1,22.50);
insert into SaleItem values(165,1,1,40.50);
insert into SaleItem values(165,4,1,99.00);
insert into SaleItem values(165,11,1,27.00);
insert into SaleItem values(165,31,1,7.65);
insert into SaleItem values(165,32,1,10.80);
insert into SaleItem values(165,36,2,19.80);
insert into SaleItem values(167,10,2,14.40);
insert into SaleItem values(167,33,2,13.50);
insert into SaleItem values(167,36,1,19.80);
insert into SaleItem values(168,4,1,99.00);
insert into SaleItem values(170,11,1,27.00);
insert into SaleItem values(170,32,1,10.80);
insert into SaleItem values(170,36,1,19.80);
insert into SaleItem values(172,7,1,14.40);
insert into SaleItem values(172,16,1,2.70);
insert into SaleItem values(172,34,1,18.00);
insert into SaleItem values(172,36,1,19.80);
insert into SaleItem values(174,20,1,9.00);
insert into SaleItem values(174,23,1,67.50);
insert into SaleItem values(176,5,1,22.50);
insert into SaleItem values(176,18,10,0.90);
insert into SaleItem values(176,38,1,7.20);
insert into SaleItem values(177,17,10,0.45);
insert into SaleItem values(177,21,1,22.50);
insert into SaleItem values(177,39,1,7.20);
insert into SaleItem values(178,11,2,27.00);
insert into SaleItem values(179,2,1,58.50);
insert into SaleItem values(179,15,20,0.36);
insert into SaleItem values(180,18,15,0.90);
insert into SaleItem values(180,20,2,9.00);
insert into SaleItem values(180,29,2,5.40);
insert into SaleItem values(181,24,1,135.00);
insert into SaleItem values(181,25,6,2.70);
insert into SaleItem values(181,27,1,31.50);
insert into SaleItem values(182,17,20,0.45);
insert into SaleItem values(182,36,1,19.80);
insert into SaleItem values(183,7,1,3.60);
insert into SaleItem values(183,10,2,14.40);
insert into SaleItem values(183,30,1,6.30);
insert into SaleItem values(184,6,1,31.50);
insert into SaleItem values(184,18,30,0.90);
insert into SaleItem values(184,25,5,2.70);
insert into SaleItem values(185,3,1,76.50);
insert into SaleItem values(185,11,4,27.00);
insert into SaleItem values(186,23,1,67.50);
insert into SaleItem values(186,26,1,5.40);
insert into SaleItem values(186,27,1,31.50);
insert into SaleItem values(186,28,1,22.50);
insert into SaleItem values(187,5,5,22.50);
insert into SaleItem values(187,18,50,0.90);
insert into SaleItem values(188,4,1,58.50);
insert into SaleItem values(188,11,6,27.00);
insert into SaleItem values(188,16,25,0.72);
insert into SaleItem values(189,17,30,0.45);
insert into SaleItem values(189,22,2,67.50);
insert into SaleItem values(190,4,1,99.00);
insert into SaleItem values(190,16,20,0.72);
insert into SaleItem values(190,18,30,0.90);
insert into SaleItem values(191,6,1,31.50);
insert into SaleItem values(191,18,20,0.90);
insert into SaleItem values(191,19,3,7.20);
insert into SaleItem values(192,3,1,76.50);
insert into SaleItem values(192,7,4,3.60);
insert into SaleItem values(192,11,4,27.00);
insert into SaleItem values(193,6,1,31.50);
insert into SaleItem values(193,8,1,2.70);
insert into SaleItem values(194,14,3,16.20);
insert into SaleItem values(194,29,2,5.40);
insert into SaleItem values(194,40,1,13.50);
insert into SaleItem values(195,1,1,40.50);
insert into SaleItem values(195,2,1,58.50);
insert into SaleItem values(195,31,1,7.65);
insert into SaleItem values(196,5,1,22.50);
insert into SaleItem values(196,17,10,0.45);
insert into SaleItem values(197,38,1,7.20);
insert into SaleItem values(198,1,3,0.00);
insert into SaleItem values(198,2,1,0.00);
insert into SaleItem values(198,3,4,0.00);
commit;