people-and-pets.sql

CREATE TABLE people
(
    id         INTEGER AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(255),
    last_name  VARCHAR(255),
    age        INTEGER,
    email      VARCHAR(255)
);

CREATE TABLE pets
(
    id       INTEGER AUTO_INCREMENT PRIMARY KEY,
    name     VARCHAR(255),
    type     VARCHAR(255),
    owner_id INTEGER
);

CREATE TABLE toys
(
    id     INTEGER AUTO_INCREMENT PRIMARY KEY,
    brand  VARCHAR(255),
    pet_id INTEGER
);

INSERT INTO people (id, first_name, last_name, email, age)
VALUES (1, 'Barry', 'Willatts', '[email protected]', 23),
       (2, 'Shalom', 'Deshorts', '[email protected]', 12),
       (3, 'Inge', 'Lowis', '[email protected]', 96),
       (4, 'Ailsun', 'Matitiaho', '[email protected]', 11),
       (5, 'Noll', 'Arrell', '[email protected]', 25),
       (6, 'Penny', 'Danilchev', '[email protected]', 3),
       (7, 'Harmony', 'McBay', '[email protected]', 20),
       (8, 'Berton', 'Dwane', '[email protected]', 57),
       (9, 'Livia', 'Ceyssen', '[email protected]', 3),
       (10, 'Jamison', 'Burg', '[email protected]', 76),
       (11, 'Freeland', 'Stringman', '[email protected]', 10),
       (12, 'Hilary', 'Feckey', '[email protected]', 82),
       (13, 'Mirabella', 'Blondin', '[email protected]', 77),
       (14, 'Dionisio', 'Issard', '[email protected]', 50),
       (15, 'Rory', 'Blaasch', '[email protected]', 44),
       (16, 'Catherina', 'Boor', '[email protected]', 69),
       (17, 'Bibbie', 'Vaud', '[email protected]', 12),
       (18, 'Molly', 'Ekins', '[email protected]', 44),
       (19, 'Trace', 'Boatwright', '[email protected]', 62),
       (20, 'Shaun', 'Baptiste', '[email protected]', 42),
       (21, 'Dinah', 'Hesse', '[email protected]', 72),
       (22, 'Coop', 'Robley', '[email protected]', 87),
       (23, 'Isabella', 'Pawden', '[email protected]', 28),
       (24, 'Tate', 'Gentzsch', '[email protected]', 90),
       (25, 'Lovell', 'Ducker', '[email protected]', 98),
       (26, 'Emile', 'Harkess', '[email protected]', 64),
       (27, 'Correna', 'Carlsen', '[email protected]', 69),
       (28, 'Sheena', 'Burrage', '[email protected]', 25),
       (29, 'Carley', 'Woffenden', '[email protected]', 7),
       (30, 'Arda', 'Fishleigh', '[email protected]', 3),
       (31, 'Dalston', 'Wadeling', '[email protected]', 24),
       (32, 'Danya', 'Cornejo', '[email protected]', 71),
       (33, 'Allison', 'Wellard', '[email protected]', 18),
       (34, 'Faulkner', 'Sarjent', '[email protected]', 8),
       (35, 'Yolanda', 'McQuaker', '[email protected]', 42),
       (36, 'Editha', 'Kyme', '[email protected]', 15),
       (37, 'Seumas', 'Jori', '[email protected]', 91),
       (38, 'Emmeline', 'Surplice', '[email protected]', 61),
       (39, 'Idell', 'Teese', '[email protected]', 77),
       (40, 'Jarret', 'Brewitt', '[email protected]', 55),
       (41, 'Arel', 'Montilla', '[email protected]', 80),
       (42, 'Etan', 'Suscens', '[email protected]', 49),
       (43, 'Eberhard', 'Arnhold', '[email protected]', 89),
       (44, 'Isaak', 'Rives', '[email protected]', 58),
       (45, 'Walden', 'Tchir', '[email protected]', 66),
       (46, 'Levon', 'Scutts', '[email protected]', 78),
       (47, 'Nils', 'Govier', '[email protected]', 87),
       (48, 'Laurene', 'Penwright', '[email protected]', 22),
       (49, 'Emory', 'Pickwell', '[email protected]', 30);

INSERT INTO pets (name, type, owner_id)
VALUES ('Cocoa', 'Alligator, american', 49),
       ('Silly', 'Horned rattlesnake', 1),
       ('Cyrus', 'Fox, arctic', 24),
       ('Stoli', 'Western pygmy possum', 17),
       ('Samantha', 'Kangaroo, red', 4),
       ('Murdoc', 'Common waterbuck', 32),
       ('Rex', 'White-tailed deer', 2),
       ('Mozart', 'Paddy heron (unidentified)', 29),
       ('Hansel', 'Snake, tiger', 32),
       ('Artak', 'Darwin ground finch (unidentified)', 49),
       ('Topaz', 'Giant anteater', 15),
       ('Amber', 'Sloth bear', 32),
       ('Ramone', 'Wallaby, bennett''s', 11),
       ('Unit', 'Squirrel, nelson ground', 16),
       ('Arctic', 'Hornbill, southern ground', 38),
       ('Chewbacca', 'Lemur, sportive', 28),
       ('Fuzzbucket', 'Sandhill crane', 26),
       ('Kelso', 'Cardinal, black-throated', 14),
       ('Frasier', 'Woodrat (unidentified)', 44),
       ('Zelda', 'Crested porcupine', 22),
       ('Ion', 'Springbuck', 33),
       ('Holy', 'Parrot, hawk-headed', 27),
       ('Fuzzy', 'Snake, eastern indigo', 46),
       ('Frosty', 'Langur, hanuman', 34),
       ('Hero', 'Woodchuck', 26),
       ('Buck', 'Harbor seal', 41),
       ('Finnegan', 'Zebra, plains', 26),
       ('Flea', 'Black swan', 19),
       ('Raisin', 'Woodpecker, downy', 5),
       ('Slinky', 'European beaver', 5),
       ('Zippy', 'Dark-winged trumpeter', 18),
       ('Aretha', 'Emerald-spotted wood dove', 40),
       ('Grizzly', 'Dusky rattlesnake', 30),
       ('Hemp', 'Canada goose', 24),
       ('Fido', 'African buffalo', 16),
       ('Wheeler', 'Parrot, hawk-headed', 7),
       ('Hades', 'Steller sea lion', 13);

INSERT INTO toys (id, brand, pet_id)
VALUES (1, 'Kong', 35),
       (2, 'Kong', 16),
       (3, 'Benebone', 33),
       (4, 'Outward Hound', 6),
       (5, 'Outward Hound', 22),
       (6, 'Benebone', 15),
       (7, 'Westpaw', 4),
       (8, 'Chuckit!', 3),
       (9, 'Kong', 33),
       (10, 'Kong', 45),
       (11, 'Chuckit!', 5),
       (12, 'Outward Hound', 34),
       (13, 'Benebone', 29),
       (14, 'Benebone', 39),
       (15, 'Chuckit!', 25),
       (16, 'Chuckit!', 31),
       (17, 'Benebone', 17),
       (18, 'Benebone', 16),
       (19, 'Kong', 18),
       (20, 'Benebone', 5),
       (21, 'Westpaw', 47),
       (22, 'Kong', 8),
       (23, 'Benebone', 40),
       (24, 'Westpaw', 24),
       (25, 'Benebone', 8),
       (26, 'Westpaw', 47),
       (27, 'Chuckit!', 1),
       (28, 'Benebone', 6),
       (29, 'Outward Hound', 43),
       (30, 'Outward Hound', 43),
       (31, 'Kong', 16),
       (32, 'Benebone', 31),
       (33, 'Outward Hound', 26),
       (34, 'Outward Hound', 34),
       (35, 'Westpaw', 44),
       (36, 'Kong', 29),
       (37, 'Chuckit!', 14),
       (38, 'Outward Hound', 25),
       (39, 'Benebone', 27),
       (40, 'Benebone', 10),
       (41, 'Westpaw', 44),
       (42, 'Westpaw', 4),
       (43, 'Kong', 20),
       (44, 'Chuckit!', 22),
       (45, 'Outward Hound', 48),
       (46, 'Westpaw', 34),
       (47, 'Chuckit!', 34),
       (48, 'Kong', 35),
       (49, 'Outward Hound', 28),
       (50, 'Chuckit!', 33);