The Questions

You had given list of sql codes to create and insert values in the pet store schema, which contains the table Supplier, Employee, Customer, Animal, Breed, Category, AnimalOrder, AnimalOrderItem, SaleAnimal, City, Merchandise, OrderItem, MerchandiseOrder, SaleItem and Sale.


1. Display the employee detail in the following format

LASTNAME contact number is 0173375067 and is hired on HIRED-DATE.

2. Display the animal’s category uniquely in descending order of their MAX list price

3. List down the animalid, saleprice, cost and loss for each animal sold


4. Display the animal id and colour for each MALE animal expect for male cat and animal that have ‘WHITE’ in their colour

5. How many animals are there in each category? Sort your answer by listing the category with the least animal first.

6. Display maximum price for each category according to their category and colour

7. Display the total of merchandise sale made by each employee in ascending order where the total of merchandise sale is more than 500.

8. Display the animal’s order detail which contains the orderId, order date, cost and animal’s category

9. List down ALL the female animals details that have a higher sale price than the average saleprice.

10. List down the animalId, animal’s name, category and LISTPRICE that are in the same category as ‘ELLA’ and the LISTPRICE is more than ‘ELLA’

Petstore Table Structure

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;