POKEMON INSERT DATA

INSERT INTO POKEMON (POKE_NUM,POKE_NAME,POKE_HEIGHT,POKE_WEIGHT,GEN_NUM)
VALUES(144,"Articuno",1.7,55.4,1),
(145,"Zapdos",1.6,52.6,1),
(146,"Moltres",2,60,1),
(150,"Mewtwo",2,122,1),
(151,"Mew",0.4,4,1),
(243,"Raikou",1.9,178,2),
(244,"Entei",2.1,198,2),
(245,"Suicune",2,187,2),
(249,"Lugia",5.2,216,2),
(250,"Ho-oh",3.8,199,2),
(251,"Celebi",0.6,5,2),
(377,"Regirock",1.7,230,3),
(378,"Regice",1.8,175,3),
(379,"Registeel",1.9,205,3),
(380,"Latias",1.4,40,3),
(381,"Latios",2,60,3),
(382,"Kyogre",4.5,352,3),
(383,"Groundon",3.5,950,3),
(384,"Rayquaza",7,206.5,3),
(385,"Jirachi",0.3,1.1,3),
(386,"Deoxys",1.7,60.8,3),
(480,"Uxie",0.3,0.3,4),
(481,"Mesprit",0.3,0.3,4),
(482,"Azelf",0.3,0.3,4),
(483,"Dialga",5.4,683,4),
(484,"Palkia",4.2,336,4),
(485,"Heatran",1.7,430,4),
(486,"Regigigas",3.7,420,4),
(487,"Giratina",4.5,750,4),
(488,"Cresselia",1.5,85.6,4),
(490,"Manaphy",0.3,1.4,4),
(491,"Darkrai",1.5,50.5,4),
(492,"Shaymin",0.2,2.1,4),
(493,"Arceus",3.2,320,4),
(494,"Victini",0.4,4,5),
(638,"Cobalion",2.1,250,5),
(639,"Terrakion",1.9,260,5),
(640,"Virizion",2,200,5),
(641,"Tornadus",1.5,63,5),
(642,"Thundurus",1.5,61,5),
(643,"Reshiram",3.2,330,5),
(644,"Zekrom",2.9,345,5),
(645,"Landorus",1.5,68,5),
(646,"Kyurem",3,325,5),
(647,"Keldeo",1.4,48.5,5),
(648,"Meloetta",0.6,6.5,5),
(649,"Genesect",1.5,82.5,5),
(716,"Xerneas",3,215,6),
(717,"Yveltal",5.8,203,6),
(718,"Zygarde",5,305,6),
(719,"Diancie",0.7,8.8,6),
(720,"Hoopa",0.5,9,6),
(721,"Volcanion",1.7,195,6),
(785,"Tapu Koko",1.8,20.5,7),
(786,"Tapu Lele",1.2,18.6,7),
(787,"Taou Bulu" ,1.9,45.5,7),
(788,"Tapu Fini",1.3,21.2,7),
(791,"Solgaleo",3.4,230,7),
(792,"Lunala",4,120,7),
(800,"Necrozma",2.4,230,7),
(801,"Magearna",1,80.5,7),
(802,"Marshadow",0.7,22.2,7);

INSERT INTO STATS (POKEMON_NUM,STATS_BASE_HP,STATS_BASE_ATTACK,STATS_BASE_DEFENSE,STATS_BASE_SPATTACK,STATS_BASE_SPDEFENSE,STATS_BASE_SPEED,STATS_MAX_HP,STATS_MAX_ATTACK,STATS_MAX_DEFENSE,STATS_MAX_SPATTACK,STATS_MAX_SPDEFENSE,STATS_MAX_SPEED)
VALUES (144,90,85,100,95,125,85,384,295,328,317,383,295),
(145,90,90,85,125,90,100,384,306,295,383,306,328),
(146,90,100,90,125,85,90,384,328,306,383,295,306),
(150,106,110,90,154,90,130,416,350,306,447,306,394),
(151,100,100,100,100,100,100,404,328,328,328,328,328),
(243,90,85,75,115,100,115,384,295,273,361,328,361),
(244,115,115,85,90,75,100,434,361,295,306,273,328),
(245,100,75,115,90,115,85,404,273,361,306,361,295),
(249,106,90,130,90,154,110,416,306,394,306,447,350),
(250,106,130,90,110,154,90,416,394,306,350,447,306),
(251,100,100,100,100,100,100,404,328,328,328,328,328),
(377,80,100,200,50,100,50,364,328,548,218,328,218),
(378,80,50,100,100,200,50,364,218,328,328,548,218),
(379,80,75,150,75,150,50,364,273,438,273,438,218),
(380,80,80,90,110,130,110,364,284,306,350,394,350),
(381,80,90,80,130,110,110,364,306,284,394,350,350),
(382,100,100,90,150,140,90,404,328,306,438,416,306),
(383,100,150,140,100,90,90,404,438,416,328,306,306),
(384,105,150,90,150,90,95,414,438,306,438,306,317),
(385,100,100,100,100,100,100,404,328,328,328,328,328),
(386,50,150,50,150,50,150,304,438,218,438,218,438),
(480,75,75,130,75,130,95,354,273,394,273,394,317),
(481,80,105,105,105,105,80,364,339,339,339,339,284),
(482,75,125,70,125,70,115,354,383,262,383,262,361),
(483,100,120,120,150,100,90,404,372,372,438,328,306),
(484,90,120,100,150,120,100,384,372,328,438,372,328),
(485,91,90,106,130,106,77,386,306,342,394,342,278),
(486,110,160,110,80,110,100,424,460,350,284,350,328),
(487,150,100,120,100,120,90,504,328,372,328,372,306),
(488,120,70,120,75,130,85,444,262,372,273,394,295),
(490,100,100,100,100,100,100,404,328,328,328,328,328),
(491,70,90,90,135,90,125,344,306,306,405,306,383),
(492,100,100,100,100,100,100,404,328,328,328,328,328),
(493,120,120,120,120,120,120,444,372,372,372,372,372),
(494,100,100,100,100,100,100,404,328,328,328,328,328),
(638,91,90,129,90,72,108,386,306,392,306,265,346),
(639,91,129,90,72,90,108,386,392,306,267,306,346),
(640,91,90,72,90,129,108,386,306,267,306,392,346),
(641,79,115,70,125,80,111,362,361,262,383,284,353),
(642,79,115,70,125,80,111,362,361,262,383,284,353),
(643,100,120,100,150,120,90,404,372,328,438,372,306),
(644,100,150,120,120,100,90,404,438,372,372,328,306),
(645,89,125,90,115,80,101,382,383,306,361,284,331),
(646,125,130,90,130,90,95,454,394,306,394,306,317),
(647,91,72,90,129,90,108,386,267,306,392,306,346),
(648,100,77,77,128,128,90,404,278,278,390,390,306),
(649,71,120,95,120,95,99,346,372,317,372,317,326),
(716,126,131,95,131,98,99,456,397,317,397,324,326),
(717,126,131,95,131,98,99,456,397,317,397,324,326),
(718,108,100,121,81,95,95,420,328,375,287,317,317),
(719,50,100,150,100,150,50,304,328,438,328,438,218),
(720,80,110,60,150,130,70,364,350,240,438,394,262),
(721,80,110,120,130,90,70,364,350,372,394,306,262),
(785,70,115,85,95,75,130,344,361,295,317,273,394),
(786,70,85,75,130,115,95,344,295,273,394,361,317),
(787,70,130,115,85,95,75,344,394,361,295,317,273),
(788,70,75,115,95,130,85,344,273,361,317,394,295),
(791,137,137,107,113,89,97,478,410,344,357,304,322),
(792,137,113,89,137,107,97,478,357,304,410,344,322),
(800,97,107,101,127,89,79,398,344,331,388,304,282),
(801,80,95,115,130,115,65,364,317,361,394,361,251),
(802,90,125,80,90,90,125,384,383,284,306,306,383);

INSERT INTO GEN (GEN_NUM, GEN_YEAR)
VALUES (1,1996),
(2,1999),
(3,2003),
(4,2006),
(5,2010),
(6,2013),
(7,2016);

INSERT INTO BELONGS (POKE_NUM, TYPE_ID)
VALUES (144,12),
(144,5),
(145,8),
(145,5),
(146,2),
(146,5),
(150,10),
(152,10),
(243,8),
(244,2),
(245,4),
(249,10),
(249,5),
(250,2),
(250,5),
(251,10),
(251,6),
(377,11),
(378,12),
(379,17),
(380,14),
(380,10),
(381,14),
(381,10),
(832,4),
(383,9),
(384,14),
(384,5),
(385,17),
(385,10),
(386,10),
(480,10),
(481,10),
(482,10),
(483,17),
(483,14),
(484,4),
(484,14),
(485,2),
(485,17),
(486,1),
(487,15),
(487,14),
(488,10),
(490,4),
(491,16),
(492,6),
(493,1),
(494,10),
(494,2),
(638,17),
(638,3),
(639,11),
(639,3),
(640,6),
(640,3),
(641,5),
(642,8),
(642,5),
(643,14),
(643,2),
(644,14),
(644,8),
(645,9),
(645,5),
(646,14),
(646,12),
(647,4),
(647,3),
(648,1),
(648,10),
(649,13),
(649,17),
(716,18),
(717,16),
(717,5),
(718,14),
(718,9),
(719,11),
(719,18),
(720,10),
(720,15),
(721,2),
(721,4),
(785,8),
(785,18),
(786,10),
(786,18),
(787,6),
(787,18),
(788,4),
(788,18),
(791,10),
(791,17),
(792,10),
(792,15),
(800,10),
(801,17),
(801,18),
(802,3),
(802,15);

INSERT INTO LEARNS(POKE_NUM ,MOVE_NAME ,MOVE_ID,LEARN_LEVEL)
VALUES ();

INSERT INTO TYPE (TYPE_NAME ,TYPE_ID ,TYPE_AVG_HP ,TYPE_AVG_ATTACK ,TYPE_AVG_DEFENSE ,TYPE_AVG_SPATTACK ,TYPE_AVG_SPDEFENSE ,TYPE_AVG_SPEED)
VALUES ();