INSERT INTO patient VALUES (1, 'Lucy', 'BGL', 13, 28);
INSERT INTO patient VALUES (2, 'Happy', 'GSH', 23, 80);
INSERT INTO patient VALUES (3, 'Fido', 'BAS', 14, 50);
INSERT INTO patient VALUES (4, 'Diamond', 'BGL', 13, 22);
INSERT INTO patient VALUES (5, 'Star', 'DCH', 7, 18);
INSERT INTO patient VALUES (6, 'Oliver', 'BAS', 14, 57);
INSERT INTO patient VALUES (7, 'Moses', 'CAN', 13, 20);
INSERT INTO patient VALUES (8, 'Moon', 'DCH', 8, 19);



INSERT INTO breed VALUES ('BGL', 'Beagle', 'Hounds',  18, 30, 11, 13);
INSERT INTO breed VALUES ('BAS', 'Basset Hound', 'Hounds',  40, 60, 14, 14);
INSERT INTO breed VALUES ('BCL', 'Bearded Collie', 'Herding',  45, 55, 20, 22);
INSERT INTO breed VALUES ('CAN', 'Canaan Dog', 'Herding',  35, 55, 19, 24);
INSERT INTO breed VALUES ('DCH', 'Dachshund', 'Hounds',  11, 32, 5, 9);
INSERT INTO breed VALUES ('GSH', 'German Shepherd', 'Herding',  75, 95, 22, 26);