CREATE TABLE dogs (
  dog_id integer primary key autoincrement,
  breed varchar(50) DEFAULT NULL,
  type varchar(30) DEFAULT NULL,
  max_height int DEFAULT NULL,
  max_weight int DEFAULT NULL,
  max_life_span int DEFAULT NULL,
  general_health varchar(30) DEFAULT NULL,
  friendly varchar(10) DEFAULT NULL
);
INSERT INTO dogs VALUES(1,'Chinese Shar-Pei','Working Dogs',20,55,12,'Poor','Rarely');
INSERT INTO dogs VALUES(2,'Italian Greyhound','Companion',15,15,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(3,'Irish Water Spaniel','Sporting Dogs',24,65,12,'Very Good','Usually');
INSERT INTO dogs VALUES(4,'Sussex Spaniel','Sporting Dogs',15,45,14,'Excellent','Always');
INSERT INTO dogs VALUES(5,'Affenpinscher','Companion',11,9,14,'Very Good','Sometimes');
INSERT INTO dogs VALUES(6,'American Eskimo','Companion',19,30,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(7,'Bichon Frise','Companion',11,12,15,'Fairly Good','Always');
INSERT INTO dogs VALUES(8,'Bolognese','Companion',12,14,14,'Excellent','Sometimes');
INSERT INTO dogs VALUES(9,'Boston Terrier','Companion',15,25,15,'Excellent','Usually');
INSERT INTO dogs VALUES(10,'Brussels Griffon','Companion',8,12,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(11,'Bulldog','Companion',15,50,12,'Poor','Always');
INSERT INTO dogs VALUES(12,'Cavalier King Charles Spaniel','Companion',13,18,15,'Fairly Good','Always');
INSERT INTO dogs VALUES(13,'Chihuahua','Companion',9,6,18,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(14,'Chinese Crested','Companion',13,12,14,'Fairly Good','Usually');
INSERT INTO dogs VALUES(15,'Coton de Tulear','Companion',12,13,14,'Excellent','Always');
INSERT INTO dogs VALUES(16,'Dalmatian','Companion',24,55,16,'Poor','Sometimes');
INSERT INTO dogs VALUES(17,'English Toy Spaniel','Companion',11,14,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(18,'French Bulldog','Companion',12,28,14,'Poor','Usually');
INSERT INTO dogs VALUES(19,'Havanese','Companion',11,13,15,'Fairly Good','Always');
INSERT INTO dogs VALUES(20,'Japanese Chin','Companion',11,9,14,'Poor','Usually');
INSERT INTO dogs VALUES(21,'Keeshond','Companion',19,45,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(22,'Lhasa Apso','Companion',11,15,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(23,'Lowchen','Companion',14,18,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(24,'Maltese','Companion',10,7,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(25,'Miniature Pinscher','Companion',12,11,14,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(26,'Papillon','Companion',11,9,16,'Fairly Good','Always');
INSERT INTO dogs VALUES(27,'Pekingese','Companion',9,14,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(28,'Pomeranian','Companion',12,7,16,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(29,'Poodle','Companion',10,70,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(30,'Pug','Companion',14,18,15,'Poor','Usually');
INSERT INTO dogs VALUES(31,'Schipperke','Companion',15,18,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(32,'Shiba Inu','Companion',17,23,16,'Very Good','Rarely');
INSERT INTO dogs VALUES(33,'Shih Tzu','Companion',10,16,15,'Fairly Good','Always');
INSERT INTO dogs VALUES(34,'Silky Terrier','Companion',10,10,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(35,'Tibetan Spaniel','Companion',10,15,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(36,'Tibetan Terrier','Companion',16,24,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(37,'Toy Fox Terrier','Companion',11,7,14,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(38,'Xoloitzuintli','Companion',23,50,20,'Excellent','Rarely');
INSERT INTO dogs VALUES(39,'Yorkshire Terrier','Companion',9,6,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(40,'Appenzeller Sennenhunde','Herding Dogs',22,55,12,'Very Good','Rarely');
INSERT INTO dogs VALUES(41,'Australian Cattle Dog','Herding Dogs',20,50,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(42,'Australian Shepherd','Herding Dogs',23,65,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(43,'Bearded Collie','Herding Dogs',22,55,14,'Fairly Good','Usually');
INSERT INTO dogs VALUES(44,'Belgian Malinois','Herding Dogs',26,80,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(45,'Belgian Sheepdog','Herding Dogs',26,75,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(46,'Belgian Tervuren','Herding Dogs',26,70,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(47,'Berger Picard','Herding Dogs',25,70,14,'Very Good','Rarely');
INSERT INTO dogs VALUES(48,'Border Collie','Herding Dogs',22,45,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(49,'Bouvier des Flandres','Herding Dogs',28,100,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(50,'Briard','Herding Dogs',27,100,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(51,'Cannan Dog','Herding Dogs',24,55,15,'Very Good','Rarely');
INSERT INTO dogs VALUES(52,'Cardigan Welsh Corgi','Herding Dogs',12,38,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(53,'Catahoula Leopard Dog','Herding Dogs',26,90,14,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(54,'Collie','Herding Dogs',26,70,14,'Poor','Usually');
INSERT INTO dogs VALUES(55,'Entlebucher Mountain Dog','Herding Dogs',20,65,13,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(56,'Finnish Laphund','Herding Dogs',20,53,15,'Very Good','Sometimes');
INSERT INTO dogs VALUES(57,'German Shepherd','Herding Dogs',26,95,14,'Poor','Rarely');
INSERT INTO dogs VALUES(58,'Icelandic Sheepdog','Herding Dogs',18,30,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(59,'Lancashire Heeler','Herding Dogs',12,15,14,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(60,'Norwegian Buhund','Herding Dogs',18,40,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(61,'Old English Sheepdog','Herding Dogs',21,85,12,'Fairly Good','Usually');
INSERT INTO dogs VALUES(62,'Pembroke Welsh Corgi','Herding Dogs',12,30,14,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(63,'Polish Lowland Sheepdog','Herding Dogs',20,55,12,'Very Good','Sometimes');
INSERT INTO dogs VALUES(64,'Puli','Herding Dogs',17,35,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(65,'Pyrenean Shepherd','Herding Dogs',21,30,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(66,'Shetland Sheepdog','Herding Dogs',16,20,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(67,'Swedish Wallhund','Herding Dogs',13,35,15,'Very Good','Always');
INSERT INTO dogs VALUES(68,'Afghan Hound','Hounds',28,60,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(69,'American English Coonhound','Hounds',26,65,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(70,'American Foxhound','Hounds',25,60,13,'Very Good','Sometimes');
INSERT INTO dogs VALUES(71,'Azawakh','Hounds',29,55,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(72,'Basenji','Hounds',17,24,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(73,'Basset Hound','Hounds',14,65,12,'Poor','Usually');
INSERT INTO dogs VALUES(74,'Beagle','Hounds',15,30,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(75,'Black & Tan Coonhound','Hounds',27,100,12,'Excellent','Usually');
INSERT INTO dogs VALUES(76,'Bloodhound','Hounds',27,110,10,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(77,'Bluetick Coonhound','Hounds',30,100,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(78,'Borzoi','Hounds',32,105,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(79,'Dachshund','Hounds',9,32,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(80,'English Foxhound','Hounds',27,75,13,'Very Good','Usually');
INSERT INTO dogs VALUES(81,'Greyhound','Hounds',30,85,15,'Fairly Good','Always');
INSERT INTO dogs VALUES(82,'Harrier','Hounds',21,60,12,'Very Good','Sometimes');
INSERT INTO dogs VALUES(83,'Ibizan Hound','Hounds',27,50,14,'Very Good','Sometimes');
INSERT INTO dogs VALUES(84,'Irish Wolfhound','Hounds',35,180,8,'Poor','Usually');
INSERT INTO dogs VALUES(85,'Norwegian Elkhound','Hounds',20,48,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(86,'Otterhound','Hounds',27,80,12,'Fairly Good','Usually');
INSERT INTO dogs VALUES(87,'Pettit Basset Griffon Vendeen','Hounds',15,40,14,'Fairly Good','Always');
INSERT INTO dogs VALUES(88,'Pharaoh Hound','Hounds',25,55,14,'Very Good','Rarely');
INSERT INTO dogs VALUES(89,'Plott','Hounds',27,75,14,'Very Good','Sometimes');
INSERT INTO dogs VALUES(90,'Pocket Beagle','Hounds',12,15,10,'Poor','Usually');
INSERT INTO dogs VALUES(91,'Redbone Coonhound','Hounds',27,70,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(92,'Rhodesian Ridgeback','Hounds',28,85,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(93,'Saluki','Hounds',28,70,14,'Very Good','Rarely');
INSERT INTO dogs VALUES(94,'Scottish Deerhound','Hounds',32,110,11,'Fairly Good','Usually');
INSERT INTO dogs VALUES(95,'Sloughi','Hounds',29,63,16,'Very Good','Rarely');
INSERT INTO dogs VALUES(96,'Treeing Tennessee Brindle','Hounds',24,45,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(97,'Treeing Walker Coonhound','Hounds',27,80,13,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(98,'Whippet','Hounds',22,48,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(99,'Cockapoo','Hybrid Dogs',15,19,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(100,'Goldador','Hybrid Dogs',24,80,15,'Very Good','Always');
INSERT INTO dogs VALUES(101,'Goldendoodle','Hybrid Dogs',24,90,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(102,'Labradoodle','Hybrid Dogs',24,65,14,'Very Good','Always');
INSERT INTO dogs VALUES(103,'Maltese Shih Tzu','Hybrid Dogs',10,12,14,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(104,'Maltipoo','Hybrid Dogs',14,20,13,'Fairly Good','Usually');
INSERT INTO dogs VALUES(105,'Peekapoo','Hybrid Dogs',11,20,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(106,'Puggle','Hybrid Dogs',15,30,15,'Very Good','Usually');
INSERT INTO dogs VALUES(107,'Scnoodle','Hybrid Dogs',26,75,15,'Very Good','Sometimes');
INSERT INTO dogs VALUES(108,'Yorkipoo','Hybrid Dogs',15,14,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(109,'American Water Spaniel','Sporting Dogs',18,45,15,'Very Good','Sometimes');
INSERT INTO dogs VALUES(110,'Barbet','Sporting Dogs',25,62,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(111,'Boykin Spaniel','Sporting Dogs',18,40,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(112,'Bracco Italiano','Sporting Dogs',26,88,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(113,'Brittany','Sporting Dogs',20,40,13,'Fairly Good','Usually');
INSERT INTO dogs VALUES(114,'Chesapeake Bay Retriever','Sporting Dogs',26,80,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(115,'Clumber Spaniel','Sporting Dogs',20,85,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(116,'Cocker Spaniel','Sporting Dogs',15,28,15,'Poor','Sometimes');
INSERT INTO dogs VALUES(117,'Curly-Coated Retriever','Sporting Dogs',27,100,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(118,'English Cocker Spaniel','Sporting Dogs',17,34,14,'Fairly Good','Usually');
INSERT INTO dogs VALUES(119,'English Setter','Sporting Dogs',27,80,12,'Fairly Good','Always');
INSERT INTO dogs VALUES(120,'English Springer Spaniel','Sporting Dogs',22,55,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(121,'Field Spaniel','Sporting Dogs',19,45,12,'Very Good','Sometimes');
INSERT INTO dogs VALUES(122,'Finnish Spitz','Sporting Dogs',20,35,15,'Very Good','Rarely');
INSERT INTO dogs VALUES(123,'Flat-Coated Retriever','Sporting Dogs',24,70,12,'Fairly Good','Always');
INSERT INTO dogs VALUES(124,'German Shorthaired Pointer','Sporting Dogs',25,70,12,'Fairly Good','Usually');
INSERT INTO dogs VALUES(125,'German Wirehaired Pointer','Sporting Dogs',26,70,14,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(126,'Golden Retriever','Sporting Dogs',24,75,12,'Fairly Good','Always');
INSERT INTO dogs VALUES(127,'Gordon Setter','Sporting Dogs',15,80,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(128,'Irish Red & White Setter','Sporting Dogs',26,70,14,'Very Good','Usually');
INSERT INTO dogs VALUES(129,'Irish Setter','Sporting Dogs',15,70,15,'Fairly Good','Always');
INSERT INTO dogs VALUES(130,'Kooikerhondje','Sporting Dogs',16,25,14,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(131,'Labrador Retriever','Sporting Dogs',24,80,12,'Fairly Good','Always');
INSERT INTO dogs VALUES(132,'Nova Scotia Duck Tolling Retriever','Sporting Dogs',21,50,14,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(133,'Pointer','Sporting Dogs',28,75,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(134,'Small Munsterlander Pointer','Sporting Dogs',22,60,14,'Very Good','Usually');
INSERT INTO dogs VALUES(135,'Stabyhoun','Sporting Dogs',20,50,14,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(136,'Vizsla','Sporting Dogs',24,65,14,'Fairly Good','Always');
INSERT INTO dogs VALUES(137,'Weimaraner','Sporting Dogs',27,85,13,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(138,'Welsh Springer Spaniel','Sporting Dogs',19,55,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(139,'Wirehaired Pointing Griffon','Sporting Dogs',24,60,14,'Very Good','Sometimes');
INSERT INTO dogs VALUES(140,'Airedale Terrier','Terriers',23,65,13,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(141,'American Pit Bull','Terriers',19,85,16,'Very Good','Usually');
INSERT INTO dogs VALUES(142,'Australian Terrier','Terriers',11,16,15,'Very Good','Sometimes');
INSERT INTO dogs VALUES(143,'Bedlington Terrier','Terriers',16,23,16,'Fairly Good','Usually');
INSERT INTO dogs VALUES(144,'Border Terrier','Terriers',11,15,15,'Very Good','Sometimes');
INSERT INTO dogs VALUES(145,'Bull Terrier','Terriers',22,75,15,'Fairly Good','Always');
INSERT INTO dogs VALUES(146,'Cairn Terrier','Terriers',10,14,15,'Very Good','Sometimes');
INSERT INTO dogs VALUES(147,'Cesky Terrier','Terriers',13,30,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(148,'Dandle Denmont Terrier','Terriers',11,24,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(149,'Fox Terrier','Terriers',15,19,15,'Very Good','Sometimes');
INSERT INTO dogs VALUES(150,'Glen of Imaal Terrier','Terriers',14,35,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(151,'Irish Terrier','Terriers',20,27,16,'Very Good','Sometimes');
INSERT INTO dogs VALUES(152,'Jack Russell Terrier','Terriers',15,17,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(153,'Kerry Blue Terrier','Terriers',19,40,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(154,'Lakeland Terrier','Terriers',14,17,15,'Very Good','Sometimes');
INSERT INTO dogs VALUES(155,'Manchester Terrier','Terriers',16,22,16,'Very Good','Sometimes');
INSERT INTO dogs VALUES(156,'Miniature Schnauzer','Terriers',14,20,14,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(157,'Norfolk Terrier','Terriers',10,12,15,'Very Good','Usually');
INSERT INTO dogs VALUES(158,'Norwich Terrier','Terriers',10,12,14,'Very Good','Usually');
INSERT INTO dogs VALUES(159,'Rat Terrier','Terriers',16,25,18,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(160,'Scottish Terrier','Terriers',10,22,13,'Very Good','Sometimes');
INSERT INTO dogs VALUES(161,'Sealyham Terrier','Terriers',10,24,14,'Very Good','Rarely');
INSERT INTO dogs VALUES(162,'Skye Terrier','Terriers',10,40,14,'Excellent','Rarely');
INSERT INTO dogs VALUES(163,'Soft-Coated Wheaten Terrier','Terriers',19,40,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(164,'Staffordshire Bull Terrier','Terriers',16,38,14,'Fairly Good','Always');
INSERT INTO dogs VALUES(165,'Welsh Terrier','Terriers',15,20,14,'Very Good','Sometimes');
INSERT INTO dogs VALUES(166,'West Highland White Terrier','Terriers',11,22,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(167,'Akita','Working Dogs',28,130,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(168,'Alaskan Malamute','Working Dogs',25,100,15,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(169,'Anatolian Shepherd Dog','Working Dogs',29,150,13,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(170,'Bernese Mountain Dog','Working Dogs',27,115,8,'Poor','Usually');
INSERT INTO dogs VALUES(171,'Black Russian Terrier','Working Dogs',30,140,11,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(172,'Boxer','Working Dogs',25,70,12,'Poor','Usually');
INSERT INTO dogs VALUES(173,'Bullmastiff','Working Dogs',27,130,10,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(174,'Cane Corso','Working Dogs',27,120,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(175,'Chinook','Working Dogs',27,70,15,'Fairly Good','Usually');
INSERT INTO dogs VALUES(176,'Chow Chow','Working Dogs',20,70,15,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(177,'Doberman Pinscher','Working Dogs',28,80,13,'Poor','Sometimes');
INSERT INTO dogs VALUES(178,'Dogue de Bordeaux','Working Dogs',27,100,12,'Poor','Rarely');
INSERT INTO dogs VALUES(179,'German Pinscher','Working Dogs',20,45,14,'Very Good','Sometimes');
INSERT INTO dogs VALUES(180,'Giant Schnauzer','Working Dogs',27,80,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(181,'Great Dane','Working Dogs',34,200,10,'Poor','Usually');
INSERT INTO dogs VALUES(182,'Great Pyrenees','Working Dogs',32,160,12,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(183,'Greater Swiss Mountain Dog','Working Dogs',28,140,9,'Fairly Good','Sometimes');
INSERT INTO dogs VALUES(184,'Komondor','Working Dogs',27,100,12,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(185,'Kuvasz','Working Dogs',30,115,12,'Very Good','Sometimes');
INSERT INTO dogs VALUES(186,'Leonberger','Working Dogs',31,170,12,'Poor','Rarely');
INSERT INTO dogs VALUES(187,'Mastiff','Working Dogs',32,220,10,'Poor','Rarely');
INSERT INTO dogs VALUES(188,'Neapolitan Mastiff','Working Dogs',31,200,10,'Poor','Rarely');
INSERT INTO dogs VALUES(189,'Newfoundland','Working Dogs',29,150,10,'Poor','Usually');
INSERT INTO dogs VALUES(190,'Norwegian Lundehund','Working Dogs',15,16,12,'Very Good','Rarely');
INSERT INTO dogs VALUES(191,'Portuguese Water Dog','Working Dogs',23,60,14,'Fairly Good','Rarely');
INSERT INTO dogs VALUES(192,'Rottweiler','Working Dogs',27,130,11,'Poor','Rarely');
INSERT INTO dogs VALUES(193,'Saint Bernard','Working Dogs',30,180,10,'Poor','Sometimes');
INSERT INTO dogs VALUES(194,'Samoyed','Working Dogs',24,60,14,'Fairly Good','Always');
INSERT INTO dogs VALUES(195,'Siberian Husky','Working Dogs',23,60,15,'Fairly Good','Always');
INSERT INTO dogs VALUES(196,'Standard Schnauzer','Working Dogs',20,15,16,'Excellent','Rarely');
INSERT INTO dogs VALUES(197,'Tibetan Mastiff','Working Dogs',26,160,10,'Very Good','Rarely');

CREATE TABLE popularity (
  dog_id int NOT NULL,
  year int NOT NULL,
  ranking int NOT NULL,
  PRIMARY KEY (dog_id,year),
  CONSTRAINT dog_popularity_fk FOREIGN KEY (dog_id) REFERENCES "dogs" (dog_id)
);
INSERT INTO popularity VALUES(1,2013,54);
INSERT INTO popularity VALUES(1,2014,58);
INSERT INTO popularity VALUES(1,2015,59);
INSERT INTO popularity VALUES(1,2016,61);
INSERT INTO popularity VALUES(2,2013,66);
INSERT INTO popularity VALUES(2,2014,74);
INSERT INTO popularity VALUES(2,2015,71);
INSERT INTO popularity VALUES(2,2016,72);
INSERT INTO popularity VALUES(3,2013,141);
INSERT INTO popularity VALUES(3,2014,152);
INSERT INTO popularity VALUES(3,2015,144);
INSERT INTO popularity VALUES(3,2016,150);
INSERT INTO popularity VALUES(5,2013,143);
INSERT INTO popularity VALUES(5,2014,144);
INSERT INTO popularity VALUES(5,2015,136);
INSERT INTO popularity VALUES(5,2016,149);
INSERT INTO popularity VALUES(7,2013,40);
INSERT INTO popularity VALUES(7,2014,44);
INSERT INTO popularity VALUES(7,2015,44);
INSERT INTO popularity VALUES(7,2016,45);
INSERT INTO popularity VALUES(9,2013,23);
INSERT INTO popularity VALUES(9,2014,23);
INSERT INTO popularity VALUES(9,2015,22);
INSERT INTO popularity VALUES(9,2016,21);
INSERT INTO popularity VALUES(10,2013,84);
INSERT INTO popularity VALUES(10,2014,91);
INSERT INTO popularity VALUES(10,2015,95);
INSERT INTO popularity VALUES(10,2016,97);
INSERT INTO popularity VALUES(11,2013,5);
INSERT INTO popularity VALUES(11,2014,4);
INSERT INTO popularity VALUES(11,2015,4);
INSERT INTO popularity VALUES(11,2016,4);
INSERT INTO popularity VALUES(12,2013,18);
INSERT INTO popularity VALUES(12,2014,19);
INSERT INTO popularity VALUES(12,2015,18);
INSERT INTO popularity VALUES(12,2016,19);
INSERT INTO popularity VALUES(13,2013,22);
INSERT INTO popularity VALUES(13,2014,24);
INSERT INTO popularity VALUES(13,2015,28);
INSERT INTO popularity VALUES(13,2016,30);
INSERT INTO popularity VALUES(14,2013,68);
INSERT INTO popularity VALUES(14,2014,65);
INSERT INTO popularity VALUES(14,2015,75);
INSERT INTO popularity VALUES(14,2016,77);
INSERT INTO popularity VALUES(15,2014,31);
INSERT INTO popularity VALUES(15,2015,85);
INSERT INTO popularity VALUES(15,2016,80);
INSERT INTO popularity VALUES(16,2013,64);
INSERT INTO popularity VALUES(16,2014,66);
INSERT INTO popularity VALUES(16,2015,62);
INSERT INTO popularity VALUES(16,2016,62);
INSERT INTO popularity VALUES(17,2013,135);
INSERT INTO popularity VALUES(17,2014,138);
INSERT INTO popularity VALUES(17,2015,129);
INSERT INTO popularity VALUES(17,2016,130);
INSERT INTO popularity VALUES(18,2013,11);
INSERT INTO popularity VALUES(18,2014,9);
INSERT INTO popularity VALUES(18,2015,6);
INSERT INTO popularity VALUES(18,2016,6);
INSERT INTO popularity VALUES(19,2013,25);
INSERT INTO popularity VALUES(19,2014,25);
INSERT INTO popularity VALUES(19,2015,24);
INSERT INTO popularity VALUES(19,2016,23);
INSERT INTO popularity VALUES(20,2013,87);
INSERT INTO popularity VALUES(20,2014,93);
INSERT INTO popularity VALUES(20,2015,97);
INSERT INTO popularity VALUES(20,2016,108);
INSERT INTO popularity VALUES(22,2013,63);
INSERT INTO popularity VALUES(22,2014,67);
INSERT INTO popularity VALUES(22,2015,65);
INSERT INTO popularity VALUES(22,2016,71);
INSERT INTO popularity VALUES(23,2013,154);
INSERT INTO popularity VALUES(23,2014,165);
INSERT INTO popularity VALUES(23,2015,161);
INSERT INTO popularity VALUES(23,2016,171);
INSERT INTO popularity VALUES(24,2013,27);
INSERT INTO popularity VALUES(24,2014,29);
INSERT INTO popularity VALUES(24,2015,31);
INSERT INTO popularity VALUES(24,2016,33);
INSERT INTO popularity VALUES(25,2013,53);
INSERT INTO popularity VALUES(25,2014,61);
INSERT INTO popularity VALUES(25,2015,64);
INSERT INTO popularity VALUES(25,2016,68);
INSERT INTO popularity VALUES(26,2013,38);
INSERT INTO popularity VALUES(26,2014,43);
INSERT INTO popularity VALUES(26,2015,48);
INSERT INTO popularity VALUES(26,2016,53);
INSERT INTO popularity VALUES(27,2013,77);
INSERT INTO popularity VALUES(27,2014,82);
INSERT INTO popularity VALUES(27,2015,80);
INSERT INTO popularity VALUES(27,2016,93);
INSERT INTO popularity VALUES(28,2013,19);
INSERT INTO popularity VALUES(28,2014,20);
INSERT INTO popularity VALUES(28,2015,21);
INSERT INTO popularity VALUES(28,2016,22);
INSERT INTO popularity VALUES(29,2013,8);
INSERT INTO popularity VALUES(29,2014,7);
INSERT INTO popularity VALUES(29,2015,8);
INSERT INTO popularity VALUES(29,2016,7);
INSERT INTO popularity VALUES(30,2013,31);
INSERT INTO popularity VALUES(30,2014,33);
INSERT INTO popularity VALUES(30,2015,33);
INSERT INTO popularity VALUES(30,2016,32);
INSERT INTO popularity VALUES(31,2013,109);
INSERT INTO popularity VALUES(31,2014,109);
INSERT INTO popularity VALUES(31,2015,109);
INSERT INTO popularity VALUES(31,2016,112);
INSERT INTO popularity VALUES(32,2013,46);
INSERT INTO popularity VALUES(32,2014,47);
INSERT INTO popularity VALUES(32,2015,45);
INSERT INTO popularity VALUES(32,2016,44);
INSERT INTO popularity VALUES(33,2013,15);
INSERT INTO popularity VALUES(33,2014,17);
INSERT INTO popularity VALUES(33,2015,19);
INSERT INTO popularity VALUES(33,2016,20);
INSERT INTO popularity VALUES(34,2013,92);
INSERT INTO popularity VALUES(34,2014,101);
INSERT INTO popularity VALUES(34,2015,102);
INSERT INTO popularity VALUES(34,2016,100);
INSERT INTO popularity VALUES(35,2013,106);
INSERT INTO popularity VALUES(35,2014,122);
INSERT INTO popularity VALUES(35,2015,115);
INSERT INTO popularity VALUES(35,2016,118);
INSERT INTO popularity VALUES(36,2013,88);
INSERT INTO popularity VALUES(36,2014,88);
INSERT INTO popularity VALUES(36,2015,90);
INSERT INTO popularity VALUES(36,2016,91);
INSERT INTO popularity VALUES(37,2013,107);
INSERT INTO popularity VALUES(37,2014,115);
INSERT INTO popularity VALUES(37,2015,110);
INSERT INTO popularity VALUES(37,2016,116);
INSERT INTO popularity VALUES(39,2013,6);
INSERT INTO popularity VALUES(39,2014,6);
INSERT INTO popularity VALUES(39,2015,7);
INSERT INTO popularity VALUES(39,2016,9);
INSERT INTO popularity VALUES(41,2013,58);
INSERT INTO popularity VALUES(41,2014,55);
INSERT INTO popularity VALUES(41,2015,56);
INSERT INTO popularity VALUES(41,2016,54);
INSERT INTO popularity VALUES(42,2013,20);
INSERT INTO popularity VALUES(42,2014,18);
INSERT INTO popularity VALUES(42,2015,17);
INSERT INTO popularity VALUES(42,2016,16);
INSERT INTO popularity VALUES(43,2013,112);
INSERT INTO popularity VALUES(43,2014,121);
INSERT INTO popularity VALUES(43,2015,119);
INSERT INTO popularity VALUES(43,2016,126);
INSERT INTO popularity VALUES(44,2013,60);
INSERT INTO popularity VALUES(44,2014,60);
INSERT INTO popularity VALUES(44,2015,51);
INSERT INTO popularity VALUES(44,2016,47);
INSERT INTO popularity VALUES(45,2013,119);
INSERT INTO popularity VALUES(45,2014,123);
INSERT INTO popularity VALUES(45,2015,120);
INSERT INTO popularity VALUES(45,2016,129);
INSERT INTO popularity VALUES(46,2013,108);
INSERT INTO popularity VALUES(46,2014,110);
INSERT INTO popularity VALUES(46,2015,98);
INSERT INTO popularity VALUES(46,2016,107);
INSERT INTO popularity VALUES(47,2016,141);
INSERT INTO popularity VALUES(48,2013,44);
INSERT INTO popularity VALUES(48,2014,40);
INSERT INTO popularity VALUES(48,2015,38);
INSERT INTO popularity VALUES(48,2016,38);
INSERT INTO popularity VALUES(49,2013,82);
INSERT INTO popularity VALUES(49,2014,81);
INSERT INTO popularity VALUES(49,2015,83);
INSERT INTO popularity VALUES(49,2016,83);
INSERT INTO popularity VALUES(50,2013,127);
INSERT INTO popularity VALUES(50,2014,132);
INSERT INTO popularity VALUES(50,2015,130);
INSERT INTO popularity VALUES(50,2016,132);
INSERT INTO popularity VALUES(52,2013,75);
INSERT INTO popularity VALUES(52,2014,78);
INSERT INTO popularity VALUES(52,2015,76);
INSERT INTO popularity VALUES(52,2016,69);
INSERT INTO popularity VALUES(54,2013,35);
INSERT INTO popularity VALUES(54,2014,36);
INSERT INTO popularity VALUES(54,2015,36);
INSERT INTO popularity VALUES(54,2016,37);
INSERT INTO popularity VALUES(55,2013,155);
INSERT INTO popularity VALUES(55,2014,153);
INSERT INTO popularity VALUES(55,2015,159);
INSERT INTO popularity VALUES(55,2016,161);
INSERT INTO popularity VALUES(57,2013,2);
INSERT INTO popularity VALUES(57,2014,2);
INSERT INTO popularity VALUES(57,2015,2);
INSERT INTO popularity VALUES(57,2016,2);
INSERT INTO popularity VALUES(58,2013,142);
INSERT INTO popularity VALUES(58,2014,146);
INSERT INTO popularity VALUES(58,2015,140);
INSERT INTO popularity VALUES(58,2016,153);
INSERT INTO popularity VALUES(60,2013,166);
INSERT INTO popularity VALUES(60,2014,172);
INSERT INTO popularity VALUES(60,2015,165);
INSERT INTO popularity VALUES(60,2016,174);
INSERT INTO popularity VALUES(61,2013,78);
INSERT INTO popularity VALUES(61,2014,77);
INSERT INTO popularity VALUES(61,2015,74);
INSERT INTO popularity VALUES(61,2016,75);
INSERT INTO popularity VALUES(62,2013,24);
INSERT INTO popularity VALUES(62,2014,22);
INSERT INTO popularity VALUES(62,2015,20);
INSERT INTO popularity VALUES(62,2016,18);
INSERT INTO popularity VALUES(63,2013,157);
INSERT INTO popularity VALUES(63,2014,170);
INSERT INTO popularity VALUES(63,2015,164);
INSERT INTO popularity VALUES(63,2016,169);
INSERT INTO popularity VALUES(65,2013,169);
INSERT INTO popularity VALUES(65,2014,178);
INSERT INTO popularity VALUES(65,2015,176);
INSERT INTO popularity VALUES(65,2016,176);
INSERT INTO popularity VALUES(66,2013,21);
INSERT INTO popularity VALUES(66,2014,21);
INSERT INTO popularity VALUES(66,2015,23);
INSERT INTO popularity VALUES(66,2016,24);
INSERT INTO popularity VALUES(68,2013,95);
INSERT INTO popularity VALUES(68,2014,98);
INSERT INTO popularity VALUES(68,2015,100);
INSERT INTO popularity VALUES(68,2016,113);
INSERT INTO popularity VALUES(69,2013,146);
INSERT INTO popularity VALUES(69,2014,156);
INSERT INTO popularity VALUES(69,2015,166);
INSERT INTO popularity VALUES(69,2016,170);
INSERT INTO popularity VALUES(70,2013,176);
INSERT INTO popularity VALUES(70,2014,180);
INSERT INTO popularity VALUES(70,2015,181);
INSERT INTO popularity VALUES(70,2016,189);
INSERT INTO popularity VALUES(72,2013,85);
INSERT INTO popularity VALUES(72,2014,86);
INSERT INTO popularity VALUES(72,2015,87);
INSERT INTO popularity VALUES(72,2016,88);
INSERT INTO popularity VALUES(73,2013,41);
INSERT INTO popularity VALUES(73,2014,42);
INSERT INTO popularity VALUES(73,2015,39);
INSERT INTO popularity VALUES(73,2016,39);
INSERT INTO popularity VALUES(74,2013,4);
INSERT INTO popularity VALUES(74,2014,5);
INSERT INTO popularity VALUES(74,2015,5);
INSERT INTO popularity VALUES(74,2016,5);
INSERT INTO popularity VALUES(76,2013,48);
INSERT INTO popularity VALUES(76,2014,50);
INSERT INTO popularity VALUES(76,2015,49);
INSERT INTO popularity VALUES(76,2016,52);
INSERT INTO popularity VALUES(77,2013,128);
INSERT INTO popularity VALUES(77,2014,130);
INSERT INTO popularity VALUES(77,2015,123);
INSERT INTO popularity VALUES(77,2016,121);
INSERT INTO popularity VALUES(78,2013,99);
INSERT INTO popularity VALUES(78,2014,102);
INSERT INTO popularity VALUES(78,2015,89);
INSERT INTO popularity VALUES(78,2016,98);
INSERT INTO popularity VALUES(79,2013,10);
INSERT INTO popularity VALUES(79,2014,11);
INSERT INTO popularity VALUES(79,2015,13);
INSERT INTO popularity VALUES(79,2016,13);
INSERT INTO popularity VALUES(80,2013,177);
INSERT INTO popularity VALUES(80,2014,183);
INSERT INTO popularity VALUES(80,2015,184);
INSERT INTO popularity VALUES(80,2016,187);
INSERT INTO popularity VALUES(81,2013,148);
INSERT INTO popularity VALUES(81,2014,147);
INSERT INTO popularity VALUES(81,2015,147);
INSERT INTO popularity VALUES(81,2016,151);
INSERT INTO popularity VALUES(82,2013,173);
INSERT INTO popularity VALUES(82,2014,181);
INSERT INTO popularity VALUES(82,2015,183);
INSERT INTO popularity VALUES(82,2016,186);
INSERT INTO popularity VALUES(83,2013,151);
INSERT INTO popularity VALUES(83,2014,159);
INSERT INTO popularity VALUES(83,2015,160);
INSERT INTO popularity VALUES(83,2016,152);
INSERT INTO popularity VALUES(84,2013,73);
INSERT INTO popularity VALUES(84,2014,72);
INSERT INTO popularity VALUES(84,2015,69);
INSERT INTO popularity VALUES(84,2016,73);
INSERT INTO popularity VALUES(85,2013,103);
INSERT INTO popularity VALUES(85,2014,103);
INSERT INTO popularity VALUES(85,2015,88);
INSERT INTO popularity VALUES(85,2016,94);
INSERT INTO popularity VALUES(86,2013,172);
INSERT INTO popularity VALUES(86,2014,179);
INSERT INTO popularity VALUES(86,2015,180);
INSERT INTO popularity VALUES(86,2016,166);
INSERT INTO popularity VALUES(88,2013,160);
INSERT INTO popularity VALUES(88,2014,164);
INSERT INTO popularity VALUES(88,2015,171);
INSERT INTO popularity VALUES(88,2016,168);
INSERT INTO popularity VALUES(89,2013,149);
INSERT INTO popularity VALUES(89,2014,154);
INSERT INTO popularity VALUES(89,2015,149);
INSERT INTO popularity VALUES(89,2016,158);
INSERT INTO popularity VALUES(91,2013,133);
INSERT INTO popularity VALUES(91,2014,148);
INSERT INTO popularity VALUES(91,2015,139);
INSERT INTO popularity VALUES(91,2016,143);
INSERT INTO popularity VALUES(92,2013,39);
INSERT INTO popularity VALUES(92,2014,39);
INSERT INTO popularity VALUES(92,2015,40);
INSERT INTO popularity VALUES(92,2016,42);
INSERT INTO popularity VALUES(93,2013,115);
INSERT INTO popularity VALUES(93,2014,134);
INSERT INTO popularity VALUES(93,2015,132);
INSERT INTO popularity VALUES(93,2016,125);
INSERT INTO popularity VALUES(94,2013,165);
INSERT INTO popularity VALUES(94,2014,157);
INSERT INTO popularity VALUES(94,2015,152);
INSERT INTO popularity VALUES(94,2016,154);
INSERT INTO popularity VALUES(95,2016,185);
INSERT INTO popularity VALUES(97,2013,101);
INSERT INTO popularity VALUES(97,2014,112);
INSERT INTO popularity VALUES(97,2015,117);
INSERT INTO popularity VALUES(97,2016,137);
INSERT INTO popularity VALUES(98,2013,59);
INSERT INTO popularity VALUES(98,2014,56);
INSERT INTO popularity VALUES(98,2015,57);
INSERT INTO popularity VALUES(98,2016,60);
INSERT INTO popularity VALUES(109,2013,144);
INSERT INTO popularity VALUES(109,2014,160);
INSERT INTO popularity VALUES(109,2015,157);
INSERT INTO popularity VALUES(109,2016,156);
INSERT INTO popularity VALUES(113,2013,30);
INSERT INTO popularity VALUES(113,2014,27);
INSERT INTO popularity VALUES(113,2015,26);
INSERT INTO popularity VALUES(113,2016,25);
INSERT INTO popularity VALUES(114,2013,43);
INSERT INTO popularity VALUES(114,2014,41);
INSERT INTO popularity VALUES(114,2015,42);
INSERT INTO popularity VALUES(114,2016,43);
INSERT INTO popularity VALUES(115,2013,131);
INSERT INTO popularity VALUES(115,2014,143);
INSERT INTO popularity VALUES(115,2015,134);
INSERT INTO popularity VALUES(115,2016,144);
INSERT INTO popularity VALUES(116,2013,29);
INSERT INTO popularity VALUES(116,2014,30);
INSERT INTO popularity VALUES(116,2015,30);
INSERT INTO popularity VALUES(116,2016,29);
INSERT INTO popularity VALUES(118,2013,62);
INSERT INTO popularity VALUES(118,2014,62);
INSERT INTO popularity VALUES(118,2015,60);
INSERT INTO popularity VALUES(118,2016,56);
INSERT INTO popularity VALUES(119,2013,91);
INSERT INTO popularity VALUES(119,2014,89);
INSERT INTO popularity VALUES(119,2015,96);
INSERT INTO popularity VALUES(119,2016,102);
INSERT INTO popularity VALUES(120,2013,28);
INSERT INTO popularity VALUES(120,2014,28);
INSERT INTO popularity VALUES(120,2015,27);
INSERT INTO popularity VALUES(120,2016,26);
INSERT INTO popularity VALUES(121,2013,140);
INSERT INTO popularity VALUES(121,2014,137);
INSERT INTO popularity VALUES(121,2015,145);
INSERT INTO popularity VALUES(121,2016,147);
INSERT INTO popularity VALUES(122,2013,170);
INSERT INTO popularity VALUES(122,2014,174);
INSERT INTO popularity VALUES(122,2015,178);
INSERT INTO popularity VALUES(122,2016,179);
INSERT INTO popularity VALUES(123,2013,94);
INSERT INTO popularity VALUES(123,2014,92);
INSERT INTO popularity VALUES(123,2015,86);
INSERT INTO popularity VALUES(123,2016,89);
INSERT INTO popularity VALUES(124,2013,71);
INSERT INTO popularity VALUES(124,2014,71);
INSERT INTO popularity VALUES(124,2015,68);
INSERT INTO popularity VALUES(124,2016,64);
INSERT INTO popularity VALUES(126,2013,3);
INSERT INTO popularity VALUES(126,2014,3);
INSERT INTO popularity VALUES(126,2015,3);
INSERT INTO popularity VALUES(126,2016,3);
INSERT INTO popularity VALUES(127,2013,105);
INSERT INTO popularity VALUES(127,2014,100);
INSERT INTO popularity VALUES(127,2015,105);
INSERT INTO popularity VALUES(127,2016,104);
INSERT INTO popularity VALUES(129,2013,72);
INSERT INTO popularity VALUES(129,2014,73);
INSERT INTO popularity VALUES(129,2015,72);
INSERT INTO popularity VALUES(129,2016,76);
INSERT INTO popularity VALUES(131,2013,1);
INSERT INTO popularity VALUES(131,2014,1);
INSERT INTO popularity VALUES(131,2015,1);
INSERT INTO popularity VALUES(131,2016,1);
INSERT INTO popularity VALUES(133,2013,114);
INSERT INTO popularity VALUES(133,2014,119);
INSERT INTO popularity VALUES(133,2015,114);
INSERT INTO popularity VALUES(133,2016,117);
INSERT INTO popularity VALUES(136,2013,34);
INSERT INTO popularity VALUES(136,2014,34);
INSERT INTO popularity VALUES(136,2015,32);
INSERT INTO popularity VALUES(136,2016,31);
INSERT INTO popularity VALUES(137,2013,33);
INSERT INTO popularity VALUES(137,2014,35);
INSERT INTO popularity VALUES(137,2015,34);
INSERT INTO popularity VALUES(137,2016,34);
INSERT INTO popularity VALUES(138,2013,124);
INSERT INTO popularity VALUES(138,2014,133);
INSERT INTO popularity VALUES(138,2015,128);
INSERT INTO popularity VALUES(138,2016,123);
INSERT INTO popularity VALUES(139,2013,80);
INSERT INTO popularity VALUES(139,2014,76);
INSERT INTO popularity VALUES(139,2015,66);
INSERT INTO popularity VALUES(139,2016,66);
INSERT INTO popularity VALUES(140,2013,56);
INSERT INTO popularity VALUES(140,2014,57);
INSERT INTO popularity VALUES(140,2015,53);
INSERT INTO popularity VALUES(140,2016,55);
INSERT INTO popularity VALUES(142,2013,122);
INSERT INTO popularity VALUES(142,2014,139);
INSERT INTO popularity VALUES(142,2015,125);
INSERT INTO popularity VALUES(142,2016,136);
INSERT INTO popularity VALUES(143,2013,137);
INSERT INTO popularity VALUES(143,2014,140);
INSERT INTO popularity VALUES(143,2015,146);
INSERT INTO popularity VALUES(143,2016,138);
INSERT INTO popularity VALUES(144,2013,81);
INSERT INTO popularity VALUES(144,2014,85);
INSERT INTO popularity VALUES(144,2015,82);
INSERT INTO popularity VALUES(144,2016,86);
INSERT INTO popularity VALUES(145,2013,52);
INSERT INTO popularity VALUES(145,2014,53);
INSERT INTO popularity VALUES(145,2015,55);
INSERT INTO popularity VALUES(145,2016,57);
INSERT INTO popularity VALUES(146,2013,61);
INSERT INTO popularity VALUES(146,2014,69);
INSERT INTO popularity VALUES(146,2015,70);
INSERT INTO popularity VALUES(146,2016,70);
INSERT INTO popularity VALUES(147,2013,174);
INSERT INTO popularity VALUES(147,2014,182);
INSERT INTO popularity VALUES(147,2015,179);
INSERT INTO popularity VALUES(147,2016,182);
INSERT INTO popularity VALUES(150,2013,167);
INSERT INTO popularity VALUES(150,2014,162);
INSERT INTO popularity VALUES(150,2015,168);
INSERT INTO popularity VALUES(150,2016,180);
INSERT INTO popularity VALUES(151,2013,123);
INSERT INTO popularity VALUES(151,2014,125);
INSERT INTO popularity VALUES(151,2015,113);
INSERT INTO popularity VALUES(151,2016,115);
INSERT INTO popularity VALUES(153,2013,126);
INSERT INTO popularity VALUES(153,2014,128);
INSERT INTO popularity VALUES(153,2015,124);
INSERT INTO popularity VALUES(153,2016,127);
INSERT INTO popularity VALUES(154,2013,134);
INSERT INTO popularity VALUES(154,2014,149);
INSERT INTO popularity VALUES(154,2015,141);
INSERT INTO popularity VALUES(154,2016,145);
INSERT INTO popularity VALUES(155,2013,120);
INSERT INTO popularity VALUES(155,2014,136);
INSERT INTO popularity VALUES(155,2015,137);
INSERT INTO popularity VALUES(155,2016,133);
INSERT INTO popularity VALUES(156,2013,17);
INSERT INTO popularity VALUES(156,2014,16);
INSERT INTO popularity VALUES(156,2015,16);
INSERT INTO popularity VALUES(156,2016,17);
INSERT INTO popularity VALUES(157,2013,129);
INSERT INTO popularity VALUES(157,2014,131);
INSERT INTO popularity VALUES(157,2015,131);
INSERT INTO popularity VALUES(157,2016,134);
INSERT INTO popularity VALUES(158,2013,89);
INSERT INTO popularity VALUES(158,2014,97);
INSERT INTO popularity VALUES(158,2015,103);
INSERT INTO popularity VALUES(158,2016,103);
INSERT INTO popularity VALUES(159,2014,111);
INSERT INTO popularity VALUES(159,2015,101);
INSERT INTO popularity VALUES(159,2016,96);
INSERT INTO popularity VALUES(160,2013,55);
INSERT INTO popularity VALUES(160,2014,59);
INSERT INTO popularity VALUES(160,2015,58);
INSERT INTO popularity VALUES(160,2016,58);
INSERT INTO popularity VALUES(161,2013,158);
INSERT INTO popularity VALUES(161,2014,169);
INSERT INTO popularity VALUES(161,2015,158);
INSERT INTO popularity VALUES(161,2016,155);
INSERT INTO popularity VALUES(162,2013,161);
INSERT INTO popularity VALUES(162,2014,177);
INSERT INTO popularity VALUES(162,2015,175);
INSERT INTO popularity VALUES(162,2016,178);
INSERT INTO popularity VALUES(164,2013,79);
INSERT INTO popularity VALUES(164,2014,79);
INSERT INTO popularity VALUES(164,2015,79);
INSERT INTO popularity VALUES(164,2016,82);
INSERT INTO popularity VALUES(165,2013,104);
INSERT INTO popularity VALUES(165,2014,106);
INSERT INTO popularity VALUES(165,2015,108);
INSERT INTO popularity VALUES(165,2016,111);
INSERT INTO popularity VALUES(166,2013,36);
INSERT INTO popularity VALUES(166,2014,38);
INSERT INTO popularity VALUES(166,2015,41);
INSERT INTO popularity VALUES(166,2016,41);
INSERT INTO popularity VALUES(167,2013,45);
INSERT INTO popularity VALUES(167,2014,46);
INSERT INTO popularity VALUES(167,2015,46);
INSERT INTO popularity VALUES(167,2016,46);
INSERT INTO popularity VALUES(168,2013,57);
INSERT INTO popularity VALUES(168,2014,54);
INSERT INTO popularity VALUES(168,2015,54);
INSERT INTO popularity VALUES(168,2016,59);
INSERT INTO popularity VALUES(169,2013,93);
INSERT INTO popularity VALUES(169,2014,94);
INSERT INTO popularity VALUES(169,2015,92);
INSERT INTO popularity VALUES(169,2016,84);
INSERT INTO popularity VALUES(170,2013,32);
INSERT INTO popularity VALUES(170,2014,32);
INSERT INTO popularity VALUES(170,2015,29);
INSERT INTO popularity VALUES(170,2016,27);
INSERT INTO popularity VALUES(171,2013,118);
INSERT INTO popularity VALUES(171,2014,127);
INSERT INTO popularity VALUES(171,2015,116);
INSERT INTO popularity VALUES(171,2016,119);
INSERT INTO popularity VALUES(172,2013,7);
INSERT INTO popularity VALUES(172,2014,8);
INSERT INTO popularity VALUES(172,2015,10);
INSERT INTO popularity VALUES(172,2016,10);
INSERT INTO popularity VALUES(174,2013,50);
INSERT INTO popularity VALUES(174,2014,48);
INSERT INTO popularity VALUES(174,2015,35);
INSERT INTO popularity VALUES(174,2016,40);
INSERT INTO popularity VALUES(175,2013,156);
INSERT INTO popularity VALUES(175,2014,171);
INSERT INTO popularity VALUES(175,2015,177);
INSERT INTO popularity VALUES(175,2016,175);
INSERT INTO popularity VALUES(176,2013,70);
INSERT INTO popularity VALUES(176,2014,70);
INSERT INTO popularity VALUES(176,2015,73);
INSERT INTO popularity VALUES(176,2016,74);
INSERT INTO popularity VALUES(177,2013,12);
INSERT INTO popularity VALUES(177,2014,14);
INSERT INTO popularity VALUES(177,2015,14);
INSERT INTO popularity VALUES(177,2016,15);
INSERT INTO popularity VALUES(179,2013,130);
INSERT INTO popularity VALUES(179,2014,141);
INSERT INTO popularity VALUES(179,2015,138);
INSERT INTO popularity VALUES(179,2016,146);
INSERT INTO popularity VALUES(180,2013,83);
INSERT INTO popularity VALUES(180,2014,83);
INSERT INTO popularity VALUES(180,2015,81);
INSERT INTO popularity VALUES(180,2016,79);
INSERT INTO popularity VALUES(181,2013,16);
INSERT INTO popularity VALUES(181,2014,15);
INSERT INTO popularity VALUES(181,2015,15);
INSERT INTO popularity VALUES(181,2016,14);
INSERT INTO popularity VALUES(183,2013,74);
INSERT INTO popularity VALUES(183,2014,80);
INSERT INTO popularity VALUES(183,2015,78);
INSERT INTO popularity VALUES(183,2016,78);
INSERT INTO popularity VALUES(186,2013,98);
INSERT INTO popularity VALUES(186,2014,104);
INSERT INTO popularity VALUES(186,2015,93);
INSERT INTO popularity VALUES(186,2016,95);
INSERT INTO popularity VALUES(187,2013,26);
INSERT INTO popularity VALUES(187,2014,26);
INSERT INTO popularity VALUES(187,2015,25);
INSERT INTO popularity VALUES(187,2016,28);
INSERT INTO popularity VALUES(188,2013,111);
INSERT INTO popularity VALUES(188,2014,114);
INSERT INTO popularity VALUES(188,2015,106);
INSERT INTO popularity VALUES(188,2016,99);
INSERT INTO popularity VALUES(189,2013,37);
INSERT INTO popularity VALUES(189,2014,37);
INSERT INTO popularity VALUES(189,2015,37);
INSERT INTO popularity VALUES(189,2016,35);
INSERT INTO popularity VALUES(190,2013,175);
INSERT INTO popularity VALUES(190,2014,184);
INSERT INTO popularity VALUES(190,2015,182);
INSERT INTO popularity VALUES(190,2016,188);
INSERT INTO popularity VALUES(191,2013,49);
INSERT INTO popularity VALUES(191,2014,52);
INSERT INTO popularity VALUES(191,2015,52);
INSERT INTO popularity VALUES(191,2016,51);
INSERT INTO popularity VALUES(192,2013,9);
INSERT INTO popularity VALUES(192,2014,10);
INSERT INTO popularity VALUES(192,2015,9);
INSERT INTO popularity VALUES(192,2016,8);
INSERT INTO popularity VALUES(194,2013,67);
INSERT INTO popularity VALUES(194,2014,68);
INSERT INTO popularity VALUES(194,2015,61);
INSERT INTO popularity VALUES(194,2016,65);
INSERT INTO popularity VALUES(195,2013,14);
INSERT INTO popularity VALUES(195,2014,13);
INSERT INTO popularity VALUES(195,2015,12);
INSERT INTO popularity VALUES(195,2016,12);
INSERT INTO popularity VALUES(196,2013,90);
INSERT INTO popularity VALUES(196,2014,90);
INSERT INTO popularity VALUES(196,2015,91);
INSERT INTO popularity VALUES(196,2016,85);
INSERT INTO popularity VALUES(197,2013,132);
INSERT INTO popularity VALUES(197,2014,135);
INSERT INTO popularity VALUES(197,2015,133);
INSERT INTO popularity VALUES(197,2016,135);