-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathanimals.sql
More file actions
107 lines (107 loc) · 11.8 KB
/
animals.sql
File metadata and controls
107 lines (107 loc) · 11.8 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
use mydb;
create table animals (
id VARCHAR(40),
name VARCHAR(50),
age VARCHAR(2),
price VARCHAR(2)
);
insert into animals (id, name, age, price) values ('a00ce94b-fb44-418e-9ee8-8395bd920848', 'Indian giant squirrel', 5, 50);
insert into animals (id, name, age, price) values ('e54a4d45-defe-4f53-b8a3-b18783b5659b', 'Common brushtail possum', 13, 40);
insert into animals (id, name, age, price) values ('e0442824-1666-4637-9171-57c7a83b4b64', 'Kudu, greater', 5, 50);
insert into animals (id, name, age, price) values ('a33e95f5-f55d-454a-ab4c-12dc3ae6e17a', 'Uinta ground squirrel', 15, 30);
insert into animals (id, name, age, price) values ('35b7ba7a-56b6-45f3-8b3e-835fb22a8991', 'Verreaux''s sifaka', 15, 20);
insert into animals (id, name, age, price) values ('8264a71d-2cbd-4caf-9bb2-d7aace38fc93', 'Owl, madagascar hawk', 9, 60);
insert into animals (id, name, age, price) values ('faf7750d-7c4b-490d-9a08-e995d437e1f3', 'Grebe, little', 5, 60);
insert into animals (id, name, age, price) values ('6e26863e-74b8-4a6d-ab40-0346989245cc', 'Duck, comb', 6, 50);
insert into animals (id, name, age, price) values ('0a75a57f-6a3a-4ba8-a24c-fc35cf007511', 'Aardwolf', 12, 10);
insert into animals (id, name, age, price) values ('897244a6-39ec-4d49-b2a1-cb11a3aa01ab', 'Dromedary camel', 3, 60);
insert into animals (id, name, age, price) values ('da511928-a424-4e07-800e-49607bad0c87', 'Madagascar fruit bat', 2, 30);
insert into animals (id, name, age, price) values ('97ffe49e-8d96-4fdb-83a0-5e4887ff0239', 'Ovenbird', 1, 50);
insert into animals (id, name, age, price) values ('12436e38-cac1-440a-8778-4c6f069dcb24', 'Small Indian mongoose', 14, 40);
insert into animals (id, name, age, price) values ('e3bbfe3c-56af-41a4-9c51-22304357d737', 'Little blue penguin', 8, 20);
insert into animals (id, name, age, price) values ('68103891-4dd4-4e15-bf48-c9600649a04f', 'Sage hen', 2, 60);
insert into animals (id, name, age, price) values ('52d0292f-01a2-437f-bc7c-8f645e18a651', 'Asian lion', 1, 60);
insert into animals (id, name, age, price) values ('19e8d6ac-036d-42c9-80a7-ee4bb9a7938e', 'Desert kangaroo rat', 1, 10);
insert into animals (id, name, age, price) values ('bc057081-2069-4786-9804-9bd9ff947654', 'Skua, long-tailed', 4, 10);
insert into animals (id, name, age, price) values ('92405413-c416-41fe-a057-b7926b273ee1', 'Purple moorhen', 13, 20);
insert into animals (id, name, age, price) values ('0df77658-7879-4ddb-9d52-28492501681e', 'Gazelle, thomson''s', 5, 50);
insert into animals (id, name, age, price) values ('1636d94d-f0c5-4132-a5d9-f7eaf2c3434d', 'Yellow-brown sungazer', 14, 60);
insert into animals (id, name, age, price) values ('4c4c46a3-8f69-46b7-ba4d-fafbc8d6b5be', 'Red-tailed cockatoo', 14, 30);
insert into animals (id, name, age, price) values ('1c05a0ad-e9be-4450-80be-53a0cd780526', 'African porcupine', 2, 50);
insert into animals (id, name, age, price) values ('575fb1db-c0e1-4c45-af46-781ae29d8afa', 'Deer, mule', 13, 40);
insert into animals (id, name, age, price) values ('6a6ee90e-a594-4458-950e-3f5d4ab34932', 'Common raccoon', 5, 10);
insert into animals (id, name, age, price) values ('8182f23f-37f1-495b-bcdc-919f2332209c', 'Goose, canada', 5, 10);
insert into animals (id, name, age, price) values ('8debc816-d226-4974-9de1-01ce5ad399a9', 'Stork, white-necked', 10, 50);
insert into animals (id, name, age, price) values ('ccba21b6-f655-40f3-98e2-325877532701', 'Grey-footed squirrel', 1, 40);
insert into animals (id, name, age, price) values ('3a7e4ae1-17f9-4daf-ac51-cb08f6a10994', 'Springbuck', 7, 20);
insert into animals (id, name, age, price) values ('b1ff7482-5c29-426f-a066-2abb9de1c838', 'Steenbok', 13, 50);
insert into animals (id, name, age, price) values ('b83130c3-3293-40d2-87e3-816c9381447e', 'European beaver', 7, 60);
insert into animals (id, name, age, price) values ('5a58c262-5cf7-4c9a-a0e5-2763fd79c4e6', 'Blackish oystercatcher', 10, 10);
insert into animals (id, name, age, price) values ('93505f9f-7d85-4aaa-b92c-0905c4eaa06a', 'Arctic hare', 3, 50);
insert into animals (id, name, age, price) values ('3ef7ee14-f33a-4cc9-b314-a0f98384319a', 'Whale, baleen', 12, 30);
insert into animals (id, name, age, price) values ('79bb7fb4-0c51-4e91-8cf1-70dc438ed306', 'Fowl, helmeted guinea', 4, 40);
insert into animals (id, name, age, price) values ('4979d49f-d3d5-45e0-b7c1-20e6b2afdc6a', 'Flycatcher, tyrant', 2, 40);
insert into animals (id, name, age, price) values ('681be763-3440-40c7-8fc1-ae59a4d15a3b', 'Oryx, fringe-eared', 1, 10);
insert into animals (id, name, age, price) values ('bca20e45-5efb-4d18-a780-99b211da7835', 'Heron, little', 14, 40);
insert into animals (id, name, age, price) values ('204cd034-23da-41a3-9b01-a075ebd414f0', 'European badger', 9, 40);
insert into animals (id, name, age, price) values ('79e2061a-9e41-440b-9413-ae213774519b', 'White-browed sparrow weaver', 8, 20);
insert into animals (id, name, age, price) values ('2729c1ce-1b56-4e39-ba8b-3164ad8a1037', 'Frilled lizard', 6, 10);
insert into animals (id, name, age, price) values ('bf14c442-e46e-4920-bdb8-dca7f60ce972', 'Crab, sally lightfoot', 10, 50);
insert into animals (id, name, age, price) values ('c5743bb3-778d-46c8-a04d-a7ff94ee968c', 'Grey mouse lemur', 1, 20);
insert into animals (id, name, age, price) values ('d0fddc63-c5be-48a1-89de-18d2afd33df7', 'Fork-tailed drongo', 10, 20);
insert into animals (id, name, age, price) values ('e7c2a4b7-e7a8-4b58-b0eb-2294ecff2ece', 'Green-winged trumpeter', 2, 50);
insert into animals (id, name, age, price) values ('7df93b77-0a68-4682-93a0-4c7ac36db572', 'Emerald green tree boa', 7, 60);
insert into animals (id, name, age, price) values ('d1164430-8f22-4311-9ffa-a94c2a3391fa', 'Red meerkat', 10, 60);
insert into animals (id, name, age, price) values ('345f8e89-50ef-45f2-81c9-c4652ab80223', 'Long-billed cockatoo', 10, 50);
insert into animals (id, name, age, price) values ('0ea2c5b6-5a70-46b3-96e2-fa83ffef70b7', 'Owl, snowy', 4, 30);
insert into animals (id, name, age, price) values ('bf0b40f5-19f7-4214-ba81-a0314616fae5', 'Badger, american', 1, 60);
insert into animals (id, name, age, price) values ('90fb8029-7b05-4bab-82ee-6db29e865e39', 'Lark, horned', 10, 10);
insert into animals (id, name, age, price) values ('c67b8215-ecb6-45c1-a391-0a353730ba49', 'Monkey, vervet', 6, 40);
insert into animals (id, name, age, price) values ('185e4c30-1de7-4ed4-a602-7ba6bdc08620', 'Turkey, wild', 5, 10);
insert into animals (id, name, age, price) values ('94431cbe-7f38-4f21-8749-b54d89d602e8', 'Fox, silver-backed', 13, 50);
insert into animals (id, name, age, price) values ('cb8969c1-4ec5-4f84-8f8e-f36240563846', 'African skink', 1, 40);
insert into animals (id, name, age, price) values ('7ae25b3f-449d-4110-a675-6d4ec688554d', 'White-necked raven', 14, 30);
insert into animals (id, name, age, price) values ('526e52ee-81d3-4fcc-b052-bd4cf42a743b', 'Cape fox', 11, 60);
insert into animals (id, name, age, price) values ('11bfd127-2aab-4292-8198-333eb53b4e4c', 'Genet, common', 10, 10);
insert into animals (id, name, age, price) values ('30746175-5c09-463c-a93c-45142f515c5d', 'Sandgrouse, yellow-throated', 15, 50);
insert into animals (id, name, age, price) values ('19f3e351-fc0b-43ef-8808-77cd12662b83', 'Trotter, lily', 2, 50);
insert into animals (id, name, age, price) values ('ac618e9b-7cf0-47e1-8592-46c368963f0f', 'Sheep, american bighorn', 8, 40);
insert into animals (id, name, age, price) values ('5a990677-1fa5-485b-ae8a-306084c7c87f', 'Pelican, great white', 13, 20);
insert into animals (id, name, age, price) values ('7361904e-97bd-4d04-bc72-6886c05ade3e', 'Pygmy possum', 9, 20);
insert into animals (id, name, age, price) values ('3c57a686-aa47-4355-9fd7-2d6de745b78b', 'Egret, snowy', 14, 50);
insert into animals (id, name, age, price) values ('50bdc7a7-5ee6-4a4e-8a66-18dfb2e85929', 'Trotter, lily', 8, 30);
insert into animals (id, name, age, price) values ('fb8f0621-7df2-4046-bcc8-ee4210a91bba', 'Coyote', 8, 40);
insert into animals (id, name, age, price) values ('84f7207d-5936-4f7d-b5bd-f279016026df', 'Fox, crab-eating', 6, 60);
insert into animals (id, name, age, price) values ('2e3a8077-a99e-478a-b1e1-a566157ca29f', 'Rhinoceros, white', 15, 40);
insert into animals (id, name, age, price) values ('c020c8dc-3552-495f-bec6-456c90ffcb1b', 'Legaan, water', 15, 30);
insert into animals (id, name, age, price) values ('243894d8-86db-4fe5-8e82-fcb81b8d5033', 'Bulbul, african red-eyed', 10, 50);
insert into animals (id, name, age, price) values ('4a41789d-9c8e-4997-b6d6-cc77de010e93', 'Hawk, red-tailed', 7, 60);
insert into animals (id, name, age, price) values ('9ced9fe2-bb4f-41f1-aa69-f219f8565afe', 'Verreaux''s sifaka', 2, 40);
insert into animals (id, name, age, price) values ('0f863470-3266-4f73-8ab8-4869ef4f5f97', 'Wallaby, euro', 12, 10);
insert into animals (id, name, age, price) values ('5d7bc1cf-4f77-407a-91e3-fa00ce1b7cc2', 'Sable antelope', 10, 10);
insert into animals (id, name, age, price) values ('6356bc3d-83f1-4b96-9157-26e1b4573982', 'Turkey, common', 7, 40);
insert into animals (id, name, age, price) values ('b6c865a3-ade4-42ff-8a3c-35c60210391e', 'Fox, bat-eared', 3, 10);
insert into animals (id, name, age, price) values ('6d8884f1-bab4-4006-8836-13bda220c57b', 'Racer, american', 12, 20);
insert into animals (id, name, age, price) values ('039c2cfa-1164-4cda-afdb-4b4ba9e12bf0', 'Crow, house', 1, 50);
insert into animals (id, name, age, price) values ('c8df17e8-0a1b-415a-9d39-a98827611030', 'Water monitor', 5, 40);
insert into animals (id, name, age, price) values ('310ab25f-793e-481c-8af2-094754bbc5b5', 'Squirrel, uinta ground', 2, 60);
insert into animals (id, name, age, price) values ('4a108e2c-39f7-437f-b4d3-b5ccbc8befc3', 'Turtle (unidentified)', 15, 10);
insert into animals (id, name, age, price) values ('bcc22bea-4527-4ad7-9543-501c6ec6ebee', 'Long-nosed bandicoot', 12, 30);
insert into animals (id, name, age, price) values ('a8ac9d04-09b7-494c-9c6c-e01ec2863ddd', 'Bear, grizzly', 9, 20);
insert into animals (id, name, age, price) values ('25152754-231b-4cda-89dd-10367ac54665', 'Grenadier, common', 6, 10);
insert into animals (id, name, age, price) values ('26692b36-2c7e-47ab-912b-dc7ead00b3fc', 'Red-headed woodpecker', 8, 20);
insert into animals (id, name, age, price) values ('8ddd8ef3-d239-4c38-9a4f-b0768d0df85e', 'Indian peacock', 13, 10);
insert into animals (id, name, age, price) values ('5edfeb81-22be-4d79-af5e-495940125d6e', 'Brush-tailed phascogale', 7, 60);
insert into animals (id, name, age, price) values ('7f398d39-eed7-4176-9bf4-bcde3e2076d1', 'Armadillo, common long-nosed', 1, 30);
insert into animals (id, name, age, price) values ('a0eb53ef-db6b-4f03-aa2a-31ab8a4b8374', 'Stilt, black-winged', 11, 10);
insert into animals (id, name, age, price) values ('b66bd78f-f1d2-4222-90a9-bb0a74289289', 'White-bellied sea eagle', 14, 30);
insert into animals (id, name, age, price) values ('0776e707-8fcb-4a41-9fbe-17d2ba09a15a', 'Bee-eater, carmine', 1, 10);
insert into animals (id, name, age, price) values ('5e9e1a1d-de96-4428-9537-ecea7c1fd330', 'Australian masked owl', 3, 30);
insert into animals (id, name, age, price) values ('75ec5f31-c166-45dd-ba3d-76930be50e86', 'Sally lightfoot crab', 14, 50);
insert into animals (id, name, age, price) values ('08eebcb2-daee-4cb3-8324-a1362c711d63', 'Boar, wild', 3, 40);
insert into animals (id, name, age, price) values ('05ef27fa-33a7-491b-aa77-fcf41ff6bc56', 'Cormorant (unidentified)', 1, 60);
insert into animals (id, name, age, price) values ('67a11370-9b8a-4563-bed6-3ee51a616ee0', 'Lemming, arctic', 12, 30);
insert into animals (id, name, age, price) values ('99f3d578-d21d-44b4-9a61-7567b7810358', 'Duck, blue', 4, 20);
insert into animals (id, name, age, price) values ('85ab6df6-2c5a-49ce-904d-1410241f8544', 'Rufous tree pie', 9, 20);
insert into animals (id, name, age, price) values ('4dc7c2dd-dbcd-405e-9bc5-41a94655bbee', 'Hawk-eagle, crowned', 10, 20);
insert into animals (id, name, age, price) values ('c00d0464-02e0-4734-a102-515f398b825a', 'Green-backed heron', 2, 30);