mysql> show tables;
+-------------------+
| Tables_in_pokemon |
+-------------------+
| Attributes        |
| Evolution         |
| First10           |
| PokeData          |
| PokeStats         |
| Pokemon           |
| SpTypes           |
| Species           |
| Types             |
| fff               |
| foo               |
| poke10            |
| poke10s           |
| poke5             |
| pokefoo           |
| tmp               |
| ttt               |
+-------------------+
17 rows in set (0.01 sec)

mysql> Select * from PokeData;
+------------+-----------+--------+--------+----------------+---------------+----------+------+--------+
| Name       | PokedexID | Height | Weight | BaseExperience | Genus         | Type     | gen  | typeId |
+------------+-----------+--------+--------+----------------+---------------+----------+------+--------+
| Genesect   |       649 |     15 |    825 |            270 | Paleozoic     | bug      |    4 |      0 |
| Meloetta   |       648 |      6 |     65 |            270 | Melody        | normal   |    4 |      0 |
| Keldeo     |       647 |     14 |    485 |            261 | Colt          | water    |    4 |      1 |
| Kyurem     |       646 |     30 |   3250 |            297 | Boundary      | dragon   |    4 |      0 |
| Landorus   |       645 |     15 |    680 |            270 | Abundance     | ground   |    4 |      0 |
| Zekrom     |       644 |     29 |   3450 |            306 | Deep Black    | dragon   |    4 |      0 |
| Reshiram   |       643 |     32 |   3300 |            306 | Vast White    | dragon   |    4 |      0 |
| Thundurus  |       642 |     15 |    610 |            261 | Bolt Strike   | electric |    4 |      0 |
| Tornadus   |       641 |     15 |    630 |            261 | Cyclone       | flying   |    4 |      0 |
| Virizion   |       640 |     20 |   2000 |            261 | Grassland     | grass    |    4 |      0 |
| Terrakion  |       639 |     19 |   2600 |            261 | Cavern        | rock     |    4 |      0 |
| Cobalion   |       638 |     21 |   2500 |            261 | Iron Will     | steel    |    4 |      0 |
| Volcarona  |       637 |     16 |    460 |            248 | Sun           | bug      |    4 |      0 |
| Larvesta   |       636 |     11 |    288 |             72 | Torch         | bug      |    4 |      0 |
| Hydreigon  |       635 |     18 |   1600 |            270 | Brutal        | dark     |    4 |      0 |
| Zweilous   |       634 |     14 |    500 |            147 | Hostile       | dark     |    4 |      0 |
| Deino      |       633 |      8 |    173 |             60 | Irate         | dark     |    4 |      0 |
| Durant     |       632 |      3 |    330 |            169 | Iron Ant      | bug      |    4 |      0 |
| Heatmor    |       631 |     14 |    580 |            169 | Anteater      | fire     |    4 |      0 |
| Mandibuzz  |       630 |     12 |    395 |            179 | Bone Vulture  | dark     |    4 |      0 |
| Vullaby    |       629 |      5 |     90 |             74 | Diapered      | dark     |    4 |      0 |
| Braviary   |       628 |     15 |    410 |            179 | Valiant       | normal   |    4 |      0 |
| Rufflet    |       627 |      5 |    105 |             70 | Eaglet        | normal   |    4 |      0 |
| Bouffalant |       626 |     16 |    946 |            172 | Bash Buffalo  | normal   |    4 |      0 |
| Bisharp    |       625 |     16 |    700 |            172 | Sword Blade   | dark     |    4 |      0 |
| Pawniard   |       624 |      5 |    102 |             68 | Sharp Blade   | dark     |    4 |      0 |
| Golurk     |       623 |     28 |   3300 |            169 | Automaton     | ground   |    4 |      0 |
| Golett     |       622 |     10 |    920 |             61 | Automaton     | ground   |    4 |      0 |
| Druddigon  |       621 |     16 |   1390 |            170 | Cave          | dragon   |    4 |      0 |
| Mienshao   |       620 |     14 |    355 |            179 | Martial Arts  | fighting |    4 |      0 |
| Mienfoo    |       619 |      9 |    200 |             70 | Martial Arts  | fighting |    4 |      0 |
| Stunfisk   |       618 |      7 |    110 |            165 | Trap          | ground   |    4 |      0 |
| Accelgor   |       617 |      8 |    253 |            173 | Shell Out     | bug      |    4 |      0 |
| Shelmet    |       616 |      4 |     77 |             61 | Snail         | bug      |    4 |      0 |
| Cryogonal  |       615 |     11 |   1480 |            170 | Crystallizing | ice      |    4 |      0 |
| Beartic    |       614 |     26 |   2600 |            170 | Freezing      | ice      |    4 |      0 |
| Cubchoo    |       613 |      5 |     85 |             61 | Chill         | ice      |    4 |      0 |
| Haxorus    |       612 |     18 |   1055 |            243 | Axe Jaw       | dragon   |    4 |      0 |
| Fraxure    |       611 |     10 |    360 |            144 | Axe Jaw       | dragon   |    4 |      0 |
| Axew       |       610 |      6 |    180 |             64 | Tusk          | dragon   |    4 |      0 |
| Chandelure |       609 |     10 |    343 |            234 | Luring        | ghost    |    4 |      0 |
| Lampent    |       608 |      6 |    130 |            130 | Lamp          | ghost    |    4 |      0 |
| Litwick    |       607 |      3 |     31 |             55 | Candle        | ghost    |    4 |      0 |
| Beheeyem   |       606 |     10 |    345 |            170 | Cerebral      | psychic  |    4 |      0 |
| Elgyem     |       605 |      5 |     90 |             67 | Cerebral      | psychic  |    4 |      0 |
| Eelektross |       604 |     21 |    805 |            232 | EleFish       | electric |    4 |      0 |
| Eelektrik  |       603 |     12 |    220 |            142 | EleFish       | electric |    4 |      0 |
| Tynamo     |       602 |      2 |      3 |             55 | EleFish       | electric |    4 |      0 |
| Klinklang  |       601 |      6 |    810 |            234 | Gear          | steel    |    4 |      0 |
| Klang      |       600 |      6 |    510 |            154 | Gear          | steel    |    4 |      0 |
| Klink      |       599 |      3 |    210 |             60 | Gear          | steel    |    4 |      0 |
| Ferrothorn |       598 |     10 |   1100 |            171 | Thorn Pod     | grass    |    4 |      0 |
| Ferroseed  |       597 |      6 |    188 |             61 | Thorn Seed    | grass    |    4 |      0 |
| Galvantula |       596 |      8 |    143 |            165 | EleSpider     | bug      |    4 |      0 |
| Joltik     |       595 |      1 |      6 |             64 | Attaching     | bug      |    4 |      0 |
| Alomomola  |       594 |     12 |    316 |            165 | Caring        | water    |    4 |      1 |
| Jellicent  |       593 |     22 |   1350 |            168 | Floating      | water    |    4 |      1 |
| Frillish   |       592 |     12 |    330 |             67 | Floating      | water    |    4 |      1 |
| Amoonguss  |       591 |      6 |    105 |            162 | Mushroom      | grass    |    4 |      0 |
| Foongus    |       590 |      2 |     10 |             59 | Mushroom      | grass    |    4 |      0 |
| Escavalier |       589 |     10 |    330 |            173 | Cavalry       | bug      |    4 |      0 |
| Karrablast |       588 |      5 |     59 |             63 | Clamping      | bug      |    4 |      0 |
| Emolga     |       587 |      4 |     50 |            150 | Sky Squirrel  | electric |    4 |      0 |
| Sawsbuck   |       586 |     19 |    925 |            166 | Season        | normal   |    4 |      0 |
| Deerling   |       585 |      6 |    195 |             67 | Season        | normal   |    4 |      0 |
| Vanilluxe  |       584 |     13 |    575 |            241 | Snowstorm     | ice      |    4 |      0 |
| Vanillish  |       583 |     11 |    410 |            138 | Icy Snow      | ice      |    4 |      0 |
| Vanillite  |       582 |      4 |     57 |             61 | Fresh Snow    | ice      |    4 |      0 |
| Swanna     |       581 |     13 |    242 |            166 | White Bird    | water    |    4 |      1 |
| Ducklett   |       580 |      5 |     55 |             61 | Water Bird    | water    |    4 |      1 |
| Reuniclus  |       579 |     10 |    201 |            221 | Multiplying   | psychic  |    4 |      0 |
| Duosion    |       578 |      6 |     80 |            130 | Mitosis       | psychic  |    4 |      0 |
| Solosis    |       577 |      3 |     10 |             58 | Cell          | psychic  |    4 |      0 |
| Gothitelle |       576 |     15 |    440 |            221 | Astral Body   | psychic  |    4 |      0 |
| Gothorita  |       575 |      7 |    180 |            137 | Manipulate    | psychic  |    4 |      0 |
| Gothita    |       574 |      4 |     58 |             58 | Fixation      | psychic  |    4 |      0 |
| Cinccino   |       573 |      5 |     75 |            165 | Scarf         | normal   |    4 |      0 |
| Minccino   |       572 |      4 |     58 |             60 | Chinchilla    | normal   |    4 |      0 |
| Zoroark    |       571 |     16 |    811 |            179 | Illusion Fox  | dark     |    4 |      0 |
| Zorua      |       570 |      7 |    125 |             66 | Tricky Fox    | dark     |    4 |      0 |
| Garbodor   |       569 |     19 |   1073 |            166 | Trash Heap    | poison   |    4 |      2 |
| Trubbish   |       568 |      6 |    310 |             66 | Trash Bag     | poison   |    4 |      2 |
| Archeops   |       567 |     14 |    320 |            177 | First Bird    | rock     |    4 |      0 |
| Archen     |       566 |      5 |     95 |             71 | First Bird    | rock     |    4 |      0 |
| Carracosta |       565 |     12 |    810 |            173 | Prototurtle   | water    |    4 |      1 |
| Tirtouga   |       564 |      7 |    165 |             71 | Prototurtle   | water    |    4 |      1 |
| Cofagrigus |       563 |     17 |    765 |            169 | Coffin        | ghost    |    4 |      0 |
| Yamask     |       562 |      5 |     15 |             61 | Spirit        | ghost    |    4 |      0 |
| Sigilyph   |       561 |     14 |    140 |            172 | Avianoid      | psychic  |    4 |      0 |
| Scrafty    |       560 |     11 |    300 |            171 | Hoodlum       | dark     |    4 |      0 |
| Scraggy    |       559 |      6 |    118 |             70 | Shedding      | dark     |    4 |      0 |
| Crustle    |       558 |     14 |   2000 |            166 | Stone Home    | bug      |    4 |      0 |
| Dwebble    |       557 |      3 |    145 |             65 | Rock Inn      | bug      |    4 |      0 |
| Maractus   |       556 |     10 |    280 |            161 | Cactus        | grass    |    4 |      0 |
| Darmanitan |       555 |     13 |    929 |            168 | Blazing       | fire     |    4 |      0 |
| Darumaka   |       554 |      6 |    375 |             63 | Zen Charm     | fire     |    4 |      0 |
| Krookodile |       553 |     15 |    963 |            229 | Intimidation  | ground   |    4 |      0 |
| Krokorok   |       552 |     10 |    334 |            123 | Desert Croc   | ground   |    4 |      0 |
| Sandile    |       551 |      7 |    152 |             58 | Desert Croc   | ground   |    4 |      0 |
| Basculin   |       550 |     10 |    180 |            161 | Hostile       | water    |    4 |      1 |
| Lilligant  |       549 |     11 |    163 |            168 | Flowering     | grass    |    4 |      0 |
| Petilil    |       548 |      5 |     66 |             56 | Bulb          | grass    |    4 |      0 |
| Whimsicott |       547 |      7 |     66 |            168 | Windveiled    | grass    |    4 |      0 |
| Cottonee   |       546 |      3 |      6 |             56 | Cotton Puff   | grass    |    4 |      0 |
| Scolipede  |       545 |     25 |   2005 |            214 | Megapede      | bug      |    4 |      0 |
| Whirlipede |       544 |     12 |    585 |            126 | Curlipede     | bug      |    4 |      0 |
| Venipede   |       543 |      4 |     53 |             52 | Centipede     | bug      |    4 |      0 |
| Leavanny   |       542 |     12 |    205 |            221 | Nurturing     | bug      |    4 |      0 |
| Swadloon   |       541 |      5 |     73 |            133 | Leaf-Wrapped  | bug      |    4 |      0 |
| Sewaddle   |       540 |      3 |     25 |             62 | Sewing        | bug      |    4 |      0 |
| Sawk       |       539 |     14 |    510 |            163 | Karate        | fighting |    4 |      0 |
| Throh      |       538 |     13 |    555 |            163 | Judo          | fighting |    4 |      0 |
| Seismitoad |       537 |     15 |    620 |            225 | Vibration     | water    |    4 |      1 |
| Palpitoad  |       536 |      8 |    170 |            134 | Vibration     | water    |    4 |      1 |
| Tympole    |       535 |      5 |     45 |             59 | Tadpole       | water    |    4 |      1 |
| Conkeldurr |       534 |     14 |    870 |            227 | Muscular      | fighting |    4 |      0 |
| Gurdurr    |       533 |     12 |    400 |            142 | Muscular      | fighting |    4 |      0 |
| Timburr    |       532 |      6 |    125 |             61 | Muscular      | fighting |    4 |      0 |
| Audino     |       531 |     11 |    310 |            390 | Hearing       | normal   |    4 |      0 |
| Excadrill  |       530 |      7 |    404 |            178 | Subterrene    | ground   |    4 |      0 |
| Drilbur    |       529 |      3 |     85 |             66 | Mole          | ground   |    4 |      0 |
| Swoobat    |       528 |      9 |    105 |            149 | Courting      | psychic  |    4 |      0 |
| Woobat     |       527 |      4 |     21 |             63 | Bat           | psychic  |    4 |      0 |
| Gigalith   |       526 |     17 |   2600 |            227 | Compressed    | rock     |    4 |      0 |
| Boldore    |       525 |      9 |   1020 |            137 | Ore           | rock     |    4 |      0 |
| Roggenrola |       524 |      4 |    180 |             56 | Mantle        | rock     |    4 |      0 |
| Zebstrika  |       523 |     16 |    795 |            174 | Thunderbolt   | electric |    4 |      0 |
| Blitzle    |       522 |      8 |    298 |             59 | Electrified   | electric |    4 |      0 |
| Unfezant   |       521 |     12 |    290 |            215 | Proud         | normal   |    4 |      0 |
| Tranquill  |       520 |      6 |    150 |            125 | Wild Pigeon   | normal   |    4 |      0 |
| Pidove     |       519 |      3 |     21 |             53 | Tiny Pigeon   | normal   |    4 |      0 |
| Musharna   |       518 |     11 |    605 |            170 | Drowsing      | psychic  |    4 |      0 |
| Munna      |       517 |      6 |    233 |             58 | Dream Eater   | psychic  |    4 |      0 |
| Simipour   |       516 |     10 |    290 |            174 | Geyser        | water    |    4 |      1 |
| Panpour    |       515 |      6 |    135 |             63 | Spray         | water    |    4 |      1 |
| Simisear   |       514 |     10 |    280 |            174 | Ember         | fire     |    4 |      0 |
| Pansear    |       513 |      6 |    110 |             63 | High Temp     | fire     |    4 |      0 |
| Simisage   |       512 |     11 |    305 |            174 | Thorn Monkey  | grass    |    4 |      0 |
| Pansage    |       511 |      6 |    105 |             63 | Grass Monkey  | grass    |    4 |      0 |
| Liepard    |       510 |     11 |    375 |            156 | Cruel         | dark     |    4 |      0 |
| Purrloin   |       509 |      4 |    101 |             56 | Devious       | dark     |    4 |      0 |
| Stoutland  |       508 |     12 |    610 |            221 | Big-Hearted   | normal   |    4 |      0 |
| Herdier    |       507 |      9 |    147 |            130 | Loyal Dog     | normal   |    4 |      0 |
| Lillipup   |       506 |      4 |     41 |             55 | Puppy         | normal   |    4 |      0 |
| Watchog    |       505 |     11 |    270 |            147 | Lookout       | normal   |    4 |      0 |
| Patrat     |       504 |      5 |    116 |             51 | Scout         | normal   |    4 |      0 |
| Samurott   |       503 |     15 |    946 |            238 | Formidable    | water    |    4 |      1 |
| Dewott     |       502 |      8 |    245 |            145 | Discipline    | water    |    4 |      1 |
| Oshawott   |       501 |      5 |     59 |             28 | Sea Otter     | water    |    4 |      1 |
| Emboar     |       500 |     16 |   1500 |            238 | Mega Fire Pig | fire     |    4 |      0 |
| Pignite    |       499 |     10 |    555 |            146 | Fire Pig      | fire     |    4 |      0 |
| Tepig      |       498 |      5 |     99 |             28 | Fire Pig      | fire     |    4 |      0 |
| Serperior  |       497 |     33 |    630 |            238 | Regal         | grass    |    4 |      0 |
| Servine    |       496 |      8 |    160 |            145 | Grass Snake   | grass    |    4 |      0 |
| Snivy      |       495 |      6 |     81 |             28 | Grass Snake   | grass    |    4 |      0 |
| Victini    |       494 |      4 |     40 |            270 | Victory       | psychic  |    4 |      0 |
| Arceus     |       493 |     32 |   3200 |            255 | Alpha         | normal   |    4 |      0 |
| Shaymin    |       492 |      2 |     21 |             64 | Gratitude     | grass    |    4 |      0 |
| Darkrai    |       491 |     15 |    505 |            210 | Pitch-Black   | dark     |    4 |      0 |
| Manaphy    |       490 |      3 |     14 |            215 | Seafaring     | water    |    4 |      1 |
| Phione     |       489 |      4 |     31 |            165 | Sea Drifter   | water    |    4 |      1 |
| Cresselia  |       488 |     15 |    856 |            210 | Lunar         | psychic  |    4 |      0 |
| Giratina   |       487 |     45 |   7500 |            220 | Renegade      | ghost    |    4 |      0 |
| Regigigas  |       486 |     37 |   4200 |            220 | Colossal      | normal   |    4 |      0 |
| Heatran    |       485 |     17 |   4300 |            215 | Lava Dome     | fire     |    4 |      0 |
| Palkia     |       484 |     42 |   3360 |            220 | Spatial       | water    |    4 |      1 |
| Dialga     |       483 |     54 |   6830 |            220 | Temporal      | steel    |    4 |      0 |
| Azelf      |       482 |      3 |      3 |            210 | Willpower     | psychic  |    4 |      0 |
| Mesprit    |       481 |      3 |      3 |            210 | Emotion       | psychic  |    4 |      0 |
| Uxie       |       480 |      3 |      3 |            210 | Knowledge     | psychic  |    4 |      0 |
| Rotom      |       479 |      3 |      3 |            132 | Plasma        | electric |    4 |      0 |
| Froslass   |       478 |     13 |    266 |            187 | Snow Land     | ice      |    4 |      0 |
| Dusknoir   |       477 |     22 |   1066 |            210 | Gripper       | ghost    |    4 |      0 |
| Probopass  |       476 |     14 |   3400 |            198 | Compass       | rock     |    4 |      0 |
| Gallade    |       475 |     16 |    520 |            208 | Blade         | psychic  |    4 |      0 |
| Porygon-Z  |       474 |      9 |    340 |            185 | Virtual       | normal   |    4 |      0 |
| Mamoswine  |       473 |     25 |   2910 |            207 | Twin Tusk     | ice      |    4 |      0 |
| Gliscor    |       472 |     20 |    425 |            192 | Fang Scorp    | ground   |    4 |      0 |
| Glaceon    |       471 |      8 |    259 |            196 | Fresh Snow    | ice      |    4 |      0 |
| Leafeon    |       470 |     10 |    255 |            196 | Verdant       | grass    |    4 |      0 |
| Yanmega    |       469 |     19 |    515 |            198 | Ogre Darner   | bug      |    4 |      0 |
| Togekiss   |       468 |     15 |    380 |            220 | Jubilee       | normal   |    4 |      0 |
| Magmortar  |       467 |     16 |    680 |            199 | Blast         | fire     |    4 |      0 |
| Electivire |       466 |     18 |   1386 |            199 | Thunderbolt   | electric |    4 |      0 |
| Tangrowth  |       465 |     20 |   1286 |            211 | Vine          | grass    |    4 |      0 |
| Rhyperior  |       464 |     24 |   2828 |            217 | Drill         | ground   |    4 |      0 |
| Lickilicky |       463 |     17 |   1400 |            193 | Licking       | normal   |    4 |      0 |
| Magnezone  |       462 |     12 |   1800 |            211 | Magnet Area   | electric |    4 |      0 |
| Weavile    |       461 |     11 |    340 |            199 | Sharp Claw    | dark     |    4 |      0 |
| Abomasnow  |       460 |     22 |   1355 |            214 | Frost Tree    | grass    |    4 |      0 |
| Snover     |       459 |     10 |    505 |            131 | Frost Tree    | grass    |    4 |      0 |
| Mantyke    |       458 |     10 |    650 |            108 | Kite          | water    |    4 |      1 |
| Lumineon   |       457 |     12 |    240 |            156 | Neon          | water    |    4 |      1 |
| Finneon    |       456 |      4 |     70 |             90 | Wing Fish     | water    |    4 |      1 |
| Carnivine  |       455 |     14 |    270 |            164 | Bug Catcher   | grass    |    4 |      0 |
| Toxicroak  |       454 |     13 |    444 |            181 | Toxic Mouth   | poison   |    4 |      2 |
| Croagunk   |       453 |      7 |    230 |             83 | Toxic Mouth   | poison   |    4 |      2 |
| Drapion    |       452 |     13 |    615 |            204 | Ogre Scorp    | poison   |    4 |      2 |
| Skorupi    |       451 |      8 |    120 |            114 | Scorpion      | poison   |    4 |      2 |
| Hippowdon  |       450 |     20 |   3000 |            198 | Heavyweight   | ground   |    3 |      0 |
| Hippopotas |       449 |      8 |    495 |             95 | Hippo         | ground   |    3 |      0 |
| Lucario    |       448 |     12 |    540 |            204 | Aura          | fighting |    3 |      0 |
| Riolu      |       447 |      7 |    202 |             72 | Emanation     | fighting |    3 |      0 |
| Munchlax   |       446 |      6 |   1050 |             94 | Big Eater     | normal   |    3 |      0 |
| Garchomp   |       445 |     19 |    950 |            218 | Mach          | dragon   |    3 |      0 |
| Gabite     |       444 |     14 |    560 |            144 | Cave          | dragon   |    3 |      0 |
| Gible      |       443 |      7 |    205 |             67 | Land Shark    | dragon   |    3 |      0 |
| Spiritomb  |       442 |     10 |   1080 |            168 | Forbidden     | ghost    |    3 |      0 |
| Chatot     |       441 |      5 |     19 |            107 | Music Note    | normal   |    3 |      0 |
| Happiny    |       440 |      6 |    244 |            255 | Playhouse     | normal   |    3 |      0 |
| Mime Jr.   |       439 |      6 |    130 |             78 | Mime          | psychic  |    3 |      0 |
| Bonsly     |       438 |      5 |    150 |             68 | Bonsai        | rock     |    3 |      0 |
| Bronzong   |       437 |     13 |   1870 |            188 | Bronze Bell   | steel    |    3 |      0 |
| Bronzor    |       436 |      5 |    605 |             72 | Bronze        | steel    |    3 |      0 |
| Skuntank   |       435 |     10 |    380 |            209 | Skunk         | poison   |    3 |      2 |
| Stunky     |       434 |      4 |    192 |             79 | Skunk         | poison   |    3 |      2 |
| Chingling  |       433 |      2 |      6 |             74 | Bell          | psychic  |    3 |      0 |
| Purugly    |       432 |     10 |    438 |            183 | Tiger Cat     | normal   |    3 |      0 |
| Glameow    |       431 |      5 |     39 |             71 | Catty         | normal   |    3 |      0 |
| Honchkrow  |       430 |      9 |    273 |            187 | Big Boss      | dark     |    3 |      0 |
| Mismagius  |       429 |      9 |     44 |            187 | Magical       | ghost    |    3 |      0 |
| Lopunny    |       428 |     12 |    333 |            178 | Rabbit        | normal   |    3 |      0 |
| Buneary    |       427 |      4 |     55 |             84 | Rabbit        | normal   |    3 |      0 |
| Drifblim   |       426 |     12 |    150 |            204 | Blimp         | ghost    |    3 |      0 |
| Drifloon   |       425 |      4 |     12 |            127 | Balloon       | ghost    |    3 |      0 |
| Ambipom    |       424 |     12 |    203 |            186 | Long Tail     | normal   |    3 |      0 |
| Gastrodon  |       423 |      9 |    299 |            176 | Sea Slug      | water    |    3 |      1 |
| Shellos    |       422 |      3 |     63 |             73 | Sea Slug      | water    |    3 |      1 |
| Cherrim    |       421 |      5 |     93 |            133 | Blossom       | grass    |    3 |      0 |
| Cherubi    |       420 |      4 |     33 |             68 | Cherry        | grass    |    3 |      0 |
| Floatzel   |       419 |     11 |    335 |            178 | Sea Weasel    | water    |    3 |      1 |
| Buizel     |       418 |      7 |    295 |             75 | Sea Weasel    | water    |    3 |      1 |
| Pachirisu  |       417 |      4 |     39 |            120 | EleSquirrel   | electric |    3 |      0 |
| Vespiquen  |       416 |     12 |    385 |            188 | Beehive       | bug      |    3 |      0 |
| Combee     |       415 |      3 |     55 |             63 | Tiny Bee      | bug      |    3 |      0 |
| Mothim     |       414 |      9 |    233 |            159 | Moth          | bug      |    3 |      0 |
| Wormadam   |       413 |      5 |     65 |            159 | Bagworm       | bug      |    3 |      0 |
| Burmy      |       412 |      2 |     34 |             61 | Bagworm       | bug      |    3 |      0 |
| Bastiodon  |       411 |     13 |   1495 |            199 | Shield        | rock     |    3 |      0 |
| Shieldon   |       410 |      5 |    570 |             99 | Shield        | rock     |    3 |      0 |
| Rampardos  |       409 |     16 |   1025 |            199 | Head Butt     | rock     |    3 |      0 |
| Cranidos   |       408 |      9 |    315 |             99 | Head Butt     | rock     |    3 |      0 |
| Roserade   |       407 |      9 |    145 |            204 | Bouquet       | grass    |    3 |      0 |
| Budew      |       406 |      2 |     12 |             68 | Bud           | grass    |    3 |      0 |
| Luxray     |       405 |     14 |    420 |            194 | Gleam Eyes    | electric |    3 |      0 |
| Luxio      |       404 |      9 |    305 |            117 | Spark         | electric |    3 |      0 |
| Shinx      |       403 |      5 |     95 |             60 | Flash         | electric |    3 |      0 |
| Kricketune |       402 |     10 |    255 |            159 | Cricket       | bug      |    3 |      0 |
| Kricketot  |       401 |      3 |     22 |             54 | Cricket       | bug      |    3 |      0 |
| Bibarel    |       400 |     10 |    315 |            116 | Beaver        | normal   |    3 |      0 |
| Bidoof     |       399 |      5 |    200 |             58 | Plump Mouse   | normal   |    3 |      0 |
| Staraptor  |       398 |     12 |    249 |            172 | Predator      | normal   |    3 |      0 |
| Staravia   |       397 |      6 |    155 |            113 | Starling      | normal   |    3 |      0 |
| Starly     |       396 |      3 |     20 |             56 | Starling      | normal   |    3 |      0 |
| Empoleon   |       395 |     17 |    845 |            210 | Emperor       | water    |    3 |      1 |
| Prinplup   |       394 |      8 |    230 |            143 | Penguin       | water    |    3 |      1 |
| Piplup     |       393 |      4 |     52 |             66 | Penguin       | water    |    3 |      1 |
| Infernape  |       392 |     12 |    550 |            209 | Flame         | fire     |    3 |      0 |
| Monferno   |       391 |      9 |    220 |            142 | Playful       | fire     |    3 |      0 |
| Chimchar   |       390 |      5 |     62 |             65 | Chimp         | fire     |    3 |      0 |
| Torterra   |       389 |     22 |   3100 |            208 | Continent     | grass    |    3 |      0 |
| Grotle     |       388 |     11 |    970 |            141 | Grove         | grass    |    3 |      0 |
| Turtwig    |       387 |      4 |    102 |             64 | Tiny Leaf     | grass    |    3 |      0 |
| Deoxys     |       386 |     17 |    608 |            215 | DNA           | psychic  |    3 |      0 |
| Jirachi    |       385 |      3 |     11 |            215 | Wish          | steel    |    3 |      0 |
| Rayquaza   |       384 |     70 |   2065 |            220 | Sky High      | dragon   |    3 |      0 |
| Groudon    |       383 |     35 |   9500 |            218 | Continent     | ground   |    3 |      0 |
| Kyogre     |       382 |     45 |   3520 |            218 | Sea Basin     | water    |    3 |      1 |
| Latios     |       381 |     20 |    600 |            211 | Eon           | dragon   |    3 |      0 |
| Latias     |       380 |     14 |    400 |            211 | Eon           | dragon   |    3 |      0 |
| Registeel  |       379 |     19 |   2050 |            215 | Iron          | steel    |    3 |      0 |
| Regice     |       378 |     18 |   1750 |            216 | Iceberg       | ice      |    3 |      0 |
| Regirock   |       377 |     17 |   2300 |            217 | Rock Peak     | rock     |    3 |      0 |
| Metagross  |       376 |     16 |   5500 |            210 | Iron Leg      | steel    |    3 |      0 |
| Metang     |       375 |     12 |   2025 |            153 | Iron Claw     | steel    |    3 |      0 |
| Beldum     |       374 |      6 |    952 |            103 | Iron Ball     | steel    |    3 |      0 |
| Salamence  |       373 |     15 |   1026 |            218 | Dragon        | dragon   |    3 |      0 |
| Shelgon    |       372 |     11 |   1105 |            144 | Endurance     | dragon   |    3 |      0 |
| Bagon      |       371 |      6 |    421 |             89 | Rock Head     | dragon   |    3 |      0 |
| Luvdisc    |       370 |      6 |     87 |            110 | Rendezvous    | water    |    3 |      1 |
| Relicanth  |       369 |     10 |    234 |            198 | Longevity     | water    |    3 |      1 |
| Gorebyss   |       368 |     18 |    226 |            178 | South Sea     | water    |    3 |      1 |
| Huntail    |       367 |     17 |    270 |            178 | Deep Sea      | water    |    3 |      1 |
| Clamperl   |       366 |      4 |    525 |            142 | Bivalve       | water    |    3 |      1 |
| Walrein    |       365 |     14 |   1506 |            192 | Ice Break     | ice      |    3 |      0 |
| Sealeo     |       364 |     11 |    876 |            128 | Ball Roll     | ice      |    3 |      0 |
| Spheal     |       363 |      8 |    395 |             75 | Clap          | ice      |    3 |      0 |
| Glalie     |       362 |     15 |   2565 |            187 | Face          | ice      |    3 |      0 |
| Snorunt    |       361 |      7 |    168 |             74 | Snow Hat      | ice      |    3 |      0 |
| Wynaut     |       360 |      6 |    140 |             44 | Bright        | psychic  |    3 |      0 |
| Absol      |       359 |     12 |    470 |            174 | Disaster      | dark     |    3 |      0 |
| Chimecho   |       358 |      6 |     10 |            147 | Wind Chime    | psychic  |    3 |      0 |
| Tropius    |       357 |     20 |   1000 |            169 | Fruit         | grass    |    3 |      0 |
| Dusclops   |       356 |     16 |    306 |            179 | Beckon        | ghost    |    3 |      0 |
| Duskull    |       355 |      8 |    150 |             97 | Requiem       | ghost    |    3 |      0 |
| Banette    |       354 |     11 |    125 |            179 | Marionette    | ghost    |    3 |      0 |
| Shuppet    |       353 |      6 |     23 |             97 | Puppet        | ghost    |    3 |      0 |
| Kecleon    |       352 |     10 |    220 |            132 | Color Swap    | normal   |    3 |      0 |
| Castform   |       351 |      3 |      8 |            145 | Weather       | normal   |    3 |      0 |
| Milotic    |       350 |     62 |   1620 |            213 | Tender        | water    |    3 |      1 |
| Feebas     |       349 |      6 |     74 |             61 | Fish          | water    |    3 |      1 |
| Armaldo    |       348 |     15 |    682 |            199 | Plate         | rock     |    3 |      0 |
| Anorith    |       347 |      7 |    125 |             99 | Old Shrimp    | rock     |    3 |      0 |
| Cradily    |       346 |     15 |    604 |            199 | Barnacle      | rock     |    3 |      0 |
| Lileep     |       345 |     10 |    238 |             99 | Sea Lily      | rock     |    3 |      0 |
| Claydol    |       344 |     15 |   1080 |            189 | Clay Doll     | ground   |    3 |      0 |
| Baltoy     |       343 |      5 |    215 |             58 | Clay Doll     | ground   |    3 |      0 |
| Crawdaunt  |       342 |     11 |    328 |            161 | Rogue         | water    |    3 |      1 |
| Corphish   |       341 |      6 |    115 |            111 | Ruffian       | water    |    3 |      1 |
| Whiscash   |       340 |      9 |    236 |            158 | Whiskers      | water    |    3 |      1 |
| Barboach   |       339 |      4 |     19 |             92 | Whiskers      | water    |    3 |      1 |
| Solrock    |       338 |     12 |   1540 |            150 | Meteorite     | rock     |    3 |      0 |
| Lunatone   |       337 |     10 |   1680 |            150 | Meteorite     | rock     |    3 |      0 |
| Seviper    |       336 |     27 |    525 |            165 | Fang Snake    | poison   |    3 |      2 |
| Zangoose   |       335 |     13 |    403 |            165 | Cat Ferret    | normal   |    3 |      0 |
| Altaria    |       334 |     11 |    206 |            188 | Humming       | dragon   |    3 |      0 |
| Swablu     |       333 |      4 |     12 |             74 | Cotton Bird   | normal   |    3 |      0 |
| Cacturne   |       332 |     13 |    774 |            177 | Scarecrow     | grass    |    3 |      0 |
| Cacnea     |       331 |      4 |    513 |             97 | Cactus        | grass    |    3 |      0 |
| Flygon     |       330 |     20 |    820 |            197 | Mystic        | ground   |    3 |      0 |
| Vibrava    |       329 |     11 |    153 |            126 | Vibration     | ground   |    3 |      0 |
| Trapinch   |       328 |      7 |    150 |             73 | Ant Pit       | ground   |    3 |      0 |
| Spinda     |       327 |     11 |     50 |             85 | Spot Panda    | normal   |    3 |      0 |
| Grumpig    |       326 |      9 |    715 |            164 | Manipulate    | psychic  |    3 |      0 |
| Spoink     |       325 |      7 |    306 |             89 | Bounce        | psychic  |    3 |      0 |
| Torkoal    |       324 |      5 |    804 |            161 | Coal          | fire     |    3 |      0 |
| Camerupt   |       323 |     19 |   2200 |            175 | Eruption      | fire     |    3 |      0 |
| Numel      |       322 |      7 |    240 |             88 | Numb          | fire     |    3 |      0 |
| Wailord    |       321 |    145 |   3980 |            206 | Float Whale   | water    |    3 |      1 |
| Wailmer    |       320 |     20 |   1300 |            137 | Ball Whale    | water    |    3 |      1 |
| Sharpedo   |       319 |     18 |    888 |            175 | Brutal        | water    |    3 |      1 |
| Carvanha   |       318 |      8 |    208 |             88 | Savage        | water    |    3 |      1 |
| Swalot     |       317 |     17 |    800 |            168 | Poison Bag    | poison   |    3 |      2 |
| Gulpin     |       316 |      4 |    103 |             75 | Stomach       | poison   |    3 |      2 |
| Roselia    |       315 |      3 |     20 |            152 | Thorn         | grass    |    3 |      0 |
| Illumise   |       314 |      6 |    177 |            146 | Firefly       | bug      |    3 |      0 |
| Volbeat    |       313 |      7 |    177 |            146 | Firefly       | bug      |    3 |      0 |
| Minun      |       312 |      4 |     42 |            120 | Cheering      | electric |    3 |      0 |
| Plusle     |       311 |      4 |     42 |            120 | Cheering      | electric |    3 |      0 |
| Manectric  |       310 |     15 |    402 |            168 | Discharge     | electric |    3 |      0 |
| Electrike  |       309 |      6 |    152 |            104 | Lightning     | electric |    3 |      0 |
| Medicham   |       308 |     13 |    315 |            153 | Meditate      | fighting |    3 |      0 |
| Meditite   |       307 |      6 |    112 |             91 | Meditate      | fighting |    3 |      0 |
| Aggron     |       306 |     21 |   3600 |            205 | Iron Armor    | steel    |    3 |      0 |
| Lairon     |       305 |      9 |   1200 |            152 | Iron Armor    | steel    |    3 |      0 |
| Aron       |       304 |      4 |    600 |             96 | Iron Armor    | steel    |    3 |      0 |
| Mawile     |       303 |      6 |    115 |             98 | Deceiver      | steel    |    3 |      0 |
| Sableye    |       302 |      5 |    110 |             98 | Darkness      | dark     |    3 |      0 |
| Delcatty   |       301 |     11 |    326 |            138 | Prim          | normal   |    3 |      0 |
| Skitty     |       300 |      6 |    110 |             65 | Kitten        | normal   |    2 |      0 |
| Nosepass   |       299 |     10 |    970 |            108 | Compass       | rock     |    2 |      0 |
| Azurill    |       298 |      2 |     20 |             33 | Polka Dot     | normal   |    2 |      0 |
| Hariyama   |       297 |     23 |   2538 |            184 | Arm Thrust    | fighting |    2 |      0 |
| Makuhita   |       296 |     10 |    864 |             87 | Guts          | fighting |    2 |      0 |
| Exploud    |       295 |     15 |    840 |            184 | Loud Noise    | normal   |    2 |      0 |
| Loudred    |       294 |     10 |    405 |            126 | Big Voice     | normal   |    2 |      0 |
| Whismur    |       293 |      6 |    163 |             68 | Whisper       | normal   |    2 |      0 |
| Shedinja   |       292 |      8 |     12 |             95 | Shed          | bug      |    2 |      0 |
| Ninjask    |       291 |      8 |    120 |            155 | Ninja         | bug      |    2 |      0 |
| Nincada    |       290 |      5 |     55 |             65 | Trainee       | bug      |    2 |      0 |
| Slaking    |       289 |     20 |   1305 |            210 | Lazy          | normal   |    2 |      0 |
| Vigoroth   |       288 |     14 |    465 |            126 | Wild Monkey   | normal   |    2 |      0 |
| Slakoth    |       287 |      8 |    240 |             83 | Slacker       | normal   |    2 |      0 |
| Breloom    |       286 |     12 |    392 |            165 | Mushroom      | grass    |    2 |      0 |
| Shroomish  |       285 |      4 |     45 |             65 | Mushroom      | grass    |    2 |      0 |
| Masquerain |       284 |      8 |     36 |            128 | Eyeball       | bug      |    2 |      0 |
| Surskit    |       283 |      5 |     17 |             63 | Pond Skater   | bug      |    2 |      0 |
| Gardevoir  |       282 |     16 |    484 |            208 | Embrace       | psychic  |    2 |      0 |
| Kirlia     |       281 |      8 |    202 |            140 | Emotion       | psychic  |    2 |      0 |
| Ralts      |       280 |      4 |     66 |             70 | Feeling       | psychic  |    2 |      0 |
| Pelipper   |       279 |     12 |    280 |            164 | Water Bird    | water    |    2 |      1 |
| Wingull    |       278 |      6 |     95 |             64 | Seagull       | water    |    2 |      1 |
| Swellow    |       277 |      7 |    198 |            162 | Swallow       | normal   |    2 |      0 |
| Taillow    |       276 |      3 |     23 |             59 | TinySwallow   | normal   |    2 |      0 |
| Shiftry    |       275 |     13 |    596 |            181 | Wicked        | grass    |    2 |      0 |
| Nuzleaf    |       274 |     10 |    280 |            141 | Wily          | grass    |    2 |      0 |
| Seedot     |       273 |      5 |     40 |             74 | Acorn         | grass    |    2 |      0 |
| Ludicolo   |       272 |     15 |    550 |            181 | Carefree      | water    |    2 |      1 |
| Lombre     |       271 |     12 |    325 |            141 | Jolly         | water    |    2 |      1 |
| Lotad      |       270 |      5 |     26 |             74 | Water Weed    | water    |    2 |      1 |
| Dustox     |       269 |     12 |    316 |            161 | Poison Moth   | bug      |    2 |      0 |
| Cascoon    |       268 |      7 |    115 |             72 | Cocoon        | bug      |    2 |      0 |
| Beautifly  |       267 |     10 |    284 |            161 | Butterfly     | bug      |    2 |      0 |
| Silcoon    |       266 |      6 |    100 |             72 | Cocoon        | bug      |    2 |      0 |
| Wurmple    |       265 |      3 |     36 |             54 | Worm          | bug      |    2 |      0 |
| Linoone    |       264 |      5 |    325 |            128 | Rushing       | normal   |    2 |      0 |
| Zigzagoon  |       263 |      4 |    175 |             60 | TinyRaccoon   | normal   |    2 |      0 |
| Mightyena  |       262 |     10 |    370 |            128 | Bite          | dark     |    2 |      0 |
| Poochyena  |       261 |      5 |    136 |             55 | Bite          | dark     |    2 |      0 |
| Swampert   |       260 |     15 |    819 |            210 | Mud Fish      | water    |    2 |      1 |
| Marshtomp  |       259 |      7 |    280 |            143 | Mud Fish      | water    |    2 |      1 |
| Mudkip     |       258 |      4 |     76 |             65 | Mud Fish      | water    |    2 |      1 |
| Blaziken   |       257 |     19 |    520 |            209 | Blaze         | fire     |    2 |      0 |
| Combusken  |       256 |      9 |    195 |            142 | Young Fowl    | fire     |    2 |      0 |
| Torchic    |       255 |      4 |     25 |             65 | Chick         | fire     |    2 |      0 |
| Sceptile   |       254 |     17 |    522 |            208 | Forest        | grass    |    2 |      0 |
| Grovyle    |       253 |      9 |    216 |            141 | Wood Gecko    | grass    |    2 |      0 |
| Treecko    |       252 |      5 |     50 |             65 | Wood Gecko    | grass    |    2 |      0 |
| Celebi     |       251 |      6 |     50 |             64 | Time Travel   | psychic  |    2 |      0 |
| Ho-Oh      |       250 |     38 |   1990 |            220 | Rainbow       | fire     |    2 |      0 |
| Lugia      |       249 |     52 |   2160 |            220 | Diving        | psychic  |    2 |      0 |
| Tyranitar  |       248 |     20 |   2020 |            218 | Armor         | rock     |    2 |      0 |
| Pupitar    |       247 |     12 |   1520 |            144 | Hard Shell    | rock     |    2 |      0 |
| Larvitar   |       246 |      6 |    720 |             67 | Rock Skin     | rock     |    2 |      0 |
| Suicune    |       245 |     20 |   1870 |            215 | Aurora        | water    |    2 |      1 |
| Entei      |       244 |     21 |   1980 |            217 | Volcano       | fire     |    2 |      0 |
| Raikou     |       243 |     19 |   1780 |            216 | Thunder       | electric |    2 |      0 |
| Blissey    |       242 |     15 |    468 |            255 | Happiness     | normal   |    2 |      0 |
| Miltank    |       241 |     12 |    755 |            200 | Milk Cow      | normal   |    2 |      0 |
| Magby      |       240 |      7 |    214 |            117 | Live Coal     | fire     |    2 |      0 |
| Elekid     |       239 |      6 |    235 |            106 | Electric      | electric |    2 |      0 |
| Smoochum   |       238 |      4 |     60 |             87 | Kiss          | ice      |    2 |      0 |
| Hitmontop  |       237 |     14 |    480 |            138 | Handstand     | fighting |    2 |      0 |
| Tyrogue    |       236 |      7 |    210 |             91 | Scuffle       | fighting |    2 |      0 |
| Smeargle   |       235 |     12 |    580 |            106 | Painter       | normal   |    2 |      0 |
| Stantler   |       234 |     14 |    712 |            165 | Big Horn      | normal   |    2 |      0 |
| Porygon2   |       233 |      6 |    325 |            180 | Virtual       | normal   |    2 |      0 |
| Donphan    |       232 |     11 |   1200 |            189 | Armor         | ground   |    2 |      0 |
| Phanpy     |       231 |      5 |    335 |            124 | Long Nose     | ground   |    2 |      0 |
| Kingdra    |       230 |     18 |   1520 |            207 | Dragon        | water    |    2 |      1 |
| Houndoom   |       229 |     14 |    350 |            204 | Dark          | dark     |    2 |      0 |
| Houndour   |       228 |      6 |    108 |            114 | Dark          | dark     |    2 |      0 |
| Skarmory   |       227 |     17 |    505 |            168 | Armor Bird    | steel    |    2 |      0 |
| Mantine    |       226 |     21 |   2200 |            168 | Kite          | water    |    2 |      1 |
| Delibird   |       225 |      9 |    160 |            183 | Delivery      | ice      |    2 |      0 |
| Octillery  |       224 |      9 |    285 |            164 | Jet           | water    |    2 |      1 |
| Remoraid   |       223 |      6 |    120 |             78 | Jet           | water    |    2 |      1 |
| Corsola    |       222 |      6 |     50 |            113 | Coral         | water    |    2 |      1 |
| Piloswine  |       221 |     11 |    558 |            160 | Swine         | ice      |    2 |      0 |
| Swinub     |       220 |      4 |     65 |             78 | Pig           | ice      |    2 |      0 |
| Magcargo   |       219 |      8 |    550 |            154 | Lava          | fire     |    2 |      0 |
| Slugma     |       218 |      7 |    350 |             78 | Lava          | fire     |    2 |      0 |
| Ursaring   |       217 |     18 |   1258 |            189 | Hibernator    | normal   |    2 |      0 |
| Teddiursa  |       216 |      6 |     88 |            124 | Little Bear   | normal   |    2 |      0 |
| Sneasel    |       215 |      9 |    280 |            132 | Sharp Claw    | dark     |    2 |      0 |
| Heracross  |       214 |     15 |    540 |            200 | Single Horn   | bug      |    2 |      0 |
| Shuckle    |       213 |      6 |    205 |             80 | Mold          | bug      |    2 |      0 |
| Scizor     |       212 |     18 |   1180 |            200 | Pincer        | bug      |    2 |      0 |
| Qwilfish   |       211 |      5 |     39 |            100 | Balloon       | water    |    2 |      1 |
| Granbull   |       210 |     14 |    487 |            178 | Fairy         | normal   |    2 |      0 |
| Snubbull   |       209 |      6 |     78 |             63 | Fairy         | normal   |    2 |      0 |
| Steelix    |       208 |     92 |   4000 |            196 | Iron Snake    | steel    |    2 |      0 |
| Gligar     |       207 |     11 |    648 |            108 | FlyScorpion   | ground   |    2 |      0 |
| Dunsparce  |       206 |     15 |    140 |            125 | Land Snake    | normal   |    2 |      0 |
| Forretress |       205 |     12 |   1258 |            118 | Bagworm       | bug      |    2 |      0 |
| Pineco     |       204 |      6 |     72 |             60 | Bagworm       | bug      |    2 |      0 |
| Girafarig  |       203 |     15 |    415 |            149 | Long Neck     | normal   |    2 |      0 |
| Wobbuffet  |       202 |     13 |    285 |            177 | Patient       | psychic  |    2 |      0 |
| Unown      |       201 |      5 |     50 |             61 | Symbol        | psychic  |    2 |      0 |
| Misdreavus |       200 |      7 |     10 |            147 | Screech       | ghost    |    2 |      0 |
| Slowking   |       199 |     20 |    795 |            164 | Royal         | water    |    2 |      1 |
| Murkrow    |       198 |      5 |     21 |            107 | Darkness      | dark     |    2 |      0 |
| Umbreon    |       197 |     10 |    270 |            197 | Moonlight     | dark     |    2 |      0 |
| Espeon     |       196 |      9 |    265 |            197 | Sun           | psychic  |    2 |      0 |
| Quagsire   |       195 |     14 |    750 |            137 | Water Fish    | water    |    2 |      1 |
| Wooper     |       194 |      4 |     85 |             52 | Water Fish    | water    |    2 |      1 |
| Yanma      |       193 |     12 |    380 |            147 | Clear Wing    | bug      |    2 |      0 |
| Sunflora   |       192 |      8 |     85 |            146 | Sun           | grass    |    2 |      0 |
| Sunkern    |       191 |      3 |     18 |             52 | Seed          | grass    |    2 |      0 |
| Aipom      |       190 |      8 |    115 |             94 | Long Tail     | normal   |    2 |      0 |
| Jumpluff   |       189 |      8 |     30 |            176 | Cottonweed    | grass    |    2 |      0 |
| Skiploom   |       188 |      6 |     10 |            136 | Cottonweed    | grass    |    2 |      0 |
| Hoppip     |       187 |      4 |      5 |             74 | Cottonweed    | grass    |    2 |      0 |
| Politoed   |       186 |     11 |    339 |            185 | Frog          | water    |    2 |      1 |
| Sudowoodo  |       185 |     12 |    380 |            135 | Imitation     | rock     |    2 |      0 |
| Azumarill  |       184 |      8 |    285 |            153 | Aqua Rabbit   | water    |    2 |      1 |
| Marill     |       183 |      4 |     85 |             58 | Aqua Mouse    | water    |    2 |      1 |
| Bellossom  |       182 |      4 |     58 |            184 | Flower        | grass    |    2 |      0 |
| Ampharos   |       181 |     14 |    615 |            194 | Light         | electric |    2 |      0 |
| Flaaffy    |       180 |      8 |    133 |            117 | Wool          | electric |    2 |      0 |
| Mareep     |       179 |      6 |     78 |             59 | Wool          | electric |    2 |      0 |
| Xatu       |       178 |     15 |    150 |            171 | Mystic        | psychic  |    2 |      0 |
| Natu       |       177 |      2 |     20 |             73 | Tiny Bird     | psychic  |    2 |      0 |
| Togetic    |       176 |      6 |     32 |            114 | Happiness     | normal   |    2 |      0 |
| Togepi     |       175 |      3 |     15 |             74 | Spike Ball    | normal   |    2 |      0 |
| Igglybuff  |       174 |      3 |     10 |             39 | Balloon       | normal   |    2 |      0 |
| Cleffa     |       173 |      3 |     30 |             37 | Star Shape    | normal   |    2 |      0 |
| Pichu      |       172 |      3 |     20 |             42 | Tiny Mouse    | electric |    2 |      0 |
| Lanturn    |       171 |     12 |    225 |            156 | Light         | water    |    2 |      1 |
| Chinchou   |       170 |      5 |    120 |             90 | Angler        | water    |    2 |      1 |
| Crobat     |       169 |     18 |    750 |            204 | Bat           | poison   |    2 |      2 |
| Ariados    |       168 |     11 |    335 |            134 | Long Leg      | bug      |    2 |      0 |
| Spinarak   |       167 |      5 |     85 |             54 | String Spit   | bug      |    2 |      0 |
| Ledian     |       166 |     14 |    356 |            134 | Five Star     | bug      |    2 |      0 |
| Ledyba     |       165 |     10 |    108 |             54 | Five Star     | bug      |    2 |      0 |
| Noctowl    |       164 |     16 |    408 |            162 | Owl           | normal   |    2 |      0 |
| Hoothoot   |       163 |      7 |    212 |             58 | Owl           | normal   |    2 |      0 |
| Furret     |       162 |     18 |    325 |            116 | Long Body     | normal   |    2 |      0 |
| Sentret    |       161 |      8 |     60 |             57 | Scout         | normal   |    2 |      0 |
| Feraligatr |       160 |     23 |    888 |            210 | Big Jaw       | water    |    2 |      1 |
| Croconaw   |       159 |     11 |    250 |            143 | Big Jaw       | water    |    2 |      1 |
| Totodile   |       158 |      6 |     95 |             66 | Big Jaw       | water    |    2 |      1 |
| Typhlosion |       157 |     17 |    795 |            209 | Volcano       | fire     |    2 |      0 |
| Quilava    |       156 |      9 |    190 |            142 | Volcano       | fire     |    2 |      0 |
| Cyndaquil  |       155 |      5 |     79 |             65 | Fire Mouse    | fire     |    2 |      0 |
| Meganium   |       154 |     18 |   1005 |            208 | Herb          | grass    |    2 |      0 |
| Bayleef    |       153 |     12 |    158 |            141 | Leaf          | grass    |    2 |      0 |
| Chikorita  |       152 |      9 |     64 |             64 | Leaf          | grass    |    2 |      0 |
| Mew        |       151 |      4 |     40 |             64 | New Species   | psychic  |    2 |      0 |
| Mewtwo     |       150 |     20 |   1220 |            220 | Genetic       | psychic  |    1 |      0 |
| Dragonite  |       149 |     22 |   2100 |            218 | Dragon        | dragon   |    1 |      0 |
| Dragonair  |       148 |     40 |    165 |            144 | Dragon        | dragon   |    1 |      0 |
| Dratini    |       147 |     18 |     33 |             67 | Dragon        | dragon   |    1 |      0 |
| Moltres    |       146 |     20 |    600 |            217 | Flame         | fire     |    1 |      0 |
| Zapdos     |       145 |     16 |    526 |            216 | Electric      | electric |    1 |      0 |
| Articuno   |       144 |     17 |    554 |            215 | Freeze        | ice      |    1 |      0 |
| Snorlax    |       143 |     21 |   4600 |            154 | Sleeping      | normal   |    1 |      0 |
| Aerodactyl |       142 |     18 |    590 |            202 | Fossil        | rock     |    1 |      0 |
| Kabutops   |       141 |     13 |    405 |            199 | Shellfish     | rock     |    1 |      0 |
| Kabuto     |       140 |      5 |    115 |             99 | Shellfish     | rock     |    1 |      0 |
| Omastar    |       139 |     10 |    350 |            199 | Spiral        | rock     |    1 |      0 |
| Omanyte    |       138 |      4 |     75 |             99 | Spiral        | rock     |    1 |      0 |
| Porygon    |       137 |      8 |    365 |            130 | Virtual       | normal   |    1 |      0 |
| Flareon    |       136 |      9 |    250 |            198 | Flame         | fire     |    1 |      0 |
| Jolteon    |       135 |      8 |    245 |            197 | Lightning     | electric |    1 |      0 |
| Vaporeon   |       134 |     10 |    290 |            196 | Bubble Jet    | water    |    1 |      1 |
| Eevee      |       133 |      3 |     65 |             92 | Evolution     | normal   |    1 |      0 |
| Ditto      |       132 |      3 |     40 |             61 | Transform     | normal   |    1 |      0 |
| Lapras     |       131 |     25 |   2200 |            219 | Transport     | water    |    1 |      1 |
| Gyarados   |       130 |     65 |   2350 |            214 | Atrocious     | water    |    1 |      1 |
| Magikarp   |       129 |      9 |    100 |             20 | Fish          | water    |    1 |      1 |
| Tauros     |       128 |     14 |    884 |            211 | Wild Bull     | normal   |    1 |      0 |
| Pinsir     |       127 |     15 |    550 |            200 | Stag Beetle   | bug      |    1 |      0 |
| Magmar     |       126 |     13 |    445 |            167 | Spitfire      | fire     |    1 |      0 |
| Electabuzz |       125 |     11 |    300 |            156 | Electric      | electric |    1 |      0 |
| Jynx       |       124 |     14 |    406 |            137 | Human Shape   | ice      |    1 |      0 |
| Scyther    |       123 |     15 |    560 |            187 | Mantis        | bug      |    1 |      0 |
| Mr. Mime   |       122 |     13 |    545 |            136 | Barrier       | psychic  |    1 |      0 |
| Starmie    |       121 |     11 |    800 |            207 | Mysterious    | water    |    1 |      1 |
| Staryu     |       120 |      8 |    345 |            106 | Star Shape    | water    |    1 |      1 |
| Seaking    |       119 |     13 |    390 |            170 | Goldfish      | water    |    1 |      1 |
| Goldeen    |       118 |      6 |    150 |            111 | Goldfish      | water    |    1 |      1 |
| Seadra     |       117 |     12 |    250 |            155 | Dragon        | water    |    1 |      1 |
| Horsea     |       116 |      4 |     80 |             83 | Dragon        | water    |    1 |      1 |
| Kangaskhan |       115 |     22 |    800 |            175 | Parent        | normal   |    1 |      0 |
| Tangela    |       114 |     10 |    350 |            166 | Vine          | grass    |    1 |      0 |
| Chansey    |       113 |     11 |    346 |            255 | Egg           | normal   |    1 |      0 |
| Rhydon     |       112 |     19 |   1200 |            204 | Drill         | ground   |    1 |      0 |
| Rhyhorn    |       111 |     10 |   1150 |            135 | Spikes        | ground   |    1 |      0 |
| Weezing    |       110 |     12 |     95 |            173 | Poison Gas    | poison   |    1 |      2 |
| Koffing    |       109 |      6 |     10 |            114 | Poison Gas    | poison   |    1 |      2 |
| Lickitung  |       108 |     12 |    655 |            127 | Licking       | normal   |    1 |      0 |
| Hitmonchan |       107 |     14 |    502 |            140 | Punching      | fighting |    1 |      0 |
| Hitmonlee  |       106 |     15 |    498 |            139 | Kicking       | fighting |    1 |      0 |
| Marowak    |       105 |     10 |    450 |            124 | Bone Keeper   | ground   |    1 |      0 |
| Cubone     |       104 |      4 |     65 |             87 | Lonely        | ground   |    1 |      0 |
| Exeggutor  |       103 |     20 |   1200 |            212 | Coconut       | grass    |    1 |      0 |
| Exeggcute  |       102 |      4 |     25 |             98 | Egg           | grass    |    1 |      0 |
| Electrode  |       101 |     12 |    666 |            150 | Ball          | electric |    1 |      0 |
| Voltorb    |       100 |      5 |    104 |            103 | Ball          | electric |    1 |      0 |
| Kingler    |        99 |     13 |    600 |            206 | Pincer        | water    |    1 |      1 |
| Krabby     |        98 |      4 |     65 |            115 | River Crab    | water    |    1 |      1 |
| Hypno      |        97 |     16 |    756 |            165 | Hypnosis      | psychic  |    1 |      0 |
| Drowzee    |        96 |     10 |    324 |            102 | Hypnosis      | psychic  |    1 |      0 |
| Onix       |        95 |     88 |   2100 |            108 | Rock Snake    | rock     |    1 |      0 |
| Gengar     |        94 |     15 |    405 |            190 | Shadow        | ghost    |    1 |      0 |
| Haunter    |        93 |     16 |      1 |            126 | Gas           | ghost    |    1 |      0 |
| Gastly     |        92 |     13 |      1 |             95 | Gas           | ghost    |    1 |      0 |
| Cloyster   |        91 |     15 |   1325 |            203 | Bivalve       | water    |    1 |      1 |
| Shellder   |        90 |      3 |     40 |             97 | Bivalve       | water    |    1 |      1 |
| Muk        |        89 |     12 |    300 |            157 | Sludge        | poison   |    1 |      2 |
| Grimer     |        88 |      9 |    300 |             90 | Sludge        | poison   |    1 |      2 |
| Dewgong    |        87 |     17 |   1200 |            176 | Sea Lion      | water    |    1 |      1 |
| Seel       |        86 |     11 |    900 |            100 | Sea Lion      | water    |    1 |      1 |
| Dodrio     |        85 |     18 |    852 |            158 | Triple Bird   | normal   |    1 |      0 |
| Doduo      |        84 |     14 |    392 |             96 | Twin Bird     | normal   |    1 |      0 |
| Farfetch'd |        83 |      8 |    150 |             94 | Wild Duck     | normal   |    1 |      0 |
| Magneton   |        82 |     10 |    600 |            161 | Magnet        | electric |    1 |      0 |
| Magnemite  |        81 |      3 |     60 |             89 | Magnet        | electric |    1 |      0 |
| Slowbro    |        80 |     16 |    785 |            164 | Hermit Crab   | water    |    1 |      1 |
| Slowpoke   |        79 |     12 |    360 |             99 | Dopey         | water    |    1 |      1 |
| Rapidash   |        78 |     17 |    950 |            192 | Fire Horse    | fire     |    1 |      0 |
| Ponyta     |        77 |     10 |    300 |            152 | Fire Horse    | fire     |    1 |      0 |
| Golem      |        76 |     14 |   3000 |            177 | Megaton       | rock     |    1 |      0 |
| Graveler   |        75 |     10 |   1050 |            134 | Rock          | rock     |    1 |      0 |
| Geodude    |        74 |      4 |    200 |             73 | Rock          | rock     |    1 |      0 |
| Tentacruel |        73 |     16 |    550 |            205 | Jellyfish     | water    |    1 |      1 |
| Tentacool  |        72 |      9 |    455 |            105 | Jellyfish     | water    |    1 |      1 |
| Victreebel |        71 |     17 |    155 |            191 | Flycatcher    | grass    |    1 |      0 |
| Weepinbell |        70 |     10 |     64 |            151 | Flycatcher    | grass    |    1 |      0 |
| Bellsprout |        69 |      7 |     40 |             84 | Flower        | grass    |    1 |      0 |
| Machamp    |        68 |     16 |   1300 |            193 | Superpower    | fighting |    1 |      0 |
| Machoke    |        67 |     15 |    705 |            146 | Superpower    | fighting |    1 |      0 |
| Machop     |        66 |      8 |    195 |             75 | Superpower    | fighting |    1 |      0 |
| Alakazam   |        65 |     15 |    480 |            186 | Psi           | psychic  |    1 |      0 |
| Kadabra    |        64 |     13 |    565 |            145 | Psi           | psychic  |    1 |      0 |
| Abra       |        63 |      9 |    195 |             75 | Psi           | psychic  |    1 |      0 |
| Poliwrath  |        62 |     13 |    540 |            185 | Tadpole       | water    |    1 |      1 |
| Poliwhirl  |        61 |     10 |    200 |            131 | Tadpole       | water    |    1 |      1 |
| Poliwag    |        60 |      6 |    124 |             77 | Tadpole       | water    |    1 |      1 |
| Arcanine   |        59 |     19 |   1550 |            213 | Legendary     | fire     |    1 |      0 |
| Growlithe  |        58 |      7 |    190 |             91 | Puppy         | fire     |    1 |      0 |
| Primeape   |        57 |     10 |    320 |            149 | Pig Monkey    | fighting |    1 |      0 |
| Mankey     |        56 |      5 |    280 |             74 | Pig Monkey    | fighting |    1 |      0 |
| Golduck    |        55 |     17 |    766 |            174 | Duck          | water    |    1 |      1 |
| Psyduck    |        54 |      8 |    196 |             80 | Duck          | water    |    1 |      1 |
| Persian    |        53 |     10 |    320 |            148 | Classy Cat    | normal   |    1 |      0 |
| Meowth     |        52 |      4 |     42 |             69 | Scratch Cat   | normal   |    1 |      0 |
| Dugtrio    |        51 |      7 |    333 |            153 | Mole          | ground   |    1 |      0 |
| Diglett    |        50 |      2 |      8 |             81 | Mole          | ground   |    1 |      0 |
| Venomoth   |        49 |     15 |    125 |            138 | Poison Moth   | bug      |    1 |      0 |
| Venonat    |        48 |     10 |    300 |             75 | Insect        | bug      |    1 |      0 |
| Parasect   |        47 |     10 |    295 |            128 | Mushroom      | bug      |    1 |      0 |
| Paras      |        46 |      3 |     54 |             70 | Mushroom      | bug      |    1 |      0 |
| Vileplume  |        45 |     12 |    186 |            184 | Flower        | grass    |    1 |      0 |
| Gloom      |        44 |      8 |     86 |            132 | Weed          | grass    |    1 |      0 |
| Oddish     |        43 |      5 |     54 |             78 | Weed          | grass    |    1 |      0 |
| Golbat     |        42 |     16 |    550 |            171 | Bat           | poison   |    1 |      2 |
| Zubat      |        41 |      8 |     75 |             54 | Bat           | poison   |    1 |      2 |
| Wigglytuff |        40 |     10 |    120 |            109 | Balloon       | normal   |    1 |      0 |
| Jigglypuff |        39 |      5 |     55 |             76 | Balloon       | normal   |    1 |      0 |
| Ninetales  |        38 |     11 |    199 |            178 | Fox           | fire     |    1 |      0 |
| Vulpix     |        37 |      6 |     99 |             63 | Fox           | fire     |    1 |      0 |
| Clefable   |        36 |     13 |    400 |            129 | Fairy         | normal   |    1 |      0 |
| Clefairy   |        35 |      6 |     75 |             68 | Fairy         | normal   |    1 |      0 |
| Nidoking   |        34 |     14 |    620 |            195 | Drill         | poison   |    1 |      2 |
| Nidorino   |        33 |      9 |    195 |            118 | Poison Pin    | poison   |    1 |      2 |
| Nidoran♂ |        32 |      5 |     90 |             60 | Poison Pin    | poison   |    1 |      2 |
| Nidoqueen  |        31 |     13 |    600 |            194 | Drill         | poison   |    1 |      2 |
| Nidorina   |        30 |      8 |    200 |            117 | Poison Pin    | poison   |    1 |      2 |
| Nidoran♀ |        29 |      4 |     70 |             59 | Poison Pin    | poison   |    1 |      2 |
| Sandslash  |        28 |     10 |    295 |            163 | Mouse         | ground   |    1 |      0 |
| Sandshrew  |        27 |      6 |    120 |             93 | Mouse         | ground   |    1 |      0 |
| Raichu     |        26 |      8 |    300 |            122 | Mouse         | electric |    1 |      0 |
| Pikachu    |        25 |      4 |     60 |             82 | Mouse         | electric |    1 |      0 |
| Arbok      |        24 |     35 |    650 |            147 | Cobra         | poison   |    1 |      2 |
| Ekans      |        23 |     20 |     69 |             62 | Snake         | poison   |    1 |      2 |
| Fearow     |        22 |     12 |    380 |            162 | Beak          | normal   |    1 |      0 |
| Spearow    |        21 |      3 |     20 |             58 | Tiny Bird     | normal   |    1 |      0 |
| Raticate   |        20 |      7 |    185 |            116 | Mouse         | normal   |    1 |      0 |
| Rattata    |        19 |      3 |     35 |             57 | Mouse         | normal   |    1 |      0 |
| Pidgeot    |        18 |     15 |    395 |            172 | Bird          | normal   |    1 |      0 |
| Pidgeotto  |        17 |     11 |    300 |            113 | Bird          | normal   |    1 |      0 |
| Pidgey     |        16 |      3 |     18 |             55 | Tiny Bird     | normal   |    1 |      0 |
| Beedrill   |        15 |     10 |    295 |            159 | Poison Bee    | bug      |    1 |      0 |
| Kakuna     |        14 |      6 |    100 |             71 | Cocoon        | bug      |    1 |      0 |
| Weedle     |        13 |      3 |     32 |             52 | Hairy Bug     | bug      |    1 |      0 |
| Butterfree |        12 |     11 |    320 |            160 | Butterfly     | bug      |    1 |      0 |
| Metapod    |        11 |      7 |     99 |             72 | Cocoon        | bug      |    1 |      0 |
| Caterpie   |        10 |      3 |     29 |             53 | Worm          | bug      |    1 |      0 |
| Blastoise  |         9 |     16 |    855 |            210 | Shellfish     | water    |    1 |      1 |
| Wartortle  |         8 |     10 |    225 |            143 | Turtle        | water    |    1 |      1 |
| Squirtle   |         7 |      5 |     90 |             66 | Tiny Turtle   | water    |    1 |      1 |
| Charizard  |         6 |     17 |    905 |            209 | Flame         | fire     |    1 |      0 |
| Charmeleon |         5 |     11 |    190 |            142 | Flame         | fire     |    1 |      0 |
| Charmander |         4 |      6 |     85 |             65 | Lizard        | fire     |    1 |      0 |
| Venusaur   |         3 |     20 |   1000 |            208 | Seed          | grass    |    1 |      0 |
| Ivysaur    |         2 |     10 |    130 |            141 | Seed          | grass    |    1 |      0 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Seed          | grass    |    1 |      0 |
| FakeChu    |      1000 |     26 |   NULL |           NULL | NULL          | ice      | NULL |   NULL |
+------------+-----------+--------+--------+----------------+---------------+----------+------+--------+
650 rows in set (0.00 sec)

mysql> select Name, count(*) as num, avg(BaseExperience) from PokeData
    -> group by Name;
+------------+-----+---------------------+
| Name       | num | avg(BaseExperience) |
+------------+-----+---------------------+
| Abomasnow  |   1 |            214.0000 |
| Abra       |   1 |             75.0000 |
| Absol      |   1 |            174.0000 |
| Accelgor   |   1 |            173.0000 |
| Aerodactyl |   1 |            202.0000 |
| Aggron     |   1 |            205.0000 |
| Aipom      |   1 |             94.0000 |
| Alakazam   |   1 |            186.0000 |
| Alomomola  |   1 |            165.0000 |
| Altaria    |   1 |            188.0000 |
| Ambipom    |   1 |            186.0000 |
| Amoonguss  |   1 |            162.0000 |
| Ampharos   |   1 |            194.0000 |
| Anorith    |   1 |             99.0000 |
| Arbok      |   1 |            147.0000 |
| Arcanine   |   1 |            213.0000 |
| Arceus     |   1 |            255.0000 |
| Archen     |   1 |             71.0000 |
| Archeops   |   1 |            177.0000 |
| Ariados    |   1 |            134.0000 |
| Armaldo    |   1 |            199.0000 |
| Aron       |   1 |             96.0000 |
| Articuno   |   1 |            215.0000 |
| Audino     |   1 |            390.0000 |
| Axew       |   1 |             64.0000 |
| Azelf      |   1 |            210.0000 |
| Azumarill  |   1 |            153.0000 |
| Azurill    |   1 |             33.0000 |
| Bagon      |   1 |             89.0000 |
| Baltoy     |   1 |             58.0000 |
| Banette    |   1 |            179.0000 |
| Barboach   |   1 |             92.0000 |
| Basculin   |   1 |            161.0000 |
| Bastiodon  |   1 |            199.0000 |
| Bayleef    |   1 |            141.0000 |
| Beartic    |   1 |            170.0000 |
| Beautifly  |   1 |            161.0000 |
| Beedrill   |   1 |            159.0000 |
| Beheeyem   |   1 |            170.0000 |
| Beldum     |   1 |            103.0000 |
| Bellossom  |   1 |            184.0000 |
| Bellsprout |   1 |             84.0000 |
| Bibarel    |   1 |            116.0000 |
| Bidoof     |   1 |             58.0000 |
| Bisharp    |   1 |            172.0000 |
| Blastoise  |   1 |            210.0000 |
| Blaziken   |   1 |            209.0000 |
| Blissey    |   1 |            255.0000 |
| Blitzle    |   1 |             59.0000 |
| Boldore    |   1 |            137.0000 |
| Bonsly     |   1 |             68.0000 |
| Bouffalant |   1 |            172.0000 |
| Braviary   |   1 |            179.0000 |
| Breloom    |   1 |            165.0000 |
| Bronzong   |   1 |            188.0000 |
| Bronzor    |   1 |             72.0000 |
| Budew      |   1 |             68.0000 |
| Buizel     |   1 |             75.0000 |
| Bulbasaur  |   1 |             64.0000 |
| Buneary    |   1 |             84.0000 |
| Burmy      |   1 |             61.0000 |
| Butterfree |   1 |            160.0000 |
| Cacnea     |   1 |             97.0000 |
| Cacturne   |   1 |            177.0000 |
| Camerupt   |   1 |            175.0000 |
| Carnivine  |   1 |            164.0000 |
| Carracosta |   1 |            173.0000 |
| Carvanha   |   1 |             88.0000 |
| Cascoon    |   1 |             72.0000 |
| Castform   |   1 |            145.0000 |
| Caterpie   |   1 |             53.0000 |
| Celebi     |   1 |             64.0000 |
| Chandelure |   1 |            234.0000 |
| Chansey    |   1 |            255.0000 |
| Charizard  |   1 |            209.0000 |
| Charmander |   1 |             65.0000 |
| Charmeleon |   1 |            142.0000 |
| Chatot     |   1 |            107.0000 |
| Cherrim    |   1 |            133.0000 |
| Cherubi    |   1 |             68.0000 |
| Chikorita  |   1 |             64.0000 |
| Chimchar   |   1 |             65.0000 |
| Chimecho   |   1 |            147.0000 |
| Chinchou   |   1 |             90.0000 |
| Chingling  |   1 |             74.0000 |
| Cinccino   |   1 |            165.0000 |
| Clamperl   |   1 |            142.0000 |
| Claydol    |   1 |            189.0000 |
| Clefable   |   1 |            129.0000 |
| Clefairy   |   1 |             68.0000 |
| Cleffa     |   1 |             37.0000 |
| Cloyster   |   1 |            203.0000 |
| Cobalion   |   1 |            261.0000 |
| Cofagrigus |   1 |            169.0000 |
| Combee     |   1 |             63.0000 |
| Combusken  |   1 |            142.0000 |
| Conkeldurr |   1 |            227.0000 |
| Corphish   |   1 |            111.0000 |
| Corsola    |   1 |            113.0000 |
| Cottonee   |   1 |             56.0000 |
| Cradily    |   1 |            199.0000 |
| Cranidos   |   1 |             99.0000 |
| Crawdaunt  |   1 |            161.0000 |
| Cresselia  |   1 |            210.0000 |
| Croagunk   |   1 |             83.0000 |
| Crobat     |   1 |            204.0000 |
| Croconaw   |   1 |            143.0000 |
| Crustle    |   1 |            166.0000 |
| Cryogonal  |   1 |            170.0000 |
| Cubchoo    |   1 |             61.0000 |
| Cubone     |   1 |             87.0000 |
| Cyndaquil  |   1 |             65.0000 |
| Darkrai    |   1 |            210.0000 |
| Darmanitan |   1 |            168.0000 |
| Darumaka   |   1 |             63.0000 |
| Deerling   |   1 |             67.0000 |
| Deino      |   1 |             60.0000 |
| Delcatty   |   1 |            138.0000 |
| Delibird   |   1 |            183.0000 |
| Deoxys     |   1 |            215.0000 |
| Dewgong    |   1 |            176.0000 |
| Dewott     |   1 |            145.0000 |
| Dialga     |   1 |            220.0000 |
| Diglett    |   1 |             81.0000 |
| Ditto      |   1 |             61.0000 |
| Dodrio     |   1 |            158.0000 |
| Doduo      |   1 |             96.0000 |
| Donphan    |   1 |            189.0000 |
| Dragonair  |   1 |            144.0000 |
| Dragonite  |   1 |            218.0000 |
| Drapion    |   1 |            204.0000 |
| Dratini    |   1 |             67.0000 |
| Drifblim   |   1 |            204.0000 |
| Drifloon   |   1 |            127.0000 |
| Drilbur    |   1 |             66.0000 |
| Drowzee    |   1 |            102.0000 |
| Druddigon  |   1 |            170.0000 |
| Ducklett   |   1 |             61.0000 |
| Dugtrio    |   1 |            153.0000 |
| Dunsparce  |   1 |            125.0000 |
| Duosion    |   1 |            130.0000 |
| Durant     |   1 |            169.0000 |
| Dusclops   |   1 |            179.0000 |
| Dusknoir   |   1 |            210.0000 |
| Duskull    |   1 |             97.0000 |
| Dustox     |   1 |            161.0000 |
| Dwebble    |   1 |             65.0000 |
| Eelektrik  |   1 |            142.0000 |
| Eelektross |   1 |            232.0000 |
| Eevee      |   1 |             92.0000 |
| Ekans      |   1 |             62.0000 |
| Electabuzz |   1 |            156.0000 |
| Electivire |   1 |            199.0000 |
| Electrike  |   1 |            104.0000 |
| Electrode  |   1 |            150.0000 |
| Elekid     |   1 |            106.0000 |
| Elgyem     |   1 |             67.0000 |
| Emboar     |   1 |            238.0000 |
| Emolga     |   1 |            150.0000 |
| Empoleon   |   1 |            210.0000 |
| Entei      |   1 |            217.0000 |
| Escavalier |   1 |            173.0000 |
| Espeon     |   1 |            197.0000 |
| Excadrill  |   1 |            178.0000 |
| Exeggcute  |   1 |             98.0000 |
| Exeggutor  |   1 |            212.0000 |
| Exploud    |   1 |            184.0000 |
| FakeChu    |   1 |                NULL |
| Farfetch'd |   1 |             94.0000 |
| Fearow     |   1 |            162.0000 |
| Feebas     |   1 |             61.0000 |
| Feraligatr |   1 |            210.0000 |
| Ferroseed  |   1 |             61.0000 |
| Ferrothorn |   1 |            171.0000 |
| Finneon    |   1 |             90.0000 |
| Flaaffy    |   1 |            117.0000 |
| Flareon    |   1 |            198.0000 |
| Floatzel   |   1 |            178.0000 |
| Flygon     |   1 |            197.0000 |
| Foongus    |   1 |             59.0000 |
| Forretress |   1 |            118.0000 |
| Fraxure    |   1 |            144.0000 |
| Frillish   |   1 |             67.0000 |
| Froslass   |   1 |            187.0000 |
| Furret     |   1 |            116.0000 |
| Gabite     |   1 |            144.0000 |
| Gallade    |   1 |            208.0000 |
| Galvantula |   1 |            165.0000 |
| Garbodor   |   1 |            166.0000 |
| Garchomp   |   1 |            218.0000 |
| Gardevoir  |   1 |            208.0000 |
| Gastly     |   1 |             95.0000 |
| Gastrodon  |   1 |            176.0000 |
| Genesect   |   1 |            270.0000 |
| Gengar     |   1 |            190.0000 |
| Geodude    |   1 |             73.0000 |
| Gible      |   1 |             67.0000 |
| Gigalith   |   1 |            227.0000 |
| Girafarig  |   1 |            149.0000 |
| Giratina   |   1 |            220.0000 |
| Glaceon    |   1 |            196.0000 |
| Glalie     |   1 |            187.0000 |
| Glameow    |   1 |             71.0000 |
| Gligar     |   1 |            108.0000 |
| Gliscor    |   1 |            192.0000 |
| Gloom      |   1 |            132.0000 |
| Golbat     |   1 |            171.0000 |
| Goldeen    |   1 |            111.0000 |
| Golduck    |   1 |            174.0000 |
| Golem      |   1 |            177.0000 |
| Golett     |   1 |             61.0000 |
| Golurk     |   1 |            169.0000 |
| Gorebyss   |   1 |            178.0000 |
| Gothita    |   1 |             58.0000 |
| Gothitelle |   1 |            221.0000 |
| Gothorita  |   1 |            137.0000 |
| Granbull   |   1 |            178.0000 |
| Graveler   |   1 |            134.0000 |
| Grimer     |   1 |             90.0000 |
| Grotle     |   1 |            141.0000 |
| Groudon    |   1 |            218.0000 |
| Grovyle    |   1 |            141.0000 |
| Growlithe  |   1 |             91.0000 |
| Grumpig    |   1 |            164.0000 |
| Gulpin     |   1 |             75.0000 |
| Gurdurr    |   1 |            142.0000 |
| Gyarados   |   1 |            214.0000 |
| Happiny    |   1 |            255.0000 |
| Hariyama   |   1 |            184.0000 |
| Haunter    |   1 |            126.0000 |
| Haxorus    |   1 |            243.0000 |
| Heatmor    |   1 |            169.0000 |
| Heatran    |   1 |            215.0000 |
| Heracross  |   1 |            200.0000 |
| Herdier    |   1 |            130.0000 |
| Hippopotas |   1 |             95.0000 |
| Hippowdon  |   1 |            198.0000 |
| Hitmonchan |   1 |            140.0000 |
| Hitmonlee  |   1 |            139.0000 |
| Hitmontop  |   1 |            138.0000 |
| Ho-Oh      |   1 |            220.0000 |
| Honchkrow  |   1 |            187.0000 |
| Hoothoot   |   1 |             58.0000 |
| Hoppip     |   1 |             74.0000 |
| Horsea     |   1 |             83.0000 |
| Houndoom   |   1 |            204.0000 |
| Houndour   |   1 |            114.0000 |
| Huntail    |   1 |            178.0000 |
| Hydreigon  |   1 |            270.0000 |
| Hypno      |   1 |            165.0000 |
| Igglybuff  |   1 |             39.0000 |
| Illumise   |   1 |            146.0000 |
| Infernape  |   1 |            209.0000 |
| Ivysaur    |   1 |            141.0000 |
| Jellicent  |   1 |            168.0000 |
| Jigglypuff |   1 |             76.0000 |
| Jirachi    |   1 |            215.0000 |
| Jolteon    |   1 |            197.0000 |
| Joltik     |   1 |             64.0000 |
| Jumpluff   |   1 |            176.0000 |
| Jynx       |   1 |            137.0000 |
| Kabuto     |   1 |             99.0000 |
| Kabutops   |   1 |            199.0000 |
| Kadabra    |   1 |            145.0000 |
| Kakuna     |   1 |             71.0000 |
| Kangaskhan |   1 |            175.0000 |
| Karrablast |   1 |             63.0000 |
| Kecleon    |   1 |            132.0000 |
| Keldeo     |   1 |            261.0000 |
| Kingdra    |   1 |            207.0000 |
| Kingler    |   1 |            206.0000 |
| Kirlia     |   1 |            140.0000 |
| Klang      |   1 |            154.0000 |
| Klink      |   1 |             60.0000 |
| Klinklang  |   1 |            234.0000 |
| Koffing    |   1 |            114.0000 |
| Krabby     |   1 |            115.0000 |
| Kricketot  |   1 |             54.0000 |
| Kricketune |   1 |            159.0000 |
| Krokorok   |   1 |            123.0000 |
| Krookodile |   1 |            229.0000 |
| Kyogre     |   1 |            218.0000 |
| Kyurem     |   1 |            297.0000 |
| Lairon     |   1 |            152.0000 |
| Lampent    |   1 |            130.0000 |
| Landorus   |   1 |            270.0000 |
| Lanturn    |   1 |            156.0000 |
| Lapras     |   1 |            219.0000 |
| Larvesta   |   1 |             72.0000 |
| Larvitar   |   1 |             67.0000 |
| Latias     |   1 |            211.0000 |
| Latios     |   1 |            211.0000 |
| Leafeon    |   1 |            196.0000 |
| Leavanny   |   1 |            221.0000 |
| Ledian     |   1 |            134.0000 |
| Ledyba     |   1 |             54.0000 |
| Lickilicky |   1 |            193.0000 |
| Lickitung  |   1 |            127.0000 |
| Liepard    |   1 |            156.0000 |
| Lileep     |   1 |             99.0000 |
| Lilligant  |   1 |            168.0000 |
| Lillipup   |   1 |             55.0000 |
| Linoone    |   1 |            128.0000 |
| Litwick    |   1 |             55.0000 |
| Lombre     |   1 |            141.0000 |
| Lopunny    |   1 |            178.0000 |
| Lotad      |   1 |             74.0000 |
| Loudred    |   1 |            126.0000 |
| Lucario    |   1 |            204.0000 |
| Ludicolo   |   1 |            181.0000 |
| Lugia      |   1 |            220.0000 |
| Lumineon   |   1 |            156.0000 |
| Lunatone   |   1 |            150.0000 |
| Luvdisc    |   1 |            110.0000 |
| Luxio      |   1 |            117.0000 |
| Luxray     |   1 |            194.0000 |
| Machamp    |   1 |            193.0000 |
| Machoke    |   1 |            146.0000 |
| Machop     |   1 |             75.0000 |
| Magby      |   1 |            117.0000 |
| Magcargo   |   1 |            154.0000 |
| Magikarp   |   1 |             20.0000 |
| Magmar     |   1 |            167.0000 |
| Magmortar  |   1 |            199.0000 |
| Magnemite  |   1 |             89.0000 |
| Magneton   |   1 |            161.0000 |
| Magnezone  |   1 |            211.0000 |
| Makuhita   |   1 |             87.0000 |
| Mamoswine  |   1 |            207.0000 |
| Manaphy    |   1 |            215.0000 |
| Mandibuzz  |   1 |            179.0000 |
| Manectric  |   1 |            168.0000 |
| Mankey     |   1 |             74.0000 |
| Mantine    |   1 |            168.0000 |
| Mantyke    |   1 |            108.0000 |
| Maractus   |   1 |            161.0000 |
| Mareep     |   1 |             59.0000 |
| Marill     |   1 |             58.0000 |
| Marowak    |   1 |            124.0000 |
| Marshtomp  |   1 |            143.0000 |
| Masquerain |   1 |            128.0000 |
| Mawile     |   1 |             98.0000 |
| Medicham   |   1 |            153.0000 |
| Meditite   |   1 |             91.0000 |
| Meganium   |   1 |            208.0000 |
| Meloetta   |   1 |            270.0000 |
| Meowth     |   1 |             69.0000 |
| Mesprit    |   1 |            210.0000 |
| Metagross  |   1 |            210.0000 |
| Metang     |   1 |            153.0000 |
| Metapod    |   1 |             72.0000 |
| Mew        |   1 |             64.0000 |
| Mewtwo     |   1 |            220.0000 |
| Mienfoo    |   1 |             70.0000 |
| Mienshao   |   1 |            179.0000 |
| Mightyena  |   1 |            128.0000 |
| Milotic    |   1 |            213.0000 |
| Miltank    |   1 |            200.0000 |
| Mime Jr.   |   1 |             78.0000 |
| Minccino   |   1 |             60.0000 |
| Minun      |   1 |            120.0000 |
| Misdreavus |   1 |            147.0000 |
| Mismagius  |   1 |            187.0000 |
| Moltres    |   1 |            217.0000 |
| Monferno   |   1 |            142.0000 |
| Mothim     |   1 |            159.0000 |
| Mr. Mime   |   1 |            136.0000 |
| Mudkip     |   1 |             65.0000 |
| Muk        |   1 |            157.0000 |
| Munchlax   |   1 |             94.0000 |
| Munna      |   1 |             58.0000 |
| Murkrow    |   1 |            107.0000 |
| Musharna   |   1 |            170.0000 |
| Natu       |   1 |             73.0000 |
| Nidoking   |   1 |            195.0000 |
| Nidoqueen  |   1 |            194.0000 |
| Nidoran♀ |   1 |             59.0000 |
| Nidoran♂ |   1 |             60.0000 |
| Nidorina   |   1 |            117.0000 |
| Nidorino   |   1 |            118.0000 |
| Nincada    |   1 |             65.0000 |
| Ninetales  |   1 |            178.0000 |
| Ninjask    |   1 |            155.0000 |
| Noctowl    |   1 |            162.0000 |
| Nosepass   |   1 |            108.0000 |
| Numel      |   1 |             88.0000 |
| Nuzleaf    |   1 |            141.0000 |
| Octillery  |   1 |            164.0000 |
| Oddish     |   1 |             78.0000 |
| Omanyte    |   1 |             99.0000 |
| Omastar    |   1 |            199.0000 |
| Onix       |   1 |            108.0000 |
| Oshawott   |   1 |             28.0000 |
| Pachirisu  |   1 |            120.0000 |
| Palkia     |   1 |            220.0000 |
| Palpitoad  |   1 |            134.0000 |
| Panpour    |   1 |             63.0000 |
| Pansage    |   1 |             63.0000 |
| Pansear    |   1 |             63.0000 |
| Paras      |   1 |             70.0000 |
| Parasect   |   1 |            128.0000 |
| Patrat     |   1 |             51.0000 |
| Pawniard   |   1 |             68.0000 |
| Pelipper   |   1 |            164.0000 |
| Persian    |   1 |            148.0000 |
| Petilil    |   1 |             56.0000 |
| Phanpy     |   1 |            124.0000 |
| Phione     |   1 |            165.0000 |
| Pichu      |   1 |             42.0000 |
| Pidgeot    |   1 |            172.0000 |
| Pidgeotto  |   1 |            113.0000 |
| Pidgey     |   1 |             55.0000 |
| Pidove     |   1 |             53.0000 |
| Pignite    |   1 |            146.0000 |
| Pikachu    |   1 |             82.0000 |
| Piloswine  |   1 |            160.0000 |
| Pineco     |   1 |             60.0000 |
| Pinsir     |   1 |            200.0000 |
| Piplup     |   1 |             66.0000 |
| Plusle     |   1 |            120.0000 |
| Politoed   |   1 |            185.0000 |
| Poliwag    |   1 |             77.0000 |
| Poliwhirl  |   1 |            131.0000 |
| Poliwrath  |   1 |            185.0000 |
| Ponyta     |   1 |            152.0000 |
| Poochyena  |   1 |             55.0000 |
| Porygon    |   1 |            130.0000 |
| Porygon-Z  |   1 |            185.0000 |
| Porygon2   |   1 |            180.0000 |
| Primeape   |   1 |            149.0000 |
| Prinplup   |   1 |            143.0000 |
| Probopass  |   1 |            198.0000 |
| Psyduck    |   1 |             80.0000 |
| Pupitar    |   1 |            144.0000 |
| Purrloin   |   1 |             56.0000 |
| Purugly    |   1 |            183.0000 |
| Quagsire   |   1 |            137.0000 |
| Quilava    |   1 |            142.0000 |
| Qwilfish   |   1 |            100.0000 |
| Raichu     |   1 |            122.0000 |
| Raikou     |   1 |            216.0000 |
| Ralts      |   1 |             70.0000 |
| Rampardos  |   1 |            199.0000 |
| Rapidash   |   1 |            192.0000 |
| Raticate   |   1 |            116.0000 |
| Rattata    |   1 |             57.0000 |
| Rayquaza   |   1 |            220.0000 |
| Regice     |   1 |            216.0000 |
| Regigigas  |   1 |            220.0000 |
| Regirock   |   1 |            217.0000 |
| Registeel  |   1 |            215.0000 |
| Relicanth  |   1 |            198.0000 |
| Remoraid   |   1 |             78.0000 |
| Reshiram   |   1 |            306.0000 |
| Reuniclus  |   1 |            221.0000 |
| Rhydon     |   1 |            204.0000 |
| Rhyhorn    |   1 |            135.0000 |
| Rhyperior  |   1 |            217.0000 |
| Riolu      |   1 |             72.0000 |
| Roggenrola |   1 |             56.0000 |
| Roselia    |   1 |            152.0000 |
| Roserade   |   1 |            204.0000 |
| Rotom      |   1 |            132.0000 |
| Rufflet    |   1 |             70.0000 |
| Sableye    |   1 |             98.0000 |
| Salamence  |   1 |            218.0000 |
| Samurott   |   1 |            238.0000 |
| Sandile    |   1 |             58.0000 |
| Sandshrew  |   1 |             93.0000 |
| Sandslash  |   1 |            163.0000 |
| Sawk       |   1 |            163.0000 |
| Sawsbuck   |   1 |            166.0000 |
| Sceptile   |   1 |            208.0000 |
| Scizor     |   1 |            200.0000 |
| Scolipede  |   1 |            214.0000 |
| Scrafty    |   1 |            171.0000 |
| Scraggy    |   1 |             70.0000 |
| Scyther    |   1 |            187.0000 |
| Seadra     |   1 |            155.0000 |
| Seaking    |   1 |            170.0000 |
| Sealeo     |   1 |            128.0000 |
| Seedot     |   1 |             74.0000 |
| Seel       |   1 |            100.0000 |
| Seismitoad |   1 |            225.0000 |
| Sentret    |   1 |             57.0000 |
| Serperior  |   1 |            238.0000 |
| Servine    |   1 |            145.0000 |
| Seviper    |   1 |            165.0000 |
| Sewaddle   |   1 |             62.0000 |
| Sharpedo   |   1 |            175.0000 |
| Shaymin    |   1 |             64.0000 |
| Shedinja   |   1 |             95.0000 |
| Shelgon    |   1 |            144.0000 |
| Shellder   |   1 |             97.0000 |
| Shellos    |   1 |             73.0000 |
| Shelmet    |   1 |             61.0000 |
| Shieldon   |   1 |             99.0000 |
| Shiftry    |   1 |            181.0000 |
| Shinx      |   1 |             60.0000 |
| Shroomish  |   1 |             65.0000 |
| Shuckle    |   1 |             80.0000 |
| Shuppet    |   1 |             97.0000 |
| Sigilyph   |   1 |            172.0000 |
| Silcoon    |   1 |             72.0000 |
| Simipour   |   1 |            174.0000 |
| Simisage   |   1 |            174.0000 |
| Simisear   |   1 |            174.0000 |
| Skarmory   |   1 |            168.0000 |
| Skiploom   |   1 |            136.0000 |
| Skitty     |   1 |             65.0000 |
| Skorupi    |   1 |            114.0000 |
| Skuntank   |   1 |            209.0000 |
| Slaking    |   1 |            210.0000 |
| Slakoth    |   1 |             83.0000 |
| Slowbro    |   1 |            164.0000 |
| Slowking   |   1 |            164.0000 |
| Slowpoke   |   1 |             99.0000 |
| Slugma     |   1 |             78.0000 |
| Smeargle   |   1 |            106.0000 |
| Smoochum   |   1 |             87.0000 |
| Sneasel    |   1 |            132.0000 |
| Snivy      |   1 |             28.0000 |
| Snorlax    |   1 |            154.0000 |
| Snorunt    |   1 |             74.0000 |
| Snover     |   1 |            131.0000 |
| Snubbull   |   1 |             63.0000 |
| Solosis    |   1 |             58.0000 |
| Solrock    |   1 |            150.0000 |
| Spearow    |   1 |             58.0000 |
| Spheal     |   1 |             75.0000 |
| Spinarak   |   1 |             54.0000 |
| Spinda     |   1 |             85.0000 |
| Spiritomb  |   1 |            168.0000 |
| Spoink     |   1 |             89.0000 |
| Squirtle   |   1 |             66.0000 |
| Stantler   |   1 |            165.0000 |
| Staraptor  |   1 |            172.0000 |
| Staravia   |   1 |            113.0000 |
| Starly     |   1 |             56.0000 |
| Starmie    |   1 |            207.0000 |
| Staryu     |   1 |            106.0000 |
| Steelix    |   1 |            196.0000 |
| Stoutland  |   1 |            221.0000 |
| Stunfisk   |   1 |            165.0000 |
| Stunky     |   1 |             79.0000 |
| Sudowoodo  |   1 |            135.0000 |
| Suicune    |   1 |            215.0000 |
| Sunflora   |   1 |            146.0000 |
| Sunkern    |   1 |             52.0000 |
| Surskit    |   1 |             63.0000 |
| Swablu     |   1 |             74.0000 |
| Swadloon   |   1 |            133.0000 |
| Swalot     |   1 |            168.0000 |
| Swampert   |   1 |            210.0000 |
| Swanna     |   1 |            166.0000 |
| Swellow    |   1 |            162.0000 |
| Swinub     |   1 |             78.0000 |
| Swoobat    |   1 |            149.0000 |
| Taillow    |   1 |             59.0000 |
| Tangela    |   1 |            166.0000 |
| Tangrowth  |   1 |            211.0000 |
| Tauros     |   1 |            211.0000 |
| Teddiursa  |   1 |            124.0000 |
| Tentacool  |   1 |            105.0000 |
| Tentacruel |   1 |            205.0000 |
| Tepig      |   1 |             28.0000 |
| Terrakion  |   1 |            261.0000 |
| Throh      |   1 |            163.0000 |
| Thundurus  |   1 |            261.0000 |
| Timburr    |   1 |             61.0000 |
| Tirtouga   |   1 |             71.0000 |
| Togekiss   |   1 |            220.0000 |
| Togepi     |   1 |             74.0000 |
| Togetic    |   1 |            114.0000 |
| Torchic    |   1 |             65.0000 |
| Torkoal    |   1 |            161.0000 |
| Tornadus   |   1 |            261.0000 |
| Torterra   |   1 |            208.0000 |
| Totodile   |   1 |             66.0000 |
| Toxicroak  |   1 |            181.0000 |
| Tranquill  |   1 |            125.0000 |
| Trapinch   |   1 |             73.0000 |
| Treecko    |   1 |             65.0000 |
| Tropius    |   1 |            169.0000 |
| Trubbish   |   1 |             66.0000 |
| Turtwig    |   1 |             64.0000 |
| Tympole    |   1 |             59.0000 |
| Tynamo     |   1 |             55.0000 |
| Typhlosion |   1 |            209.0000 |
| Tyranitar  |   1 |            218.0000 |
| Tyrogue    |   1 |             91.0000 |
| Umbreon    |   1 |            197.0000 |
| Unfezant   |   1 |            215.0000 |
| Unown      |   1 |             61.0000 |
| Ursaring   |   1 |            189.0000 |
| Uxie       |   1 |            210.0000 |
| Vanillish  |   1 |            138.0000 |
| Vanillite  |   1 |             61.0000 |
| Vanilluxe  |   1 |            241.0000 |
| Vaporeon   |   1 |            196.0000 |
| Venipede   |   1 |             52.0000 |
| Venomoth   |   1 |            138.0000 |
| Venonat    |   1 |             75.0000 |
| Venusaur   |   1 |            208.0000 |
| Vespiquen  |   1 |            188.0000 |
| Vibrava    |   1 |            126.0000 |
| Victini    |   1 |            270.0000 |
| Victreebel |   1 |            191.0000 |
| Vigoroth   |   1 |            126.0000 |
| Vileplume  |   1 |            184.0000 |
| Virizion   |   1 |            261.0000 |
| Volbeat    |   1 |            146.0000 |
| Volcarona  |   1 |            248.0000 |
| Voltorb    |   1 |            103.0000 |
| Vullaby    |   1 |             74.0000 |
| Vulpix     |   1 |             63.0000 |
| Wailmer    |   1 |            137.0000 |
| Wailord    |   1 |            206.0000 |
| Walrein    |   1 |            192.0000 |
| Wartortle  |   1 |            143.0000 |
| Watchog    |   1 |            147.0000 |
| Weavile    |   1 |            199.0000 |
| Weedle     |   1 |             52.0000 |
| Weepinbell |   1 |            151.0000 |
| Weezing    |   1 |            173.0000 |
| Whimsicott |   1 |            168.0000 |
| Whirlipede |   1 |            126.0000 |
| Whiscash   |   1 |            158.0000 |
| Whismur    |   1 |             68.0000 |
| Wigglytuff |   1 |            109.0000 |
| Wingull    |   1 |             64.0000 |
| Wobbuffet  |   1 |            177.0000 |
| Woobat     |   1 |             63.0000 |
| Wooper     |   1 |             52.0000 |
| Wormadam   |   1 |            159.0000 |
| Wurmple    |   1 |             54.0000 |
| Wynaut     |   1 |             44.0000 |
| Xatu       |   1 |            171.0000 |
| Yamask     |   1 |             61.0000 |
| Yanma      |   1 |            147.0000 |
| Yanmega    |   1 |            198.0000 |
| Zangoose   |   1 |            165.0000 |
| Zapdos     |   1 |            216.0000 |
| Zebstrika  |   1 |            174.0000 |
| Zekrom     |   1 |            306.0000 |
| Zigzagoon  |   1 |             60.0000 |
| Zoroark    |   1 |            179.0000 |
| Zorua      |   1 |             66.0000 |
| Zubat      |   1 |             54.0000 |
| Zweilous   |   1 |            147.0000 |
+------------+-----+---------------------+
650 rows in set (0.00 sec)

mysql> select type, count(*) as num, avg(BaseExperience) from PokeData group by type;
+----------+-----+---------------------+
| type     | num | avg(BaseExperience) |
+----------+-----+---------------------+
| bug      |  60 |            123.3667 |
| dark     |  25 |            138.9200 |
| dragon   |  20 |            183.4500 |
| electric |  33 |            140.2424 |
| fighting |  22 |            133.6818 |
| fire     |  39 |            148.9231 |
| flying   |   1 |            261.0000 |
| ghost    |  19 |            151.3158 |
| grass    |  61 |            137.0820 |
| ground   |  30 |            144.7667 |
| ice      |  22 |            150.6190 |
| normal   |  97 |            130.8763 |
| poison   |  26 |            131.7308 |
| psychic  |  44 |            142.6591 |
| rock     |  33 |            147.4545 |
| steel    |  18 |            166.6667 |
| water    | 100 |            141.7800 |
+----------+-----+---------------------+
17 rows in set (0.00 sec)

mysql> create table imagine as (select type, count(*) as num, avg(BaseExperience) from PokeData group by type);
Query OK, 17 rows affected, 13 warnings (0.03 sec)
Records: 17  Duplicates: 0  Warnings: 13

mysql> select 
    -> 
    -> * from imagine;
+----------+-----+---------------------+
| type     | num | avg(BaseExperience) |
+----------+-----+---------------------+
| bug      |  60 |            123.3667 |
| dark     |  25 |            138.9200 |
| dragon   |  20 |            183.4500 |
| electric |  33 |            140.2424 |
| fighting |  22 |            133.6818 |
| fire     |  39 |            148.9231 |
| flying   |   1 |            261.0000 |
| ghost    |  19 |            151.3158 |
| grass    |  61 |            137.0820 |
| ground   |  30 |            144.7667 |
| ice      |  22 |            150.6190 |
| normal   |  97 |            130.8763 |
| poison   |  26 |            131.7308 |
| psychic  |  44 |            142.6591 |
| rock     |  33 |            147.4545 |
| steel    |  18 |            166.6667 |
| water    | 100 |            141.7800 |
+----------+-----+---------------------+
17 rows in set (0.00 sec)

mysql> select * from 
    -> imagine 
    -> where BaseExperience = (select MIN(BaseExperience) from imagine);
ERROR 1054 (42S22): Unknown column 'BaseExperience' in 'where clause'
mysql> drop table imagine
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> create table imagine as (select type, count(*) as num, avg(BaseExperience) as Exp from PokeData group by type);
Query OK, 17 rows affected, 13 warnings (0.01 sec)
Records: 17  Duplicates: 0  Warnings: 13

mysql> select * from  imagine  where Exp = (select MIN(Exp) from imagine);
+------+-----+----------+
| type | num | Exp      |
+------+-----+----------+
| bug  |  60 | 123.3667 |
+------+-----+----------+
1 row in set (0.00 sec)

mysql> select * from imagine order by Exp;
+----------+-----+----------+
| type     | num | Exp      |
+----------+-----+----------+
| bug      |  60 | 123.3667 |
| normal   |  97 | 130.8763 |
| poison   |  26 | 131.7308 |
| fighting |  22 | 133.6818 |
| grass    |  61 | 137.0820 |
| dark     |  25 | 138.9200 |
| electric |  33 | 140.2424 |
| water    | 100 | 141.7800 |
| psychic  |  44 | 142.6591 |
| ground   |  30 | 144.7667 |
| rock     |  33 | 147.4545 |
| fire     |  39 | 148.9231 |
| ice      |  22 | 150.6190 |
| ghost    |  19 | 151.3158 |
| steel    |  18 | 166.6667 |
| dragon   |  20 | 183.4500 |
| flying   |   1 | 261.0000 |
+----------+-----+----------+
17 rows in set (0.00 sec)

mysql> select  i.*
    -> FROM  (select type, count(*) as num, 
    ->                    avg(BaseExperience) as Exp 
    ->        from PokeData 
    ->        group by type) i
    -> WHERE  i.Exp = (select min(Exp) from i)
    -> ;
ERROR 1146 (42S02): Table 'pokemon.i' doesn't exist
mysql> 
mysql> 
mysql> 
mysql> 
mysql> select  i.*
    -> FROM  (select type, count(*) as num, 
    ->                    avg(BaseExperience) as Exp 
    ->        from PokeData 
    ->        group by type) i
    -> WHERE  i.Exp = (select min(Exp) 
    ->                 from (select type, count(*) as num, 
    ->                              avg(BaseExperience) as Exp 
    ->                       from PokeData 
    ->                       group by type) i1
    ->                )
    -> ;
+------+-----+----------+
| type | num | Exp      |
+------+-----+----------+
| bug  |  60 | 123.3667 |
+------+-----+----------+
1 row in set (0.01 sec)

mysql> select  i.*
    -> FROM  (select type, count(*) as num, 
    ->                    avg(BaseExperience) as Exp 
    ->        from PokeData 
    ->        group by type) i
    -> WHERE  i.Exp = (select min(Exp) 
    ->                 from (select  
    ->                              avg(BaseExperience) as Exp 
    ->                       from PokeData 
    ->                       group by type) i1
    ->                )
    -> ;
+------+-----+----------+
| type | num | Exp      |
+------+-----+----------+
| bug  |  60 | 123.3667 |
+------+-----+----------+
1 row in set (0.01 sec)

mysql> show tables;
+-------------------+
| Tables_in_pokemon |
+-------------------+
| Attributes        |
| Evolution         |
| First10           |
| PokeData          |
| PokeStats         |
| Pokemon           |
| SpTypes           |
| Species           |
| Types             |
| fff               |
| foo               |
| imagine           |
| poke10            |
| poke10s           |
| poke5             |
| pokefoo           |
| tmp               |
| ttt               |
+-------------------+
18 rows in set (0.00 sec)

mysql> select * from Pokemon limit 10;
+-----------+------------+
| PokedexID | Name       |
+-----------+------------+
|       460 | Abomasnow  |
|        63 | Abra       |
|       359 | Absol      |
|       617 | Accelgor   |
|       142 | Aerodactyl |
|       306 | Aggron     |
|       190 | Aipom      |
|        65 | Alakazam   |
|       594 | Alomomola  |
|       334 | Altaria    |
+-----------+------------+
10 rows in set (0.00 sec)

mysql> select * from PokeStats limit 10;
+-----------+-----------+--------+--------+----------------+
| Name      | PokedexID | Height | Weight | BaseExperience |
+-----------+-----------+--------+--------+----------------+
| Genesect  |       649 |     15 |    825 |            270 |
| Meloetta  |       648 |      6 |     65 |            270 |
| Keldeo    |       647 |     14 |    485 |            261 |
| Kyurem    |       646 |     30 |   3250 |            297 |
| Landorus  |       645 |     15 |    680 |            270 |
| Zekrom    |       644 |     29 |   3450 |            306 |
| Reshiram  |       643 |     32 |   3300 |            306 |
| Thundurus |       642 |     15 |    610 |            261 |
| Tornadus  |       641 |     15 |    630 |            261 |
| Virizion  |       640 |     20 |   2000 |            261 |
+-----------+-----------+--------+--------+----------------+
10 rows in set (0.00 sec)

mysql> show tables;
+-------------------+
| Tables_in_pokemon |
+-------------------+
| Attributes        |
| Evolution         |
| First10           |
| PokeData          |
| PokeStats         |
| Pokemon           |
| SpTypes           |
| Species           |
| Types             |
| fff               |
| foo               |
| imagine           |
| poke10            |
| poke10s           |
| poke5             |
| pokefoo           |
| tmp               |
| ttt               |
+-------------------+
18 rows in set (0.00 sec)

mysql> select * from Pokemon NATURAL JOIN Attributes 
    -> limit 10;
+-----------+------------+--------+--------+----------------+
| PokedexID | Name       | Height | Weight | BaseExperience |
+-----------+------------+--------+--------+----------------+
|         1 | Bulbasaur  |      7 |     69 |             64 |
|         2 | Ivysaur    |     10 |    130 |            141 |
|         3 | Venusaur   |     20 |   1000 |            208 |
|         4 | Charmander |      6 |     85 |             65 |
|         5 | Charmeleon |     11 |    190 |            142 |
|         6 | Charizard  |     17 |    905 |            209 |
|         7 | Squirtle   |      5 |     90 |             66 |
|         8 | Wartortle  |     10 |    225 |            143 |
|         9 | Blastoise  |     16 |    855 |            210 |
|        10 | Caterpie   |      3 |     29 |             53 |
+-----------+------------+--------+--------+----------------+
10 rows in set (0.01 sec)

mysql> select * from
    -> Pokemon JOIN Attributes ON Pokemon.PokeDexId = Attributes.PokeDexId
    -> ;
+-----------+------------+-----------+--------+--------+----------------+
| PokedexID | Name       | PokedexID | Height | Weight | BaseExperience |
+-----------+------------+-----------+--------+--------+----------------+
|         1 | Bulbasaur  |         1 |      7 |     69 |             64 |
|         2 | Ivysaur    |         2 |     10 |    130 |            141 |
|         3 | Venusaur   |         3 |     20 |   1000 |            208 |
|         4 | Charmander |         4 |      6 |     85 |             65 |
|         5 | Charmeleon |         5 |     11 |    190 |            142 |
|         6 | Charizard  |         6 |     17 |    905 |            209 |
|         7 | Squirtle   |         7 |      5 |     90 |             66 |
|         8 | Wartortle  |         8 |     10 |    225 |            143 |
|         9 | Blastoise  |         9 |     16 |    855 |            210 |
|        10 | Caterpie   |        10 |      3 |     29 |             53 |
|        11 | Metapod    |        11 |      7 |     99 |             72 |
|        12 | Butterfree |        12 |     11 |    320 |            160 |
|        13 | Weedle     |        13 |      3 |     32 |             52 |
|        14 | Kakuna     |        14 |      6 |    100 |             71 |
|        15 | Beedrill   |        15 |     10 |    295 |            159 |
|        16 | Pidgey     |        16 |      3 |     18 |             55 |
|        17 | Pidgeotto  |        17 |     11 |    300 |            113 |
|        18 | Pidgeot    |        18 |     15 |    395 |            172 |
|        19 | Rattata    |        19 |      3 |     35 |             57 |
|        20 | Raticate   |        20 |      7 |    185 |            116 |
|        21 | Spearow    |        21 |      3 |     20 |             58 |
|        22 | Fearow     |        22 |     12 |    380 |            162 |
|        23 | Ekans      |        23 |     20 |     69 |             62 |
|        24 | Arbok      |        24 |     35 |    650 |            147 |
|        25 | Pikachu    |        25 |      4 |     60 |             82 |
|        26 | Raichu     |        26 |      8 |    300 |            122 |
|        27 | Sandshrew  |        27 |      6 |    120 |             93 |
|        28 | Sandslash  |        28 |     10 |    295 |            163 |
|        29 | Nidoran♀ |        29 |      4 |     70 |             59 |
|        30 | Nidorina   |        30 |      8 |    200 |            117 |
|        31 | Nidoqueen  |        31 |     13 |    600 |            194 |
|        32 | Nidoran♂ |        32 |      5 |     90 |             60 |
|        33 | Nidorino   |        33 |      9 |    195 |            118 |
|        34 | Nidoking   |        34 |     14 |    620 |            195 |
|        35 | Clefairy   |        35 |      6 |     75 |             68 |
|        36 | Clefable   |        36 |     13 |    400 |            129 |
|        37 | Vulpix     |        37 |      6 |     99 |             63 |
|        38 | Ninetales  |        38 |     11 |    199 |            178 |
|        39 | Jigglypuff |        39 |      5 |     55 |             76 |
|        40 | Wigglytuff |        40 |     10 |    120 |            109 |
|        41 | Zubat      |        41 |      8 |     75 |             54 |
|        42 | Golbat     |        42 |     16 |    550 |            171 |
|        43 | Oddish     |        43 |      5 |     54 |             78 |
|        44 | Gloom      |        44 |      8 |     86 |            132 |
|        45 | Vileplume  |        45 |     12 |    186 |            184 |
|        46 | Paras      |        46 |      3 |     54 |             70 |
|        47 | Parasect   |        47 |     10 |    295 |            128 |
|        48 | Venonat    |        48 |     10 |    300 |             75 |
|        49 | Venomoth   |        49 |     15 |    125 |            138 |
|        50 | Diglett    |        50 |      2 |      8 |             81 |
|        51 | Dugtrio    |        51 |      7 |    333 |            153 |
|        52 | Meowth     |        52 |      4 |     42 |             69 |
|        53 | Persian    |        53 |     10 |    320 |            148 |
|        54 | Psyduck    |        54 |      8 |    196 |             80 |
|        55 | Golduck    |        55 |     17 |    766 |            174 |
|        56 | Mankey     |        56 |      5 |    280 |             74 |
|        57 | Primeape   |        57 |     10 |    320 |            149 |
|        58 | Growlithe  |        58 |      7 |    190 |             91 |
|        59 | Arcanine   |        59 |     19 |   1550 |            213 |
|        60 | Poliwag    |        60 |      6 |    124 |             77 |
|        61 | Poliwhirl  |        61 |     10 |    200 |            131 |
|        62 | Poliwrath  |        62 |     13 |    540 |            185 |
|        63 | Abra       |        63 |      9 |    195 |             75 |
|        64 | Kadabra    |        64 |     13 |    565 |            145 |
|        65 | Alakazam   |        65 |     15 |    480 |            186 |
|        66 | Machop     |        66 |      8 |    195 |             75 |
|        67 | Machoke    |        67 |     15 |    705 |            146 |
|        68 | Machamp    |        68 |     16 |   1300 |            193 |
|        69 | Bellsprout |        69 |      7 |     40 |             84 |
|        70 | Weepinbell |        70 |     10 |     64 |            151 |
|        71 | Victreebel |        71 |     17 |    155 |            191 |
|        72 | Tentacool  |        72 |      9 |    455 |            105 |
|        73 | Tentacruel |        73 |     16 |    550 |            205 |
|        74 | Geodude    |        74 |      4 |    200 |             73 |
|        75 | Graveler   |        75 |     10 |   1050 |            134 |
|        76 | Golem      |        76 |     14 |   3000 |            177 |
|        77 | Ponyta     |        77 |     10 |    300 |            152 |
|        78 | Rapidash   |        78 |     17 |    950 |            192 |
|        79 | Slowpoke   |        79 |     12 |    360 |             99 |
|        80 | Slowbro    |        80 |     16 |    785 |            164 |
|        81 | Magnemite  |        81 |      3 |     60 |             89 |
|        82 | Magneton   |        82 |     10 |    600 |            161 |
|        83 | Farfetch'd |        83 |      8 |    150 |             94 |
|        84 | Doduo      |        84 |     14 |    392 |             96 |
|        85 | Dodrio     |        85 |     18 |    852 |            158 |
|        86 | Seel       |        86 |     11 |    900 |            100 |
|        87 | Dewgong    |        87 |     17 |   1200 |            176 |
|        88 | Grimer     |        88 |      9 |    300 |             90 |
|        89 | Muk        |        89 |     12 |    300 |            157 |
|        90 | Shellder   |        90 |      3 |     40 |             97 |
|        91 | Cloyster   |        91 |     15 |   1325 |            203 |
|        92 | Gastly     |        92 |     13 |      1 |             95 |
|        93 | Haunter    |        93 |     16 |      1 |            126 |
|        94 | Gengar     |        94 |     15 |    405 |            190 |
|        95 | Onix       |        95 |     88 |   2100 |            108 |
|        96 | Drowzee    |        96 |     10 |    324 |            102 |
|        97 | Hypno      |        97 |     16 |    756 |            165 |
|        98 | Krabby     |        98 |      4 |     65 |            115 |
|        99 | Kingler    |        99 |     13 |    600 |            206 |
|       100 | Voltorb    |       100 |      5 |    104 |            103 |
|       101 | Electrode  |       101 |     12 |    666 |            150 |
|       102 | Exeggcute  |       102 |      4 |     25 |             98 |
|       103 | Exeggutor  |       103 |     20 |   1200 |            212 |
|       104 | Cubone     |       104 |      4 |     65 |             87 |
|       105 | Marowak    |       105 |     10 |    450 |            124 |
|       106 | Hitmonlee  |       106 |     15 |    498 |            139 |
|       107 | Hitmonchan |       107 |     14 |    502 |            140 |
|       108 | Lickitung  |       108 |     12 |    655 |            127 |
|       109 | Koffing    |       109 |      6 |     10 |            114 |
|       110 | Weezing    |       110 |     12 |     95 |            173 |
|       111 | Rhyhorn    |       111 |     10 |   1150 |            135 |
|       112 | Rhydon     |       112 |     19 |   1200 |            204 |
|       113 | Chansey    |       113 |     11 |    346 |            255 |
|       114 | Tangela    |       114 |     10 |    350 |            166 |
|       115 | Kangaskhan |       115 |     22 |    800 |            175 |
|       116 | Horsea     |       116 |      4 |     80 |             83 |
|       117 | Seadra     |       117 |     12 |    250 |            155 |
|       118 | Goldeen    |       118 |      6 |    150 |            111 |
|       119 | Seaking    |       119 |     13 |    390 |            170 |
|       120 | Staryu     |       120 |      8 |    345 |            106 |
|       121 | Starmie    |       121 |     11 |    800 |            207 |
|       122 | Mr. Mime   |       122 |     13 |    545 |            136 |
|       123 | Scyther    |       123 |     15 |    560 |            187 |
|       124 | Jynx       |       124 |     14 |    406 |            137 |
|       125 | Electabuzz |       125 |     11 |    300 |            156 |
|       126 | Magmar     |       126 |     13 |    445 |            167 |
|       127 | Pinsir     |       127 |     15 |    550 |            200 |
|       128 | Tauros     |       128 |     14 |    884 |            211 |
|       129 | Magikarp   |       129 |      9 |    100 |             20 |
|       130 | Gyarados   |       130 |     65 |   2350 |            214 |
|       131 | Lapras     |       131 |     25 |   2200 |            219 |
|       132 | Ditto      |       132 |      3 |     40 |             61 |
|       133 | Eevee      |       133 |      3 |     65 |             92 |
|       134 | Vaporeon   |       134 |     10 |    290 |            196 |
|       135 | Jolteon    |       135 |      8 |    245 |            197 |
|       136 | Flareon    |       136 |      9 |    250 |            198 |
|       137 | Porygon    |       137 |      8 |    365 |            130 |
|       138 | Omanyte    |       138 |      4 |     75 |             99 |
|       139 | Omastar    |       139 |     10 |    350 |            199 |
|       140 | Kabuto     |       140 |      5 |    115 |             99 |
|       141 | Kabutops   |       141 |     13 |    405 |            199 |
|       142 | Aerodactyl |       142 |     18 |    590 |            202 |
|       143 | Snorlax    |       143 |     21 |   4600 |            154 |
|       144 | Articuno   |       144 |     17 |    554 |            215 |
|       145 | Zapdos     |       145 |     16 |    526 |            216 |
|       146 | Moltres    |       146 |     20 |    600 |            217 |
|       147 | Dratini    |       147 |     18 |     33 |             67 |
|       148 | Dragonair  |       148 |     40 |    165 |            144 |
|       149 | Dragonite  |       149 |     22 |   2100 |            218 |
|       150 | Mewtwo     |       150 |     20 |   1220 |            220 |
|       151 | Mew        |       151 |      4 |     40 |             64 |
|       152 | Chikorita  |       152 |      9 |     64 |             64 |
|       153 | Bayleef    |       153 |     12 |    158 |            141 |
|       154 | Meganium   |       154 |     18 |   1005 |            208 |
|       155 | Cyndaquil  |       155 |      5 |     79 |             65 |
|       156 | Quilava    |       156 |      9 |    190 |            142 |
|       157 | Typhlosion |       157 |     17 |    795 |            209 |
|       158 | Totodile   |       158 |      6 |     95 |             66 |
|       159 | Croconaw   |       159 |     11 |    250 |            143 |
|       160 | Feraligatr |       160 |     23 |    888 |            210 |
|       161 | Sentret    |       161 |      8 |     60 |             57 |
|       162 | Furret     |       162 |     18 |    325 |            116 |
|       163 | Hoothoot   |       163 |      7 |    212 |             58 |
|       164 | Noctowl    |       164 |     16 |    408 |            162 |
|       165 | Ledyba     |       165 |     10 |    108 |             54 |
|       166 | Ledian     |       166 |     14 |    356 |            134 |
|       167 | Spinarak   |       167 |      5 |     85 |             54 |
|       168 | Ariados    |       168 |     11 |    335 |            134 |
|       169 | Crobat     |       169 |     18 |    750 |            204 |
|       170 | Chinchou   |       170 |      5 |    120 |             90 |
|       171 | Lanturn    |       171 |     12 |    225 |            156 |
|       172 | Pichu      |       172 |      3 |     20 |             42 |
|       173 | Cleffa     |       173 |      3 |     30 |             37 |
|       174 | Igglybuff  |       174 |      3 |     10 |             39 |
|       175 | Togepi     |       175 |      3 |     15 |             74 |
|       176 | Togetic    |       176 |      6 |     32 |            114 |
|       177 | Natu       |       177 |      2 |     20 |             73 |
|       178 | Xatu       |       178 |     15 |    150 |            171 |
|       179 | Mareep     |       179 |      6 |     78 |             59 |
|       180 | Flaaffy    |       180 |      8 |    133 |            117 |
|       181 | Ampharos   |       181 |     14 |    615 |            194 |
|       182 | Bellossom  |       182 |      4 |     58 |            184 |
|       183 | Marill     |       183 |      4 |     85 |             58 |
|       184 | Azumarill  |       184 |      8 |    285 |            153 |
|       185 | Sudowoodo  |       185 |     12 |    380 |            135 |
|       186 | Politoed   |       186 |     11 |    339 |            185 |
|       187 | Hoppip     |       187 |      4 |      5 |             74 |
|       188 | Skiploom   |       188 |      6 |     10 |            136 |
|       189 | Jumpluff   |       189 |      8 |     30 |            176 |
|       190 | Aipom      |       190 |      8 |    115 |             94 |
|       191 | Sunkern    |       191 |      3 |     18 |             52 |
|       192 | Sunflora   |       192 |      8 |     85 |            146 |
|       193 | Yanma      |       193 |     12 |    380 |            147 |
|       194 | Wooper     |       194 |      4 |     85 |             52 |
|       195 | Quagsire   |       195 |     14 |    750 |            137 |
|       196 | Espeon     |       196 |      9 |    265 |            197 |
|       197 | Umbreon    |       197 |     10 |    270 |            197 |
|       198 | Murkrow    |       198 |      5 |     21 |            107 |
|       199 | Slowking   |       199 |     20 |    795 |            164 |
|       200 | Misdreavus |       200 |      7 |     10 |            147 |
|       201 | Unown      |       201 |      5 |     50 |             61 |
|       202 | Wobbuffet  |       202 |     13 |    285 |            177 |
|       203 | Girafarig  |       203 |     15 |    415 |            149 |
|       204 | Pineco     |       204 |      6 |     72 |             60 |
|       205 | Forretress |       205 |     12 |   1258 |            118 |
|       206 | Dunsparce  |       206 |     15 |    140 |            125 |
|       207 | Gligar     |       207 |     11 |    648 |            108 |
|       208 | Steelix    |       208 |     92 |   4000 |            196 |
|       209 | Snubbull   |       209 |      6 |     78 |             63 |
|       210 | Granbull   |       210 |     14 |    487 |            178 |
|       211 | Qwilfish   |       211 |      5 |     39 |            100 |
|       212 | Scizor     |       212 |     18 |   1180 |            200 |
|       213 | Shuckle    |       213 |      6 |    205 |             80 |
|       214 | Heracross  |       214 |     15 |    540 |            200 |
|       215 | Sneasel    |       215 |      9 |    280 |            132 |
|       216 | Teddiursa  |       216 |      6 |     88 |            124 |
|       217 | Ursaring   |       217 |     18 |   1258 |            189 |
|       218 | Slugma     |       218 |      7 |    350 |             78 |
|       219 | Magcargo   |       219 |      8 |    550 |            154 |
|       220 | Swinub     |       220 |      4 |     65 |             78 |
|       221 | Piloswine  |       221 |     11 |    558 |            160 |
|       222 | Corsola    |       222 |      6 |     50 |            113 |
|       223 | Remoraid   |       223 |      6 |    120 |             78 |
|       224 | Octillery  |       224 |      9 |    285 |            164 |
|       225 | Delibird   |       225 |      9 |    160 |            183 |
|       226 | Mantine    |       226 |     21 |   2200 |            168 |
|       227 | Skarmory   |       227 |     17 |    505 |            168 |
|       228 | Houndour   |       228 |      6 |    108 |            114 |
|       229 | Houndoom   |       229 |     14 |    350 |            204 |
|       230 | Kingdra    |       230 |     18 |   1520 |            207 |
|       231 | Phanpy     |       231 |      5 |    335 |            124 |
|       232 | Donphan    |       232 |     11 |   1200 |            189 |
|       233 | Porygon2   |       233 |      6 |    325 |            180 |
|       234 | Stantler   |       234 |     14 |    712 |            165 |
|       235 | Smeargle   |       235 |     12 |    580 |            106 |
|       236 | Tyrogue    |       236 |      7 |    210 |             91 |
|       237 | Hitmontop  |       237 |     14 |    480 |            138 |
|       238 | Smoochum   |       238 |      4 |     60 |             87 |
|       239 | Elekid     |       239 |      6 |    235 |            106 |
|       240 | Magby      |       240 |      7 |    214 |            117 |
|       241 | Miltank    |       241 |     12 |    755 |            200 |
|       242 | Blissey    |       242 |     15 |    468 |            255 |
|       243 | Raikou     |       243 |     19 |   1780 |            216 |
|       244 | Entei      |       244 |     21 |   1980 |            217 |
|       245 | Suicune    |       245 |     20 |   1870 |            215 |
|       246 | Larvitar   |       246 |      6 |    720 |             67 |
|       247 | Pupitar    |       247 |     12 |   1520 |            144 |
|       248 | Tyranitar  |       248 |     20 |   2020 |            218 |
|       249 | Lugia      |       249 |     52 |   2160 |            220 |
|       250 | Ho-Oh      |       250 |     38 |   1990 |            220 |
|       251 | Celebi     |       251 |      6 |     50 |             64 |
|       252 | Treecko    |       252 |      5 |     50 |             65 |
|       253 | Grovyle    |       253 |      9 |    216 |            141 |
|       254 | Sceptile   |       254 |     17 |    522 |            208 |
|       255 | Torchic    |       255 |      4 |     25 |             65 |
|       256 | Combusken  |       256 |      9 |    195 |            142 |
|       257 | Blaziken   |       257 |     19 |    520 |            209 |
|       258 | Mudkip     |       258 |      4 |     76 |             65 |
|       259 | Marshtomp  |       259 |      7 |    280 |            143 |
|       260 | Swampert   |       260 |     15 |    819 |            210 |
|       261 | Poochyena  |       261 |      5 |    136 |             55 |
|       262 | Mightyena  |       262 |     10 |    370 |            128 |
|       263 | Zigzagoon  |       263 |      4 |    175 |             60 |
|       264 | Linoone    |       264 |      5 |    325 |            128 |
|       265 | Wurmple    |       265 |      3 |     36 |             54 |
|       266 | Silcoon    |       266 |      6 |    100 |             72 |
|       267 | Beautifly  |       267 |     10 |    284 |            161 |
|       268 | Cascoon    |       268 |      7 |    115 |             72 |
|       269 | Dustox     |       269 |     12 |    316 |            161 |
|       270 | Lotad      |       270 |      5 |     26 |             74 |
|       271 | Lombre     |       271 |     12 |    325 |            141 |
|       272 | Ludicolo   |       272 |     15 |    550 |            181 |
|       273 | Seedot     |       273 |      5 |     40 |             74 |
|       274 | Nuzleaf    |       274 |     10 |    280 |            141 |
|       275 | Shiftry    |       275 |     13 |    596 |            181 |
|       276 | Taillow    |       276 |      3 |     23 |             59 |
|       277 | Swellow    |       277 |      7 |    198 |            162 |
|       278 | Wingull    |       278 |      6 |     95 |             64 |
|       279 | Pelipper   |       279 |     12 |    280 |            164 |
|       280 | Ralts      |       280 |      4 |     66 |             70 |
|       281 | Kirlia     |       281 |      8 |    202 |            140 |
|       282 | Gardevoir  |       282 |     16 |    484 |            208 |
|       283 | Surskit    |       283 |      5 |     17 |             63 |
|       284 | Masquerain |       284 |      8 |     36 |            128 |
|       285 | Shroomish  |       285 |      4 |     45 |             65 |
|       286 | Breloom    |       286 |     12 |    392 |            165 |
|       287 | Slakoth    |       287 |      8 |    240 |             83 |
|       288 | Vigoroth   |       288 |     14 |    465 |            126 |
|       289 | Slaking    |       289 |     20 |   1305 |            210 |
|       290 | Nincada    |       290 |      5 |     55 |             65 |
|       291 | Ninjask    |       291 |      8 |    120 |            155 |
|       292 | Shedinja   |       292 |      8 |     12 |             95 |
|       293 | Whismur    |       293 |      6 |    163 |             68 |
|       294 | Loudred    |       294 |     10 |    405 |            126 |
|       295 | Exploud    |       295 |     15 |    840 |            184 |
|       296 | Makuhita   |       296 |     10 |    864 |             87 |
|       297 | Hariyama   |       297 |     23 |   2538 |            184 |
|       298 | Azurill    |       298 |      2 |     20 |             33 |
|       299 | Nosepass   |       299 |     10 |    970 |            108 |
|       300 | Skitty     |       300 |      6 |    110 |             65 |
|       301 | Delcatty   |       301 |     11 |    326 |            138 |
|       302 | Sableye    |       302 |      5 |    110 |             98 |
|       303 | Mawile     |       303 |      6 |    115 |             98 |
|       304 | Aron       |       304 |      4 |    600 |             96 |
|       305 | Lairon     |       305 |      9 |   1200 |            152 |
|       306 | Aggron     |       306 |     21 |   3600 |            205 |
|       307 | Meditite   |       307 |      6 |    112 |             91 |
|       308 | Medicham   |       308 |     13 |    315 |            153 |
|       309 | Electrike  |       309 |      6 |    152 |            104 |
|       310 | Manectric  |       310 |     15 |    402 |            168 |
|       311 | Plusle     |       311 |      4 |     42 |            120 |
|       312 | Minun      |       312 |      4 |     42 |            120 |
|       313 | Volbeat    |       313 |      7 |    177 |            146 |
|       314 | Illumise   |       314 |      6 |    177 |            146 |
|       315 | Roselia    |       315 |      3 |     20 |            152 |
|       316 | Gulpin     |       316 |      4 |    103 |             75 |
|       317 | Swalot     |       317 |     17 |    800 |            168 |
|       318 | Carvanha   |       318 |      8 |    208 |             88 |
|       319 | Sharpedo   |       319 |     18 |    888 |            175 |
|       320 | Wailmer    |       320 |     20 |   1300 |            137 |
|       321 | Wailord    |       321 |    145 |   3980 |            206 |
|       322 | Numel      |       322 |      7 |    240 |             88 |
|       323 | Camerupt   |       323 |     19 |   2200 |            175 |
|       324 | Torkoal    |       324 |      5 |    804 |            161 |
|       325 | Spoink     |       325 |      7 |    306 |             89 |
|       326 | Grumpig    |       326 |      9 |    715 |            164 |
|       327 | Spinda     |       327 |     11 |     50 |             85 |
|       328 | Trapinch   |       328 |      7 |    150 |             73 |
|       329 | Vibrava    |       329 |     11 |    153 |            126 |
|       330 | Flygon     |       330 |     20 |    820 |            197 |
|       331 | Cacnea     |       331 |      4 |    513 |             97 |
|       332 | Cacturne   |       332 |     13 |    774 |            177 |
|       333 | Swablu     |       333 |      4 |     12 |             74 |
|       334 | Altaria    |       334 |     11 |    206 |            188 |
|       335 | Zangoose   |       335 |     13 |    403 |            165 |
|       336 | Seviper    |       336 |     27 |    525 |            165 |
|       337 | Lunatone   |       337 |     10 |   1680 |            150 |
|       338 | Solrock    |       338 |     12 |   1540 |            150 |
|       339 | Barboach   |       339 |      4 |     19 |             92 |
|       340 | Whiscash   |       340 |      9 |    236 |            158 |
|       341 | Corphish   |       341 |      6 |    115 |            111 |
|       342 | Crawdaunt  |       342 |     11 |    328 |            161 |
|       343 | Baltoy     |       343 |      5 |    215 |             58 |
|       344 | Claydol    |       344 |     15 |   1080 |            189 |
|       345 | Lileep     |       345 |     10 |    238 |             99 |
|       346 | Cradily    |       346 |     15 |    604 |            199 |
|       347 | Anorith    |       347 |      7 |    125 |             99 |
|       348 | Armaldo    |       348 |     15 |    682 |            199 |
|       349 | Feebas     |       349 |      6 |     74 |             61 |
|       350 | Milotic    |       350 |     62 |   1620 |            213 |
|       351 | Castform   |       351 |      3 |      8 |            145 |
|       352 | Kecleon    |       352 |     10 |    220 |            132 |
|       353 | Shuppet    |       353 |      6 |     23 |             97 |
|       354 | Banette    |       354 |     11 |    125 |            179 |
|       355 | Duskull    |       355 |      8 |    150 |             97 |
|       356 | Dusclops   |       356 |     16 |    306 |            179 |
|       357 | Tropius    |       357 |     20 |   1000 |            169 |
|       358 | Chimecho   |       358 |      6 |     10 |            147 |
|       359 | Absol      |       359 |     12 |    470 |            174 |
|       360 | Wynaut     |       360 |      6 |    140 |             44 |
|       361 | Snorunt    |       361 |      7 |    168 |             74 |
|       362 | Glalie     |       362 |     15 |   2565 |            187 |
|       363 | Spheal     |       363 |      8 |    395 |             75 |
|       364 | Sealeo     |       364 |     11 |    876 |            128 |
|       365 | Walrein    |       365 |     14 |   1506 |            192 |
|       366 | Clamperl   |       366 |      4 |    525 |            142 |
|       367 | Huntail    |       367 |     17 |    270 |            178 |
|       368 | Gorebyss   |       368 |     18 |    226 |            178 |
|       369 | Relicanth  |       369 |     10 |    234 |            198 |
|       370 | Luvdisc    |       370 |      6 |     87 |            110 |
|       371 | Bagon      |       371 |      6 |    421 |             89 |
|       372 | Shelgon    |       372 |     11 |   1105 |            144 |
|       373 | Salamence  |       373 |     15 |   1026 |            218 |
|       374 | Beldum     |       374 |      6 |    952 |            103 |
|       375 | Metang     |       375 |     12 |   2025 |            153 |
|       376 | Metagross  |       376 |     16 |   5500 |            210 |
|       377 | Regirock   |       377 |     17 |   2300 |            217 |
|       378 | Regice     |       378 |     18 |   1750 |            216 |
|       379 | Registeel  |       379 |     19 |   2050 |            215 |
|       380 | Latias     |       380 |     14 |    400 |            211 |
|       381 | Latios     |       381 |     20 |    600 |            211 |
|       382 | Kyogre     |       382 |     45 |   3520 |            218 |
|       383 | Groudon    |       383 |     35 |   9500 |            218 |
|       384 | Rayquaza   |       384 |     70 |   2065 |            220 |
|       385 | Jirachi    |       385 |      3 |     11 |            215 |
|       386 | Deoxys     |       386 |     17 |    608 |            215 |
|       387 | Turtwig    |       387 |      4 |    102 |             64 |
|       388 | Grotle     |       388 |     11 |    970 |            141 |
|       389 | Torterra   |       389 |     22 |   3100 |            208 |
|       390 | Chimchar   |       390 |      5 |     62 |             65 |
|       391 | Monferno   |       391 |      9 |    220 |            142 |
|       392 | Infernape  |       392 |     12 |    550 |            209 |
|       393 | Piplup     |       393 |      4 |     52 |             66 |
|       394 | Prinplup   |       394 |      8 |    230 |            143 |
|       395 | Empoleon   |       395 |     17 |    845 |            210 |
|       396 | Starly     |       396 |      3 |     20 |             56 |
|       397 | Staravia   |       397 |      6 |    155 |            113 |
|       398 | Staraptor  |       398 |     12 |    249 |            172 |
|       399 | Bidoof     |       399 |      5 |    200 |             58 |
|       400 | Bibarel    |       400 |     10 |    315 |            116 |
|       401 | Kricketot  |       401 |      3 |     22 |             54 |
|       402 | Kricketune |       402 |     10 |    255 |            159 |
|       403 | Shinx      |       403 |      5 |     95 |             60 |
|       404 | Luxio      |       404 |      9 |    305 |            117 |
|       405 | Luxray     |       405 |     14 |    420 |            194 |
|       406 | Budew      |       406 |      2 |     12 |             68 |
|       407 | Roserade   |       407 |      9 |    145 |            204 |
|       408 | Cranidos   |       408 |      9 |    315 |             99 |
|       409 | Rampardos  |       409 |     16 |   1025 |            199 |
|       410 | Shieldon   |       410 |      5 |    570 |             99 |
|       411 | Bastiodon  |       411 |     13 |   1495 |            199 |
|       412 | Burmy      |       412 |      2 |     34 |             61 |
|       413 | Wormadam   |       413 |      5 |     65 |            159 |
|       414 | Mothim     |       414 |      9 |    233 |            159 |
|       415 | Combee     |       415 |      3 |     55 |             63 |
|       416 | Vespiquen  |       416 |     12 |    385 |            188 |
|       417 | Pachirisu  |       417 |      4 |     39 |            120 |
|       418 | Buizel     |       418 |      7 |    295 |             75 |
|       419 | Floatzel   |       419 |     11 |    335 |            178 |
|       420 | Cherubi    |       420 |      4 |     33 |             68 |
|       421 | Cherrim    |       421 |      5 |     93 |            133 |
|       422 | Shellos    |       422 |      3 |     63 |             73 |
|       423 | Gastrodon  |       423 |      9 |    299 |            176 |
|       424 | Ambipom    |       424 |     12 |    203 |            186 |
|       425 | Drifloon   |       425 |      4 |     12 |            127 |
|       426 | Drifblim   |       426 |     12 |    150 |            204 |
|       427 | Buneary    |       427 |      4 |     55 |             84 |
|       428 | Lopunny    |       428 |     12 |    333 |            178 |
|       429 | Mismagius  |       429 |      9 |     44 |            187 |
|       430 | Honchkrow  |       430 |      9 |    273 |            187 |
|       431 | Glameow    |       431 |      5 |     39 |             71 |
|       432 | Purugly    |       432 |     10 |    438 |            183 |
|       433 | Chingling  |       433 |      2 |      6 |             74 |
|       434 | Stunky     |       434 |      4 |    192 |             79 |
|       435 | Skuntank   |       435 |     10 |    380 |            209 |
|       436 | Bronzor    |       436 |      5 |    605 |             72 |
|       437 | Bronzong   |       437 |     13 |   1870 |            188 |
|       438 | Bonsly     |       438 |      5 |    150 |             68 |
|       439 | Mime Jr.   |       439 |      6 |    130 |             78 |
|       440 | Happiny    |       440 |      6 |    244 |            255 |
|       441 | Chatot     |       441 |      5 |     19 |            107 |
|       442 | Spiritomb  |       442 |     10 |   1080 |            168 |
|       443 | Gible      |       443 |      7 |    205 |             67 |
|       444 | Gabite     |       444 |     14 |    560 |            144 |
|       445 | Garchomp   |       445 |     19 |    950 |            218 |
|       446 | Munchlax   |       446 |      6 |   1050 |             94 |
|       447 | Riolu      |       447 |      7 |    202 |             72 |
|       448 | Lucario    |       448 |     12 |    540 |            204 |
|       449 | Hippopotas |       449 |      8 |    495 |             95 |
|       450 | Hippowdon  |       450 |     20 |   3000 |            198 |
|       451 | Skorupi    |       451 |      8 |    120 |            114 |
|       452 | Drapion    |       452 |     13 |    615 |            204 |
|       453 | Croagunk   |       453 |      7 |    230 |             83 |
|       454 | Toxicroak  |       454 |     13 |    444 |            181 |
|       455 | Carnivine  |       455 |     14 |    270 |            164 |
|       456 | Finneon    |       456 |      4 |     70 |             90 |
|       457 | Lumineon   |       457 |     12 |    240 |            156 |
|       458 | Mantyke    |       458 |     10 |    650 |            108 |
|       459 | Snover     |       459 |     10 |    505 |            131 |
|       460 | Abomasnow  |       460 |     22 |   1355 |            214 |
|       461 | Weavile    |       461 |     11 |    340 |            199 |
|       462 | Magnezone  |       462 |     12 |   1800 |            211 |
|       463 | Lickilicky |       463 |     17 |   1400 |            193 |
|       464 | Rhyperior  |       464 |     24 |   2828 |            217 |
|       465 | Tangrowth  |       465 |     20 |   1286 |            211 |
|       466 | Electivire |       466 |     18 |   1386 |            199 |
|       467 | Magmortar  |       467 |     16 |    680 |            199 |
|       468 | Togekiss   |       468 |     15 |    380 |            220 |
|       469 | Yanmega    |       469 |     19 |    515 |            198 |
|       470 | Leafeon    |       470 |     10 |    255 |            196 |
|       471 | Glaceon    |       471 |      8 |    259 |            196 |
|       472 | Gliscor    |       472 |     20 |    425 |            192 |
|       473 | Mamoswine  |       473 |     25 |   2910 |            207 |
|       474 | Porygon-Z  |       474 |      9 |    340 |            185 |
|       475 | Gallade    |       475 |     16 |    520 |            208 |
|       476 | Probopass  |       476 |     14 |   3400 |            198 |
|       477 | Dusknoir   |       477 |     22 |   1066 |            210 |
|       478 | Froslass   |       478 |     13 |    266 |            187 |
|       479 | Rotom      |       479 |      3 |      3 |            132 |
|       480 | Uxie       |       480 |      3 |      3 |            210 |
|       481 | Mesprit    |       481 |      3 |      3 |            210 |
|       482 | Azelf      |       482 |      3 |      3 |            210 |
|       483 | Dialga     |       483 |     54 |   6830 |            220 |
|       484 | Palkia     |       484 |     42 |   3360 |            220 |
|       485 | Heatran    |       485 |     17 |   4300 |            215 |
|       486 | Regigigas  |       486 |     37 |   4200 |            220 |
|       487 | Giratina   |       487 |     45 |   7500 |            220 |
|       488 | Cresselia  |       488 |     15 |    856 |            210 |
|       489 | Phione     |       489 |      4 |     31 |            165 |
|       490 | Manaphy    |       490 |      3 |     14 |            215 |
|       491 | Darkrai    |       491 |     15 |    505 |            210 |
|       492 | Shaymin    |       492 |      2 |     21 |             64 |
|       493 | Arceus     |       493 |     32 |   3200 |            255 |
|       494 | Victini    |       494 |      4 |     40 |            270 |
|       495 | Snivy      |       495 |      6 |     81 |             28 |
|       496 | Servine    |       496 |      8 |    160 |            145 |
|       497 | Serperior  |       497 |     33 |    630 |            238 |
|       498 | Tepig      |       498 |      5 |     99 |             28 |
|       499 | Pignite    |       499 |     10 |    555 |            146 |
|       500 | Emboar     |       500 |     16 |   1500 |            238 |
|       501 | Oshawott   |       501 |      5 |     59 |             28 |
|       502 | Dewott     |       502 |      8 |    245 |            145 |
|       503 | Samurott   |       503 |     15 |    946 |            238 |
|       504 | Patrat     |       504 |      5 |    116 |             51 |
|       505 | Watchog    |       505 |     11 |    270 |            147 |
|       506 | Lillipup   |       506 |      4 |     41 |             55 |
|       507 | Herdier    |       507 |      9 |    147 |            130 |
|       508 | Stoutland  |       508 |     12 |    610 |            221 |
|       509 | Purrloin   |       509 |      4 |    101 |             56 |
|       510 | Liepard    |       510 |     11 |    375 |            156 |
|       511 | Pansage    |       511 |      6 |    105 |             63 |
|       512 | Simisage   |       512 |     11 |    305 |            174 |
|       513 | Pansear    |       513 |      6 |    110 |             63 |
|       514 | Simisear   |       514 |     10 |    280 |            174 |
|       515 | Panpour    |       515 |      6 |    135 |             63 |
|       516 | Simipour   |       516 |     10 |    290 |            174 |
|       517 | Munna      |       517 |      6 |    233 |             58 |
|       518 | Musharna   |       518 |     11 |    605 |            170 |
|       519 | Pidove     |       519 |      3 |     21 |             53 |
|       520 | Tranquill  |       520 |      6 |    150 |            125 |
|       521 | Unfezant   |       521 |     12 |    290 |            215 |
|       522 | Blitzle    |       522 |      8 |    298 |             59 |
|       523 | Zebstrika  |       523 |     16 |    795 |            174 |
|       524 | Roggenrola |       524 |      4 |    180 |             56 |
|       525 | Boldore    |       525 |      9 |   1020 |            137 |
|       526 | Gigalith   |       526 |     17 |   2600 |            227 |
|       527 | Woobat     |       527 |      4 |     21 |             63 |
|       528 | Swoobat    |       528 |      9 |    105 |            149 |
|       529 | Drilbur    |       529 |      3 |     85 |             66 |
|       530 | Excadrill  |       530 |      7 |    404 |            178 |
|       531 | Audino     |       531 |     11 |    310 |            390 |
|       532 | Timburr    |       532 |      6 |    125 |             61 |
|       533 | Gurdurr    |       533 |     12 |    400 |            142 |
|       534 | Conkeldurr |       534 |     14 |    870 |            227 |
|       535 | Tympole    |       535 |      5 |     45 |             59 |
|       536 | Palpitoad  |       536 |      8 |    170 |            134 |
|       537 | Seismitoad |       537 |     15 |    620 |            225 |
|       538 | Throh      |       538 |     13 |    555 |            163 |
|       539 | Sawk       |       539 |     14 |    510 |            163 |
|       540 | Sewaddle   |       540 |      3 |     25 |             62 |
|       541 | Swadloon   |       541 |      5 |     73 |            133 |
|       542 | Leavanny   |       542 |     12 |    205 |            221 |
|       543 | Venipede   |       543 |      4 |     53 |             52 |
|       544 | Whirlipede |       544 |     12 |    585 |            126 |
|       545 | Scolipede  |       545 |     25 |   2005 |            214 |
|       546 | Cottonee   |       546 |      3 |      6 |             56 |
|       547 | Whimsicott |       547 |      7 |     66 |            168 |
|       548 | Petilil    |       548 |      5 |     66 |             56 |
|       549 | Lilligant  |       549 |     11 |    163 |            168 |
|       550 | Basculin   |       550 |     10 |    180 |            161 |
|       551 | Sandile    |       551 |      7 |    152 |             58 |
|       552 | Krokorok   |       552 |     10 |    334 |            123 |
|       553 | Krookodile |       553 |     15 |    963 |            229 |
|       554 | Darumaka   |       554 |      6 |    375 |             63 |
|       555 | Darmanitan |       555 |     13 |    929 |            168 |
|       556 | Maractus   |       556 |     10 |    280 |            161 |
|       557 | Dwebble    |       557 |      3 |    145 |             65 |
|       558 | Crustle    |       558 |     14 |   2000 |            166 |
|       559 | Scraggy    |       559 |      6 |    118 |             70 |
|       560 | Scrafty    |       560 |     11 |    300 |            171 |
|       561 | Sigilyph   |       561 |     14 |    140 |            172 |
|       562 | Yamask     |       562 |      5 |     15 |             61 |
|       563 | Cofagrigus |       563 |     17 |    765 |            169 |
|       564 | Tirtouga   |       564 |      7 |    165 |             71 |
|       565 | Carracosta |       565 |     12 |    810 |            173 |
|       566 | Archen     |       566 |      5 |     95 |             71 |
|       567 | Archeops   |       567 |     14 |    320 |            177 |
|       568 | Trubbish   |       568 |      6 |    310 |             66 |
|       569 | Garbodor   |       569 |     19 |   1073 |            166 |
|       570 | Zorua      |       570 |      7 |    125 |             66 |
|       571 | Zoroark    |       571 |     16 |    811 |            179 |
|       572 | Minccino   |       572 |      4 |     58 |             60 |
|       573 | Cinccino   |       573 |      5 |     75 |            165 |
|       574 | Gothita    |       574 |      4 |     58 |             58 |
|       575 | Gothorita  |       575 |      7 |    180 |            137 |
|       576 | Gothitelle |       576 |     15 |    440 |            221 |
|       577 | Solosis    |       577 |      3 |     10 |             58 |
|       578 | Duosion    |       578 |      6 |     80 |            130 |
|       579 | Reuniclus  |       579 |     10 |    201 |            221 |
|       580 | Ducklett   |       580 |      5 |     55 |             61 |
|       581 | Swanna     |       581 |     13 |    242 |            166 |
|       582 | Vanillite  |       582 |      4 |     57 |             61 |
|       583 | Vanillish  |       583 |     11 |    410 |            138 |
|       584 | Vanilluxe  |       584 |     13 |    575 |            241 |
|       585 | Deerling   |       585 |      6 |    195 |             67 |
|       586 | Sawsbuck   |       586 |     19 |    925 |            166 |
|       587 | Emolga     |       587 |      4 |     50 |            150 |
|       588 | Karrablast |       588 |      5 |     59 |             63 |
|       589 | Escavalier |       589 |     10 |    330 |            173 |
|       590 | Foongus    |       590 |      2 |     10 |             59 |
|       591 | Amoonguss  |       591 |      6 |    105 |            162 |
|       592 | Frillish   |       592 |     12 |    330 |             67 |
|       593 | Jellicent  |       593 |     22 |   1350 |            168 |
|       594 | Alomomola  |       594 |     12 |    316 |            165 |
|       595 | Joltik     |       595 |      1 |      6 |             64 |
|       596 | Galvantula |       596 |      8 |    143 |            165 |
|       597 | Ferroseed  |       597 |      6 |    188 |             61 |
|       598 | Ferrothorn |       598 |     10 |   1100 |            171 |
|       599 | Klink      |       599 |      3 |    210 |             60 |
|       600 | Klang      |       600 |      6 |    510 |            154 |
|       601 | Klinklang  |       601 |      6 |    810 |            234 |
|       602 | Tynamo     |       602 |      2 |      3 |             55 |
|       603 | Eelektrik  |       603 |     12 |    220 |            142 |
|       604 | Eelektross |       604 |     21 |    805 |            232 |
|       605 | Elgyem     |       605 |      5 |     90 |             67 |
|       606 | Beheeyem   |       606 |     10 |    345 |            170 |
|       607 | Litwick    |       607 |      3 |     31 |             55 |
|       608 | Lampent    |       608 |      6 |    130 |            130 |
|       609 | Chandelure |       609 |     10 |    343 |            234 |
|       610 | Axew       |       610 |      6 |    180 |             64 |
|       611 | Fraxure    |       611 |     10 |    360 |            144 |
|       612 | Haxorus    |       612 |     18 |   1055 |            243 |
|       613 | Cubchoo    |       613 |      5 |     85 |             61 |
|       614 | Beartic    |       614 |     26 |   2600 |            170 |
|       615 | Cryogonal  |       615 |     11 |   1480 |            170 |
|       616 | Shelmet    |       616 |      4 |     77 |             61 |
|       617 | Accelgor   |       617 |      8 |    253 |            173 |
|       618 | Stunfisk   |       618 |      7 |    110 |            165 |
|       619 | Mienfoo    |       619 |      9 |    200 |             70 |
|       620 | Mienshao   |       620 |     14 |    355 |            179 |
|       621 | Druddigon  |       621 |     16 |   1390 |            170 |
|       622 | Golett     |       622 |     10 |    920 |             61 |
|       623 | Golurk     |       623 |     28 |   3300 |            169 |
|       624 | Pawniard   |       624 |      5 |    102 |             68 |
|       625 | Bisharp    |       625 |     16 |    700 |            172 |
|       626 | Bouffalant |       626 |     16 |    946 |            172 |
|       627 | Rufflet    |       627 |      5 |    105 |             70 |
|       628 | Braviary   |       628 |     15 |    410 |            179 |
|       629 | Vullaby    |       629 |      5 |     90 |             74 |
|       630 | Mandibuzz  |       630 |     12 |    395 |            179 |
|       631 | Heatmor    |       631 |     14 |    580 |            169 |
|       632 | Durant     |       632 |      3 |    330 |            169 |
|       633 | Deino      |       633 |      8 |    173 |             60 |
|       634 | Zweilous   |       634 |     14 |    500 |            147 |
|       635 | Hydreigon  |       635 |     18 |   1600 |            270 |
|       636 | Larvesta   |       636 |     11 |    288 |             72 |
|       637 | Volcarona  |       637 |     16 |    460 |            248 |
|       638 | Cobalion   |       638 |     21 |   2500 |            261 |
|       639 | Terrakion  |       639 |     19 |   2600 |            261 |
|       640 | Virizion   |       640 |     20 |   2000 |            261 |
|       641 | Tornadus   |       641 |     15 |    630 |            261 |
|       642 | Thundurus  |       642 |     15 |    610 |            261 |
|       643 | Reshiram   |       643 |     32 |   3300 |            306 |
|       644 | Zekrom     |       644 |     29 |   3450 |            306 |
|       645 | Landorus   |       645 |     15 |    680 |            270 |
|       646 | Kyurem     |       646 |     30 |   3250 |            297 |
|       647 | Keldeo     |       647 |     14 |    485 |            261 |
|       648 | Meloetta   |       648 |      6 |     65 |            270 |
|       649 | Genesect   |       649 |     15 |    825 |            270 |
+-----------+------------+-----------+--------+--------+----------------+
649 rows in set (0.02 sec)

mysql> select * from Pokemon JOIN Attributes ON Pokemon.PokeDexId = Attributes.PokeDexId limit 10;
+-----------+------------+-----------+--------+--------+----------------+
| PokedexID | Name       | PokedexID | Height | Weight | BaseExperience |
+-----------+------------+-----------+--------+--------+----------------+
|         1 | Bulbasaur  |         1 |      7 |     69 |             64 |
|         2 | Ivysaur    |         2 |     10 |    130 |            141 |
|         3 | Venusaur   |         3 |     20 |   1000 |            208 |
|         4 | Charmander |         4 |      6 |     85 |             65 |
|         5 | Charmeleon |         5 |     11 |    190 |            142 |
|         6 | Charizard  |         6 |     17 |    905 |            209 |
|         7 | Squirtle   |         7 |      5 |     90 |             66 |
|         8 | Wartortle  |         8 |     10 |    225 |            143 |
|         9 | Blastoise  |         9 |     16 |    855 |            210 |
|        10 | Caterpie   |        10 |      3 |     29 |             53 |
+-----------+------------+-----------+--------+--------+----------------+
10 rows in set (0.00 sec)

mysql> select * from Pokemon INNER JOIN Attributes ON Pokemon.PokeDexId = Attributes.PokeDexId limit 10;
+-----------+------------+-----------+--------+--------+----------------+
| PokedexID | Name       | PokedexID | Height | Weight | BaseExperience |
+-----------+------------+-----------+--------+--------+----------------+
|         1 | Bulbasaur  |         1 |      7 |     69 |             64 |
|         2 | Ivysaur    |         2 |     10 |    130 |            141 |
|         3 | Venusaur   |         3 |     20 |   1000 |            208 |
|         4 | Charmander |         4 |      6 |     85 |             65 |
|         5 | Charmeleon |         5 |     11 |    190 |            142 |
|         6 | Charizard  |         6 |     17 |    905 |            209 |
|         7 | Squirtle   |         7 |      5 |     90 |             66 |
|         8 | Wartortle  |         8 |     10 |    225 |            143 |
|         9 | Blastoise  |         9 |     16 |    855 |            210 |
|        10 | Caterpie   |        10 |      3 |     29 |             53 |
+-----------+------------+-----------+--------+--------+----------------+
10 rows in set (0.00 sec)

mysql> select * from Pokemon INNER JOIN Attributes using (PokeDexId);
+-----------+------------+--------+--------+----------------+
| PokedexID | Name       | Height | Weight | BaseExperience |
+-----------+------------+--------+--------+----------------+
|         1 | Bulbasaur  |      7 |     69 |             64 |
|         2 | Ivysaur    |     10 |    130 |            141 |
|         3 | Venusaur   |     20 |   1000 |            208 |
|         4 | Charmander |      6 |     85 |             65 |
|         5 | Charmeleon |     11 |    190 |            142 |
|         6 | Charizard  |     17 |    905 |            209 |
|         7 | Squirtle   |      5 |     90 |             66 |
|         8 | Wartortle  |     10 |    225 |            143 |
|         9 | Blastoise  |     16 |    855 |            210 |
|        10 | Caterpie   |      3 |     29 |             53 |
|        11 | Metapod    |      7 |     99 |             72 |
|        12 | Butterfree |     11 |    320 |            160 |
|        13 | Weedle     |      3 |     32 |             52 |
|        14 | Kakuna     |      6 |    100 |             71 |
|        15 | Beedrill   |     10 |    295 |            159 |
|        16 | Pidgey     |      3 |     18 |             55 |
|        17 | Pidgeotto  |     11 |    300 |            113 |
|        18 | Pidgeot    |     15 |    395 |            172 |
|        19 | Rattata    |      3 |     35 |             57 |
|        20 | Raticate   |      7 |    185 |            116 |
|        21 | Spearow    |      3 |     20 |             58 |
|        22 | Fearow     |     12 |    380 |            162 |
|        23 | Ekans      |     20 |     69 |             62 |
|        24 | Arbok      |     35 |    650 |            147 |
|        25 | Pikachu    |      4 |     60 |             82 |
|        26 | Raichu     |      8 |    300 |            122 |
|        27 | Sandshrew  |      6 |    120 |             93 |
|        28 | Sandslash  |     10 |    295 |            163 |
|        29 | Nidoran♀ |      4 |     70 |             59 |
|        30 | Nidorina   |      8 |    200 |            117 |
|        31 | Nidoqueen  |     13 |    600 |            194 |
|        32 | Nidoran♂ |      5 |     90 |             60 |
|        33 | Nidorino   |      9 |    195 |            118 |
|        34 | Nidoking   |     14 |    620 |            195 |
|        35 | Clefairy   |      6 |     75 |             68 |
|        36 | Clefable   |     13 |    400 |            129 |
|        37 | Vulpix     |      6 |     99 |             63 |
|        38 | Ninetales  |     11 |    199 |            178 |
|        39 | Jigglypuff |      5 |     55 |             76 |
|        40 | Wigglytuff |     10 |    120 |            109 |
|        41 | Zubat      |      8 |     75 |             54 |
|        42 | Golbat     |     16 |    550 |            171 |
|        43 | Oddish     |      5 |     54 |             78 |
|        44 | Gloom      |      8 |     86 |            132 |
|        45 | Vileplume  |     12 |    186 |            184 |
|        46 | Paras      |      3 |     54 |             70 |
|        47 | Parasect   |     10 |    295 |            128 |
|        48 | Venonat    |     10 |    300 |             75 |
|        49 | Venomoth   |     15 |    125 |            138 |
|        50 | Diglett    |      2 |      8 |             81 |
|        51 | Dugtrio    |      7 |    333 |            153 |
|        52 | Meowth     |      4 |     42 |             69 |
|        53 | Persian    |     10 |    320 |            148 |
|        54 | Psyduck    |      8 |    196 |             80 |
|        55 | Golduck    |     17 |    766 |            174 |
|        56 | Mankey     |      5 |    280 |             74 |
|        57 | Primeape   |     10 |    320 |            149 |
|        58 | Growlithe  |      7 |    190 |             91 |
|        59 | Arcanine   |     19 |   1550 |            213 |
|        60 | Poliwag    |      6 |    124 |             77 |
|        61 | Poliwhirl  |     10 |    200 |            131 |
|        62 | Poliwrath  |     13 |    540 |            185 |
|        63 | Abra       |      9 |    195 |             75 |
|        64 | Kadabra    |     13 |    565 |            145 |
|        65 | Alakazam   |     15 |    480 |            186 |
|        66 | Machop     |      8 |    195 |             75 |
|        67 | Machoke    |     15 |    705 |            146 |
|        68 | Machamp    |     16 |   1300 |            193 |
|        69 | Bellsprout |      7 |     40 |             84 |
|        70 | Weepinbell |     10 |     64 |            151 |
|        71 | Victreebel |     17 |    155 |            191 |
|        72 | Tentacool  |      9 |    455 |            105 |
|        73 | Tentacruel |     16 |    550 |            205 |
|        74 | Geodude    |      4 |    200 |             73 |
|        75 | Graveler   |     10 |   1050 |            134 |
|        76 | Golem      |     14 |   3000 |            177 |
|        77 | Ponyta     |     10 |    300 |            152 |
|        78 | Rapidash   |     17 |    950 |            192 |
|        79 | Slowpoke   |     12 |    360 |             99 |
|        80 | Slowbro    |     16 |    785 |            164 |
|        81 | Magnemite  |      3 |     60 |             89 |
|        82 | Magneton   |     10 |    600 |            161 |
|        83 | Farfetch'd |      8 |    150 |             94 |
|        84 | Doduo      |     14 |    392 |             96 |
|        85 | Dodrio     |     18 |    852 |            158 |
|        86 | Seel       |     11 |    900 |            100 |
|        87 | Dewgong    |     17 |   1200 |            176 |
|        88 | Grimer     |      9 |    300 |             90 |
|        89 | Muk        |     12 |    300 |            157 |
|        90 | Shellder   |      3 |     40 |             97 |
|        91 | Cloyster   |     15 |   1325 |            203 |
|        92 | Gastly     |     13 |      1 |             95 |
|        93 | Haunter    |     16 |      1 |            126 |
|        94 | Gengar     |     15 |    405 |            190 |
|        95 | Onix       |     88 |   2100 |            108 |
|        96 | Drowzee    |     10 |    324 |            102 |
|        97 | Hypno      |     16 |    756 |            165 |
|        98 | Krabby     |      4 |     65 |            115 |
|        99 | Kingler    |     13 |    600 |            206 |
|       100 | Voltorb    |      5 |    104 |            103 |
|       101 | Electrode  |     12 |    666 |            150 |
|       102 | Exeggcute  |      4 |     25 |             98 |
|       103 | Exeggutor  |     20 |   1200 |            212 |
|       104 | Cubone     |      4 |     65 |             87 |
|       105 | Marowak    |     10 |    450 |            124 |
|       106 | Hitmonlee  |     15 |    498 |            139 |
|       107 | Hitmonchan |     14 |    502 |            140 |
|       108 | Lickitung  |     12 |    655 |            127 |
|       109 | Koffing    |      6 |     10 |            114 |
|       110 | Weezing    |     12 |     95 |            173 |
|       111 | Rhyhorn    |     10 |   1150 |            135 |
|       112 | Rhydon     |     19 |   1200 |            204 |
|       113 | Chansey    |     11 |    346 |            255 |
|       114 | Tangela    |     10 |    350 |            166 |
|       115 | Kangaskhan |     22 |    800 |            175 |
|       116 | Horsea     |      4 |     80 |             83 |
|       117 | Seadra     |     12 |    250 |            155 |
|       118 | Goldeen    |      6 |    150 |            111 |
|       119 | Seaking    |     13 |    390 |            170 |
|       120 | Staryu     |      8 |    345 |            106 |
|       121 | Starmie    |     11 |    800 |            207 |
|       122 | Mr. Mime   |     13 |    545 |            136 |
|       123 | Scyther    |     15 |    560 |            187 |
|       124 | Jynx       |     14 |    406 |            137 |
|       125 | Electabuzz |     11 |    300 |            156 |
|       126 | Magmar     |     13 |    445 |            167 |
|       127 | Pinsir     |     15 |    550 |            200 |
|       128 | Tauros     |     14 |    884 |            211 |
|       129 | Magikarp   |      9 |    100 |             20 |
|       130 | Gyarados   |     65 |   2350 |            214 |
|       131 | Lapras     |     25 |   2200 |            219 |
|       132 | Ditto      |      3 |     40 |             61 |
|       133 | Eevee      |      3 |     65 |             92 |
|       134 | Vaporeon   |     10 |    290 |            196 |
|       135 | Jolteon    |      8 |    245 |            197 |
|       136 | Flareon    |      9 |    250 |            198 |
|       137 | Porygon    |      8 |    365 |            130 |
|       138 | Omanyte    |      4 |     75 |             99 |
|       139 | Omastar    |     10 |    350 |            199 |
|       140 | Kabuto     |      5 |    115 |             99 |
|       141 | Kabutops   |     13 |    405 |            199 |
|       142 | Aerodactyl |     18 |    590 |            202 |
|       143 | Snorlax    |     21 |   4600 |            154 |
|       144 | Articuno   |     17 |    554 |            215 |
|       145 | Zapdos     |     16 |    526 |            216 |
|       146 | Moltres    |     20 |    600 |            217 |
|       147 | Dratini    |     18 |     33 |             67 |
|       148 | Dragonair  |     40 |    165 |            144 |
|       149 | Dragonite  |     22 |   2100 |            218 |
|       150 | Mewtwo     |     20 |   1220 |            220 |
|       151 | Mew        |      4 |     40 |             64 |
|       152 | Chikorita  |      9 |     64 |             64 |
|       153 | Bayleef    |     12 |    158 |            141 |
|       154 | Meganium   |     18 |   1005 |            208 |
|       155 | Cyndaquil  |      5 |     79 |             65 |
|       156 | Quilava    |      9 |    190 |            142 |
|       157 | Typhlosion |     17 |    795 |            209 |
|       158 | Totodile   |      6 |     95 |             66 |
|       159 | Croconaw   |     11 |    250 |            143 |
|       160 | Feraligatr |     23 |    888 |            210 |
|       161 | Sentret    |      8 |     60 |             57 |
|       162 | Furret     |     18 |    325 |            116 |
|       163 | Hoothoot   |      7 |    212 |             58 |
|       164 | Noctowl    |     16 |    408 |            162 |
|       165 | Ledyba     |     10 |    108 |             54 |
|       166 | Ledian     |     14 |    356 |            134 |
|       167 | Spinarak   |      5 |     85 |             54 |
|       168 | Ariados    |     11 |    335 |            134 |
|       169 | Crobat     |     18 |    750 |            204 |
|       170 | Chinchou   |      5 |    120 |             90 |
|       171 | Lanturn    |     12 |    225 |            156 |
|       172 | Pichu      |      3 |     20 |             42 |
|       173 | Cleffa     |      3 |     30 |             37 |
|       174 | Igglybuff  |      3 |     10 |             39 |
|       175 | Togepi     |      3 |     15 |             74 |
|       176 | Togetic    |      6 |     32 |            114 |
|       177 | Natu       |      2 |     20 |             73 |
|       178 | Xatu       |     15 |    150 |            171 |
|       179 | Mareep     |      6 |     78 |             59 |
|       180 | Flaaffy    |      8 |    133 |            117 |
|       181 | Ampharos   |     14 |    615 |            194 |
|       182 | Bellossom  |      4 |     58 |            184 |
|       183 | Marill     |      4 |     85 |             58 |
|       184 | Azumarill  |      8 |    285 |            153 |
|       185 | Sudowoodo  |     12 |    380 |            135 |
|       186 | Politoed   |     11 |    339 |            185 |
|       187 | Hoppip     |      4 |      5 |             74 |
|       188 | Skiploom   |      6 |     10 |            136 |
|       189 | Jumpluff   |      8 |     30 |            176 |
|       190 | Aipom      |      8 |    115 |             94 |
|       191 | Sunkern    |      3 |     18 |             52 |
|       192 | Sunflora   |      8 |     85 |            146 |
|       193 | Yanma      |     12 |    380 |            147 |
|       194 | Wooper     |      4 |     85 |             52 |
|       195 | Quagsire   |     14 |    750 |            137 |
|       196 | Espeon     |      9 |    265 |            197 |
|       197 | Umbreon    |     10 |    270 |            197 |
|       198 | Murkrow    |      5 |     21 |            107 |
|       199 | Slowking   |     20 |    795 |            164 |
|       200 | Misdreavus |      7 |     10 |            147 |
|       201 | Unown      |      5 |     50 |             61 |
|       202 | Wobbuffet  |     13 |    285 |            177 |
|       203 | Girafarig  |     15 |    415 |            149 |
|       204 | Pineco     |      6 |     72 |             60 |
|       205 | Forretress |     12 |   1258 |            118 |
|       206 | Dunsparce  |     15 |    140 |            125 |
|       207 | Gligar     |     11 |    648 |            108 |
|       208 | Steelix    |     92 |   4000 |            196 |
|       209 | Snubbull   |      6 |     78 |             63 |
|       210 | Granbull   |     14 |    487 |            178 |
|       211 | Qwilfish   |      5 |     39 |            100 |
|       212 | Scizor     |     18 |   1180 |            200 |
|       213 | Shuckle    |      6 |    205 |             80 |
|       214 | Heracross  |     15 |    540 |            200 |
|       215 | Sneasel    |      9 |    280 |            132 |
|       216 | Teddiursa  |      6 |     88 |            124 |
|       217 | Ursaring   |     18 |   1258 |            189 |
|       218 | Slugma     |      7 |    350 |             78 |
|       219 | Magcargo   |      8 |    550 |            154 |
|       220 | Swinub     |      4 |     65 |             78 |
|       221 | Piloswine  |     11 |    558 |            160 |
|       222 | Corsola    |      6 |     50 |            113 |
|       223 | Remoraid   |      6 |    120 |             78 |
|       224 | Octillery  |      9 |    285 |            164 |
|       225 | Delibird   |      9 |    160 |            183 |
|       226 | Mantine    |     21 |   2200 |            168 |
|       227 | Skarmory   |     17 |    505 |            168 |
|       228 | Houndour   |      6 |    108 |            114 |
|       229 | Houndoom   |     14 |    350 |            204 |
|       230 | Kingdra    |     18 |   1520 |            207 |
|       231 | Phanpy     |      5 |    335 |            124 |
|       232 | Donphan    |     11 |   1200 |            189 |
|       233 | Porygon2   |      6 |    325 |            180 |
|       234 | Stantler   |     14 |    712 |            165 |
|       235 | Smeargle   |     12 |    580 |            106 |
|       236 | Tyrogue    |      7 |    210 |             91 |
|       237 | Hitmontop  |     14 |    480 |            138 |
|       238 | Smoochum   |      4 |     60 |             87 |
|       239 | Elekid     |      6 |    235 |            106 |
|       240 | Magby      |      7 |    214 |            117 |
|       241 | Miltank    |     12 |    755 |            200 |
|       242 | Blissey    |     15 |    468 |            255 |
|       243 | Raikou     |     19 |   1780 |            216 |
|       244 | Entei      |     21 |   1980 |            217 |
|       245 | Suicune    |     20 |   1870 |            215 |
|       246 | Larvitar   |      6 |    720 |             67 |
|       247 | Pupitar    |     12 |   1520 |            144 |
|       248 | Tyranitar  |     20 |   2020 |            218 |
|       249 | Lugia      |     52 |   2160 |            220 |
|       250 | Ho-Oh      |     38 |   1990 |            220 |
|       251 | Celebi     |      6 |     50 |             64 |
|       252 | Treecko    |      5 |     50 |             65 |
|       253 | Grovyle    |      9 |    216 |            141 |
|       254 | Sceptile   |     17 |    522 |            208 |
|       255 | Torchic    |      4 |     25 |             65 |
|       256 | Combusken  |      9 |    195 |            142 |
|       257 | Blaziken   |     19 |    520 |            209 |
|       258 | Mudkip     |      4 |     76 |             65 |
|       259 | Marshtomp  |      7 |    280 |            143 |
|       260 | Swampert   |     15 |    819 |            210 |
|       261 | Poochyena  |      5 |    136 |             55 |
|       262 | Mightyena  |     10 |    370 |            128 |
|       263 | Zigzagoon  |      4 |    175 |             60 |
|       264 | Linoone    |      5 |    325 |            128 |
|       265 | Wurmple    |      3 |     36 |             54 |
|       266 | Silcoon    |      6 |    100 |             72 |
|       267 | Beautifly  |     10 |    284 |            161 |
|       268 | Cascoon    |      7 |    115 |             72 |
|       269 | Dustox     |     12 |    316 |            161 |
|       270 | Lotad      |      5 |     26 |             74 |
|       271 | Lombre     |     12 |    325 |            141 |
|       272 | Ludicolo   |     15 |    550 |            181 |
|       273 | Seedot     |      5 |     40 |             74 |
|       274 | Nuzleaf    |     10 |    280 |            141 |
|       275 | Shiftry    |     13 |    596 |            181 |
|       276 | Taillow    |      3 |     23 |             59 |
|       277 | Swellow    |      7 |    198 |            162 |
|       278 | Wingull    |      6 |     95 |             64 |
|       279 | Pelipper   |     12 |    280 |            164 |
|       280 | Ralts      |      4 |     66 |             70 |
|       281 | Kirlia     |      8 |    202 |            140 |
|       282 | Gardevoir  |     16 |    484 |            208 |
|       283 | Surskit    |      5 |     17 |             63 |
|       284 | Masquerain |      8 |     36 |            128 |
|       285 | Shroomish  |      4 |     45 |             65 |
|       286 | Breloom    |     12 |    392 |            165 |
|       287 | Slakoth    |      8 |    240 |             83 |
|       288 | Vigoroth   |     14 |    465 |            126 |
|       289 | Slaking    |     20 |   1305 |            210 |
|       290 | Nincada    |      5 |     55 |             65 |
|       291 | Ninjask    |      8 |    120 |            155 |
|       292 | Shedinja   |      8 |     12 |             95 |
|       293 | Whismur    |      6 |    163 |             68 |
|       294 | Loudred    |     10 |    405 |            126 |
|       295 | Exploud    |     15 |    840 |            184 |
|       296 | Makuhita   |     10 |    864 |             87 |
|       297 | Hariyama   |     23 |   2538 |            184 |
|       298 | Azurill    |      2 |     20 |             33 |
|       299 | Nosepass   |     10 |    970 |            108 |
|       300 | Skitty     |      6 |    110 |             65 |
|       301 | Delcatty   |     11 |    326 |            138 |
|       302 | Sableye    |      5 |    110 |             98 |
|       303 | Mawile     |      6 |    115 |             98 |
|       304 | Aron       |      4 |    600 |             96 |
|       305 | Lairon     |      9 |   1200 |            152 |
|       306 | Aggron     |     21 |   3600 |            205 |
|       307 | Meditite   |      6 |    112 |             91 |
|       308 | Medicham   |     13 |    315 |            153 |
|       309 | Electrike  |      6 |    152 |            104 |
|       310 | Manectric  |     15 |    402 |            168 |
|       311 | Plusle     |      4 |     42 |            120 |
|       312 | Minun      |      4 |     42 |            120 |
|       313 | Volbeat    |      7 |    177 |            146 |
|       314 | Illumise   |      6 |    177 |            146 |
|       315 | Roselia    |      3 |     20 |            152 |
|       316 | Gulpin     |      4 |    103 |             75 |
|       317 | Swalot     |     17 |    800 |            168 |
|       318 | Carvanha   |      8 |    208 |             88 |
|       319 | Sharpedo   |     18 |    888 |            175 |
|       320 | Wailmer    |     20 |   1300 |            137 |
|       321 | Wailord    |    145 |   3980 |            206 |
|       322 | Numel      |      7 |    240 |             88 |
|       323 | Camerupt   |     19 |   2200 |            175 |
|       324 | Torkoal    |      5 |    804 |            161 |
|       325 | Spoink     |      7 |    306 |             89 |
|       326 | Grumpig    |      9 |    715 |            164 |
|       327 | Spinda     |     11 |     50 |             85 |
|       328 | Trapinch   |      7 |    150 |             73 |
|       329 | Vibrava    |     11 |    153 |            126 |
|       330 | Flygon     |     20 |    820 |            197 |
|       331 | Cacnea     |      4 |    513 |             97 |
|       332 | Cacturne   |     13 |    774 |            177 |
|       333 | Swablu     |      4 |     12 |             74 |
|       334 | Altaria    |     11 |    206 |            188 |
|       335 | Zangoose   |     13 |    403 |            165 |
|       336 | Seviper    |     27 |    525 |            165 |
|       337 | Lunatone   |     10 |   1680 |            150 |
|       338 | Solrock    |     12 |   1540 |            150 |
|       339 | Barboach   |      4 |     19 |             92 |
|       340 | Whiscash   |      9 |    236 |            158 |
|       341 | Corphish   |      6 |    115 |            111 |
|       342 | Crawdaunt  |     11 |    328 |            161 |
|       343 | Baltoy     |      5 |    215 |             58 |
|       344 | Claydol    |     15 |   1080 |            189 |
|       345 | Lileep     |     10 |    238 |             99 |
|       346 | Cradily    |     15 |    604 |            199 |
|       347 | Anorith    |      7 |    125 |             99 |
|       348 | Armaldo    |     15 |    682 |            199 |
|       349 | Feebas     |      6 |     74 |             61 |
|       350 | Milotic    |     62 |   1620 |            213 |
|       351 | Castform   |      3 |      8 |            145 |
|       352 | Kecleon    |     10 |    220 |            132 |
|       353 | Shuppet    |      6 |     23 |             97 |
|       354 | Banette    |     11 |    125 |            179 |
|       355 | Duskull    |      8 |    150 |             97 |
|       356 | Dusclops   |     16 |    306 |            179 |
|       357 | Tropius    |     20 |   1000 |            169 |
|       358 | Chimecho   |      6 |     10 |            147 |
|       359 | Absol      |     12 |    470 |            174 |
|       360 | Wynaut     |      6 |    140 |             44 |
|       361 | Snorunt    |      7 |    168 |             74 |
|       362 | Glalie     |     15 |   2565 |            187 |
|       363 | Spheal     |      8 |    395 |             75 |
|       364 | Sealeo     |     11 |    876 |            128 |
|       365 | Walrein    |     14 |   1506 |            192 |
|       366 | Clamperl   |      4 |    525 |            142 |
|       367 | Huntail    |     17 |    270 |            178 |
|       368 | Gorebyss   |     18 |    226 |            178 |
|       369 | Relicanth  |     10 |    234 |            198 |
|       370 | Luvdisc    |      6 |     87 |            110 |
|       371 | Bagon      |      6 |    421 |             89 |
|       372 | Shelgon    |     11 |   1105 |            144 |
|       373 | Salamence  |     15 |   1026 |            218 |
|       374 | Beldum     |      6 |    952 |            103 |
|       375 | Metang     |     12 |   2025 |            153 |
|       376 | Metagross  |     16 |   5500 |            210 |
|       377 | Regirock   |     17 |   2300 |            217 |
|       378 | Regice     |     18 |   1750 |            216 |
|       379 | Registeel  |     19 |   2050 |            215 |
|       380 | Latias     |     14 |    400 |            211 |
|       381 | Latios     |     20 |    600 |            211 |
|       382 | Kyogre     |     45 |   3520 |            218 |
|       383 | Groudon    |     35 |   9500 |            218 |
|       384 | Rayquaza   |     70 |   2065 |            220 |
|       385 | Jirachi    |      3 |     11 |            215 |
|       386 | Deoxys     |     17 |    608 |            215 |
|       387 | Turtwig    |      4 |    102 |             64 |
|       388 | Grotle     |     11 |    970 |            141 |
|       389 | Torterra   |     22 |   3100 |            208 |
|       390 | Chimchar   |      5 |     62 |             65 |
|       391 | Monferno   |      9 |    220 |            142 |
|       392 | Infernape  |     12 |    550 |            209 |
|       393 | Piplup     |      4 |     52 |             66 |
|       394 | Prinplup   |      8 |    230 |            143 |
|       395 | Empoleon   |     17 |    845 |            210 |
|       396 | Starly     |      3 |     20 |             56 |
|       397 | Staravia   |      6 |    155 |            113 |
|       398 | Staraptor  |     12 |    249 |            172 |
|       399 | Bidoof     |      5 |    200 |             58 |
|       400 | Bibarel    |     10 |    315 |            116 |
|       401 | Kricketot  |      3 |     22 |             54 |
|       402 | Kricketune |     10 |    255 |            159 |
|       403 | Shinx      |      5 |     95 |             60 |
|       404 | Luxio      |      9 |    305 |            117 |
|       405 | Luxray     |     14 |    420 |            194 |
|       406 | Budew      |      2 |     12 |             68 |
|       407 | Roserade   |      9 |    145 |            204 |
|       408 | Cranidos   |      9 |    315 |             99 |
|       409 | Rampardos  |     16 |   1025 |            199 |
|       410 | Shieldon   |      5 |    570 |             99 |
|       411 | Bastiodon  |     13 |   1495 |            199 |
|       412 | Burmy      |      2 |     34 |             61 |
|       413 | Wormadam   |      5 |     65 |            159 |
|       414 | Mothim     |      9 |    233 |            159 |
|       415 | Combee     |      3 |     55 |             63 |
|       416 | Vespiquen  |     12 |    385 |            188 |
|       417 | Pachirisu  |      4 |     39 |            120 |
|       418 | Buizel     |      7 |    295 |             75 |
|       419 | Floatzel   |     11 |    335 |            178 |
|       420 | Cherubi    |      4 |     33 |             68 |
|       421 | Cherrim    |      5 |     93 |            133 |
|       422 | Shellos    |      3 |     63 |             73 |
|       423 | Gastrodon  |      9 |    299 |            176 |
|       424 | Ambipom    |     12 |    203 |            186 |
|       425 | Drifloon   |      4 |     12 |            127 |
|       426 | Drifblim   |     12 |    150 |            204 |
|       427 | Buneary    |      4 |     55 |             84 |
|       428 | Lopunny    |     12 |    333 |            178 |
|       429 | Mismagius  |      9 |     44 |            187 |
|       430 | Honchkrow  |      9 |    273 |            187 |
|       431 | Glameow    |      5 |     39 |             71 |
|       432 | Purugly    |     10 |    438 |            183 |
|       433 | Chingling  |      2 |      6 |             74 |
|       434 | Stunky     |      4 |    192 |             79 |
|       435 | Skuntank   |     10 |    380 |            209 |
|       436 | Bronzor    |      5 |    605 |             72 |
|       437 | Bronzong   |     13 |   1870 |            188 |
|       438 | Bonsly     |      5 |    150 |             68 |
|       439 | Mime Jr.   |      6 |    130 |             78 |
|       440 | Happiny    |      6 |    244 |            255 |
|       441 | Chatot     |      5 |     19 |            107 |
|       442 | Spiritomb  |     10 |   1080 |            168 |
|       443 | Gible      |      7 |    205 |             67 |
|       444 | Gabite     |     14 |    560 |            144 |
|       445 | Garchomp   |     19 |    950 |            218 |
|       446 | Munchlax   |      6 |   1050 |             94 |
|       447 | Riolu      |      7 |    202 |             72 |
|       448 | Lucario    |     12 |    540 |            204 |
|       449 | Hippopotas |      8 |    495 |             95 |
|       450 | Hippowdon  |     20 |   3000 |            198 |
|       451 | Skorupi    |      8 |    120 |            114 |
|       452 | Drapion    |     13 |    615 |            204 |
|       453 | Croagunk   |      7 |    230 |             83 |
|       454 | Toxicroak  |     13 |    444 |            181 |
|       455 | Carnivine  |     14 |    270 |            164 |
|       456 | Finneon    |      4 |     70 |             90 |
|       457 | Lumineon   |     12 |    240 |            156 |
|       458 | Mantyke    |     10 |    650 |            108 |
|       459 | Snover     |     10 |    505 |            131 |
|       460 | Abomasnow  |     22 |   1355 |            214 |
|       461 | Weavile    |     11 |    340 |            199 |
|       462 | Magnezone  |     12 |   1800 |            211 |
|       463 | Lickilicky |     17 |   1400 |            193 |
|       464 | Rhyperior  |     24 |   2828 |            217 |
|       465 | Tangrowth  |     20 |   1286 |            211 |
|       466 | Electivire |     18 |   1386 |            199 |
|       467 | Magmortar  |     16 |    680 |            199 |
|       468 | Togekiss   |     15 |    380 |            220 |
|       469 | Yanmega    |     19 |    515 |            198 |
|       470 | Leafeon    |     10 |    255 |            196 |
|       471 | Glaceon    |      8 |    259 |            196 |
|       472 | Gliscor    |     20 |    425 |            192 |
|       473 | Mamoswine  |     25 |   2910 |            207 |
|       474 | Porygon-Z  |      9 |    340 |            185 |
|       475 | Gallade    |     16 |    520 |            208 |
|       476 | Probopass  |     14 |   3400 |            198 |
|       477 | Dusknoir   |     22 |   1066 |            210 |
|       478 | Froslass   |     13 |    266 |            187 |
|       479 | Rotom      |      3 |      3 |            132 |
|       480 | Uxie       |      3 |      3 |            210 |
|       481 | Mesprit    |      3 |      3 |            210 |
|       482 | Azelf      |      3 |      3 |            210 |
|       483 | Dialga     |     54 |   6830 |            220 |
|       484 | Palkia     |     42 |   3360 |            220 |
|       485 | Heatran    |     17 |   4300 |            215 |
|       486 | Regigigas  |     37 |   4200 |            220 |
|       487 | Giratina   |     45 |   7500 |            220 |
|       488 | Cresselia  |     15 |    856 |            210 |
|       489 | Phione     |      4 |     31 |            165 |
|       490 | Manaphy    |      3 |     14 |            215 |
|       491 | Darkrai    |     15 |    505 |            210 |
|       492 | Shaymin    |      2 |     21 |             64 |
|       493 | Arceus     |     32 |   3200 |            255 |
|       494 | Victini    |      4 |     40 |            270 |
|       495 | Snivy      |      6 |     81 |             28 |
|       496 | Servine    |      8 |    160 |            145 |
|       497 | Serperior  |     33 |    630 |            238 |
|       498 | Tepig      |      5 |     99 |             28 |
|       499 | Pignite    |     10 |    555 |            146 |
|       500 | Emboar     |     16 |   1500 |            238 |
|       501 | Oshawott   |      5 |     59 |             28 |
|       502 | Dewott     |      8 |    245 |            145 |
|       503 | Samurott   |     15 |    946 |            238 |
|       504 | Patrat     |      5 |    116 |             51 |
|       505 | Watchog    |     11 |    270 |            147 |
|       506 | Lillipup   |      4 |     41 |             55 |
|       507 | Herdier    |      9 |    147 |            130 |
|       508 | Stoutland  |     12 |    610 |            221 |
|       509 | Purrloin   |      4 |    101 |             56 |
|       510 | Liepard    |     11 |    375 |            156 |
|       511 | Pansage    |      6 |    105 |             63 |
|       512 | Simisage   |     11 |    305 |            174 |
|       513 | Pansear    |      6 |    110 |             63 |
|       514 | Simisear   |     10 |    280 |            174 |
|       515 | Panpour    |      6 |    135 |             63 |
|       516 | Simipour   |     10 |    290 |            174 |
|       517 | Munna      |      6 |    233 |             58 |
|       518 | Musharna   |     11 |    605 |            170 |
|       519 | Pidove     |      3 |     21 |             53 |
|       520 | Tranquill  |      6 |    150 |            125 |
|       521 | Unfezant   |     12 |    290 |            215 |
|       522 | Blitzle    |      8 |    298 |             59 |
|       523 | Zebstrika  |     16 |    795 |            174 |
|       524 | Roggenrola |      4 |    180 |             56 |
|       525 | Boldore    |      9 |   1020 |            137 |
|       526 | Gigalith   |     17 |   2600 |            227 |
|       527 | Woobat     |      4 |     21 |             63 |
|       528 | Swoobat    |      9 |    105 |            149 |
|       529 | Drilbur    |      3 |     85 |             66 |
|       530 | Excadrill  |      7 |    404 |            178 |
|       531 | Audino     |     11 |    310 |            390 |
|       532 | Timburr    |      6 |    125 |             61 |
|       533 | Gurdurr    |     12 |    400 |            142 |
|       534 | Conkeldurr |     14 |    870 |            227 |
|       535 | Tympole    |      5 |     45 |             59 |
|       536 | Palpitoad  |      8 |    170 |            134 |
|       537 | Seismitoad |     15 |    620 |            225 |
|       538 | Throh      |     13 |    555 |            163 |
|       539 | Sawk       |     14 |    510 |            163 |
|       540 | Sewaddle   |      3 |     25 |             62 |
|       541 | Swadloon   |      5 |     73 |            133 |
|       542 | Leavanny   |     12 |    205 |            221 |
|       543 | Venipede   |      4 |     53 |             52 |
|       544 | Whirlipede |     12 |    585 |            126 |
|       545 | Scolipede  |     25 |   2005 |            214 |
|       546 | Cottonee   |      3 |      6 |             56 |
|       547 | Whimsicott |      7 |     66 |            168 |
|       548 | Petilil    |      5 |     66 |             56 |
|       549 | Lilligant  |     11 |    163 |            168 |
|       550 | Basculin   |     10 |    180 |            161 |
|       551 | Sandile    |      7 |    152 |             58 |
|       552 | Krokorok   |     10 |    334 |            123 |
|       553 | Krookodile |     15 |    963 |            229 |
|       554 | Darumaka   |      6 |    375 |             63 |
|       555 | Darmanitan |     13 |    929 |            168 |
|       556 | Maractus   |     10 |    280 |            161 |
|       557 | Dwebble    |      3 |    145 |             65 |
|       558 | Crustle    |     14 |   2000 |            166 |
|       559 | Scraggy    |      6 |    118 |             70 |
|       560 | Scrafty    |     11 |    300 |            171 |
|       561 | Sigilyph   |     14 |    140 |            172 |
|       562 | Yamask     |      5 |     15 |             61 |
|       563 | Cofagrigus |     17 |    765 |            169 |
|       564 | Tirtouga   |      7 |    165 |             71 |
|       565 | Carracosta |     12 |    810 |            173 |
|       566 | Archen     |      5 |     95 |             71 |
|       567 | Archeops   |     14 |    320 |            177 |
|       568 | Trubbish   |      6 |    310 |             66 |
|       569 | Garbodor   |     19 |   1073 |            166 |
|       570 | Zorua      |      7 |    125 |             66 |
|       571 | Zoroark    |     16 |    811 |            179 |
|       572 | Minccino   |      4 |     58 |             60 |
|       573 | Cinccino   |      5 |     75 |            165 |
|       574 | Gothita    |      4 |     58 |             58 |
|       575 | Gothorita  |      7 |    180 |            137 |
|       576 | Gothitelle |     15 |    440 |            221 |
|       577 | Solosis    |      3 |     10 |             58 |
|       578 | Duosion    |      6 |     80 |            130 |
|       579 | Reuniclus  |     10 |    201 |            221 |
|       580 | Ducklett   |      5 |     55 |             61 |
|       581 | Swanna     |     13 |    242 |            166 |
|       582 | Vanillite  |      4 |     57 |             61 |
|       583 | Vanillish  |     11 |    410 |            138 |
|       584 | Vanilluxe  |     13 |    575 |            241 |
|       585 | Deerling   |      6 |    195 |             67 |
|       586 | Sawsbuck   |     19 |    925 |            166 |
|       587 | Emolga     |      4 |     50 |            150 |
|       588 | Karrablast |      5 |     59 |             63 |
|       589 | Escavalier |     10 |    330 |            173 |
|       590 | Foongus    |      2 |     10 |             59 |
|       591 | Amoonguss  |      6 |    105 |            162 |
|       592 | Frillish   |     12 |    330 |             67 |
|       593 | Jellicent  |     22 |   1350 |            168 |
|       594 | Alomomola  |     12 |    316 |            165 |
|       595 | Joltik     |      1 |      6 |             64 |
|       596 | Galvantula |      8 |    143 |            165 |
|       597 | Ferroseed  |      6 |    188 |             61 |
|       598 | Ferrothorn |     10 |   1100 |            171 |
|       599 | Klink      |      3 |    210 |             60 |
|       600 | Klang      |      6 |    510 |            154 |
|       601 | Klinklang  |      6 |    810 |            234 |
|       602 | Tynamo     |      2 |      3 |             55 |
|       603 | Eelektrik  |     12 |    220 |            142 |
|       604 | Eelektross |     21 |    805 |            232 |
|       605 | Elgyem     |      5 |     90 |             67 |
|       606 | Beheeyem   |     10 |    345 |            170 |
|       607 | Litwick    |      3 |     31 |             55 |
|       608 | Lampent    |      6 |    130 |            130 |
|       609 | Chandelure |     10 |    343 |            234 |
|       610 | Axew       |      6 |    180 |             64 |
|       611 | Fraxure    |     10 |    360 |            144 |
|       612 | Haxorus    |     18 |   1055 |            243 |
|       613 | Cubchoo    |      5 |     85 |             61 |
|       614 | Beartic    |     26 |   2600 |            170 |
|       615 | Cryogonal  |     11 |   1480 |            170 |
|       616 | Shelmet    |      4 |     77 |             61 |
|       617 | Accelgor   |      8 |    253 |            173 |
|       618 | Stunfisk   |      7 |    110 |            165 |
|       619 | Mienfoo    |      9 |    200 |             70 |
|       620 | Mienshao   |     14 |    355 |            179 |
|       621 | Druddigon  |     16 |   1390 |            170 |
|       622 | Golett     |     10 |    920 |             61 |
|       623 | Golurk     |     28 |   3300 |            169 |
|       624 | Pawniard   |      5 |    102 |             68 |
|       625 | Bisharp    |     16 |    700 |            172 |
|       626 | Bouffalant |     16 |    946 |            172 |
|       627 | Rufflet    |      5 |    105 |             70 |
|       628 | Braviary   |     15 |    410 |            179 |
|       629 | Vullaby    |      5 |     90 |             74 |
|       630 | Mandibuzz  |     12 |    395 |            179 |
|       631 | Heatmor    |     14 |    580 |            169 |
|       632 | Durant     |      3 |    330 |            169 |
|       633 | Deino      |      8 |    173 |             60 |
|       634 | Zweilous   |     14 |    500 |            147 |
|       635 | Hydreigon  |     18 |   1600 |            270 |
|       636 | Larvesta   |     11 |    288 |             72 |
|       637 | Volcarona  |     16 |    460 |            248 |
|       638 | Cobalion   |     21 |   2500 |            261 |
|       639 | Terrakion  |     19 |   2600 |            261 |
|       640 | Virizion   |     20 |   2000 |            261 |
|       641 | Tornadus   |     15 |    630 |            261 |
|       642 | Thundurus  |     15 |    610 |            261 |
|       643 | Reshiram   |     32 |   3300 |            306 |
|       644 | Zekrom     |     29 |   3450 |            306 |
|       645 | Landorus   |     15 |    680 |            270 |
|       646 | Kyurem     |     30 |   3250 |            297 |
|       647 | Keldeo     |     14 |    485 |            261 |
|       648 | Meloetta   |      6 |     65 |            270 |
|       649 | Genesect   |     15 |    825 |            270 |
+-----------+------------+--------+--------+----------------+
649 rows in set (0.00 sec)

mysql> select * from Pokemon INNER JOIN Attributes using (PokeDexId) limit 10;
+-----------+------------+--------+--------+----------------+
| PokedexID | Name       | Height | Weight | BaseExperience |
+-----------+------------+--------+--------+----------------+
|         1 | Bulbasaur  |      7 |     69 |             64 |
|         2 | Ivysaur    |     10 |    130 |            141 |
|         3 | Venusaur   |     20 |   1000 |            208 |
|         4 | Charmander |      6 |     85 |             65 |
|         5 | Charmeleon |     11 |    190 |            142 |
|         6 | Charizard  |     17 |    905 |            209 |
|         7 | Squirtle   |      5 |     90 |             66 |
|         8 | Wartortle  |     10 |    225 |            143 |
|         9 | Blastoise  |     16 |    855 |            210 |
|        10 | Caterpie   |      3 |     29 |             53 |
+-----------+------------+--------+--------+----------------+
10 rows in set (0.00 sec)

mysql> select * from (Pokemon INNER JOIN Attributes using (PokeDexId)) JOIN Species using (PokeDexId) limit 10;
+-----------+------------+--------+--------+----------------+--------+-------------+
| PokedexID | Name       | Height | Weight | BaseExperience | TypeID | Genus       |
+-----------+------------+--------+--------+----------------+--------+-------------+
|         1 | Bulbasaur  |      7 |     69 |             64 |     12 | Seed        |
|         2 | Ivysaur    |     10 |    130 |            141 |     12 | Seed        |
|         3 | Venusaur   |     20 |   1000 |            208 |     12 | Seed        |
|         4 | Charmander |      6 |     85 |             65 |     10 | Lizard      |
|         5 | Charmeleon |     11 |    190 |            142 |     10 | Flame       |
|         6 | Charizard  |     17 |    905 |            209 |     10 | Flame       |
|         7 | Squirtle   |      5 |     90 |             66 |     11 | Tiny Turtle |
|         8 | Wartortle  |     10 |    225 |            143 |     11 | Turtle      |
|         9 | Blastoise  |     16 |    855 |            210 |     11 | Shellfish   |
|        10 | Caterpie   |      3 |     29 |             53 |      7 | Worm        |
+-----------+------------+--------+--------+----------------+--------+-------------+
10 rows in set (0.00 sec)

mysql> select * from Pokemon INNER JOIN Attributes using (PokeDexId) JOIN Species using (PokeDexId) limit 10;
+-----------+------------+--------+--------+----------------+--------+-------------+
| PokedexID | Name       | Height | Weight | BaseExperience | TypeID | Genus       |
+-----------+------------+--------+--------+----------------+--------+-------------+
|         1 | Bulbasaur  |      7 |     69 |             64 |     12 | Seed        |
|         2 | Ivysaur    |     10 |    130 |            141 |     12 | Seed        |
|         3 | Venusaur   |     20 |   1000 |            208 |     12 | Seed        |
|         4 | Charmander |      6 |     85 |             65 |     10 | Lizard      |
|         5 | Charmeleon |     11 |    190 |            142 |     10 | Flame       |
|         6 | Charizard  |     17 |    905 |            209 |     10 | Flame       |
|         7 | Squirtle   |      5 |     90 |             66 |     11 | Tiny Turtle |
|         8 | Wartortle  |     10 |    225 |            143 |     11 | Turtle      |
|         9 | Blastoise  |     16 |    855 |            210 |     11 | Shellfish   |
|        10 | Caterpie   |      3 |     29 |             53 |      7 | Worm        |
+-----------+------------+--------+--------+----------------+--------+-------------+
10 rows in set (0.01 sec)

mysql> show tables;
+-------------------+
| Tables_in_pokemon |
+-------------------+
| Attributes        |
| Evolution         |
| First10           |
| PokeData          |
| PokeStats         |
| Pokemon           |
| SpTypes           |
| Species           |
| Types             |
| fff               |
| foo               |
| imagine           |
| poke10            |
| poke10s           |
| poke5             |
| pokefoo           |
| tmp               |
| ttt               |
+-------------------+
18 rows in set (0.01 sec)

mysql> select * from poke10;
+------------+-----------+--------+--------+----------------+
| Name       | PokedexID | Height | Weight | BaseExperience |
+------------+-----------+--------+--------+----------------+
| Caterpie   |        10 |      3 |     29 |             53 |
| Blastoise  |         9 |     16 |    855 |            210 |
| Wartortle  |         8 |     10 |    225 |            143 |
| Squirtle   |         7 |      5 |     90 |             66 |
| Charizard  |         6 |     17 |    905 |            209 |
| Charmeleon |         5 |     11 |    190 |            142 |
| Charmander |         4 |      6 |     85 |             65 |
| Venusaur   |         3 |     20 |   1000 |            208 |
| Ivysaur    |         2 |     10 |    130 |            141 |
| Bulbasaur  |         1 |      7 |     69 |             64 |
+------------+-----------+--------+--------+----------------+
10 rows in set (0.00 sec)

mysql> select * from tmp;
+------------+-----------+--------+--------+----------------+-------------+--------+------+--------+
| Name       | PokedexID | Height | Weight | BaseExperience | Genus       | Type   | gen  | typeId |
+------------+-----------+--------+--------+----------------+-------------+--------+------+--------+
| Keldeo     |       647 |     14 |    485 |            261 | Colt        | water  |    4 |      1 |
| Alomomola  |       594 |     12 |    316 |            165 | Caring      | water  |    4 |      1 |
| Jellicent  |       593 |     22 |   1350 |            168 | Floating    | water  |    4 |      1 |
| Frillish   |       592 |     12 |    330 |             67 | Floating    | water  |    4 |      1 |
| Swanna     |       581 |     13 |    242 |            166 | White Bird  | water  |    4 |      1 |
| Ducklett   |       580 |      5 |     55 |             61 | Water Bird  | water  |    4 |      1 |
| Garbodor   |       569 |     19 |   1073 |            166 | Trash Heap  | poison |    4 |      2 |
| Trubbish   |       568 |      6 |    310 |             66 | Trash Bag   | poison |    4 |      2 |
| Carracosta |       565 |     12 |    810 |            173 | Prototurtle | water  |    4 |      1 |
| Tirtouga   |       564 |      7 |    165 |             71 | Prototurtle | water  |    4 |      1 |
| Basculin   |       550 |     10 |    180 |            161 | Hostile     | water  |    4 |      1 |
| Seismitoad |       537 |     15 |    620 |            225 | Vibration   | water  |    4 |      1 |
| Palpitoad  |       536 |      8 |    170 |            134 | Vibration   | water  |    4 |      1 |
| Tympole    |       535 |      5 |     45 |             59 | Tadpole     | water  |    4 |      1 |
| Simipour   |       516 |     10 |    290 |            174 | Geyser      | water  |    4 |      1 |
| Panpour    |       515 |      6 |    135 |             63 | Spray       | water  |    4 |      1 |
| Samurott   |       503 |     15 |    946 |            238 | Formidable  | water  |    4 |      1 |
| Dewott     |       502 |      8 |    245 |            145 | Discipline  | water  |    4 |      1 |
| Oshawott   |       501 |      5 |     59 |             28 | Sea Otter   | water  |    4 |      1 |
| Manaphy    |       490 |      3 |     14 |            215 | Seafaring   | water  |    4 |      1 |
| Phione     |       489 |      4 |     31 |            165 | Sea Drifter | water  |    4 |      1 |
| Palkia     |       484 |     42 |   3360 |            220 | Spatial     | water  |    4 |      1 |
| Mantyke    |       458 |     10 |    650 |            108 | Kite        | water  |    4 |      1 |
| Lumineon   |       457 |     12 |    240 |            156 | Neon        | water  |    4 |      1 |
| Finneon    |       456 |      4 |     70 |             90 | Wing Fish   | water  |    4 |      1 |
| Toxicroak  |       454 |     13 |    444 |            181 | Toxic Mouth | poison |    4 |      2 |
| Croagunk   |       453 |      7 |    230 |             83 | Toxic Mouth | poison |    4 |      2 |
| Drapion    |       452 |     13 |    615 |            204 | Ogre Scorp  | poison |    4 |      2 |
| Skorupi    |       451 |      8 |    120 |            114 | Scorpion    | poison |    4 |      2 |
| Skuntank   |       435 |     10 |    380 |            209 | Skunk       | poison |    3 |      2 |
| Stunky     |       434 |      4 |    192 |             79 | Skunk       | poison |    3 |      2 |
| Gastrodon  |       423 |      9 |    299 |            176 | Sea Slug    | water  |    3 |      1 |
| Shellos    |       422 |      3 |     63 |             73 | Sea Slug    | water  |    3 |      1 |
| Floatzel   |       419 |     11 |    335 |            178 | Sea Weasel  | water  |    3 |      1 |
| Buizel     |       418 |      7 |    295 |             75 | Sea Weasel  | water  |    3 |      1 |
| Empoleon   |       395 |     17 |    845 |            210 | Emperor     | water  |    3 |      1 |
| Prinplup   |       394 |      8 |    230 |            143 | Penguin     | water  |    3 |      1 |
| Piplup     |       393 |      4 |     52 |             66 | Penguin     | water  |    3 |      1 |
| Kyogre     |       382 |     45 |   3520 |            218 | Sea Basin   | water  |    3 |      1 |
| Luvdisc    |       370 |      6 |     87 |            110 | Rendezvous  | water  |    3 |      1 |
| Relicanth  |       369 |     10 |    234 |            198 | Longevity   | water  |    3 |      1 |
| Gorebyss   |       368 |     18 |    226 |            178 | South Sea   | water  |    3 |      1 |
| Huntail    |       367 |     17 |    270 |            178 | Deep Sea    | water  |    3 |      1 |
| Clamperl   |       366 |      4 |    525 |            142 | Bivalve     | water  |    3 |      1 |
| Milotic    |       350 |     62 |   1620 |            213 | Tender      | water  |    3 |      1 |
| Feebas     |       349 |      6 |     74 |             61 | Fish        | water  |    3 |      1 |
| Crawdaunt  |       342 |     11 |    328 |            161 | Rogue       | water  |    3 |      1 |
| Corphish   |       341 |      6 |    115 |            111 | Ruffian     | water  |    3 |      1 |
| Whiscash   |       340 |      9 |    236 |            158 | Whiskers    | water  |    3 |      1 |
| Barboach   |       339 |      4 |     19 |             92 | Whiskers    | water  |    3 |      1 |
| Seviper    |       336 |     27 |    525 |            165 | Fang Snake  | poison |    3 |      2 |
| Wailord    |       321 |    145 |   3980 |            206 | Float Whale | water  |    3 |      1 |
| Wailmer    |       320 |     20 |   1300 |            137 | Ball Whale  | water  |    3 |      1 |
| Sharpedo   |       319 |     18 |    888 |            175 | Brutal      | water  |    3 |      1 |
| Carvanha   |       318 |      8 |    208 |             88 | Savage      | water  |    3 |      1 |
| Swalot     |       317 |     17 |    800 |            168 | Poison Bag  | poison |    3 |      2 |
| Gulpin     |       316 |      4 |    103 |             75 | Stomach     | poison |    3 |      2 |
| Pelipper   |       279 |     12 |    280 |            164 | Water Bird  | water  |    2 |      1 |
| Wingull    |       278 |      6 |     95 |             64 | Seagull     | water  |    2 |      1 |
| Ludicolo   |       272 |     15 |    550 |            181 | Carefree    | water  |    2 |      1 |
| Lombre     |       271 |     12 |    325 |            141 | Jolly       | water  |    2 |      1 |
| Lotad      |       270 |      5 |     26 |             74 | Water Weed  | water  |    2 |      1 |
| Swampert   |       260 |     15 |    819 |            210 | Mud Fish    | water  |    2 |      1 |
| Marshtomp  |       259 |      7 |    280 |            143 | Mud Fish    | water  |    2 |      1 |
| Mudkip     |       258 |      4 |     76 |             65 | Mud Fish    | water  |    2 |      1 |
| Suicune    |       245 |     20 |   1870 |            215 | Aurora      | water  |    2 |      1 |
| Kingdra    |       230 |     18 |   1520 |            207 | Dragon      | water  |    2 |      1 |
| Mantine    |       226 |     21 |   2200 |            168 | Kite        | water  |    2 |      1 |
| Octillery  |       224 |      9 |    285 |            164 | Jet         | water  |    2 |      1 |
| Remoraid   |       223 |      6 |    120 |             78 | Jet         | water  |    2 |      1 |
| Corsola    |       222 |      6 |     50 |            113 | Coral       | water  |    2 |      1 |
| Qwilfish   |       211 |      5 |     39 |            100 | Balloon     | water  |    2 |      1 |
| Slowking   |       199 |     20 |    795 |            164 | Royal       | water  |    2 |      1 |
| Quagsire   |       195 |     14 |    750 |            137 | Water Fish  | water  |    2 |      1 |
| Wooper     |       194 |      4 |     85 |             52 | Water Fish  | water  |    2 |      1 |
| Politoed   |       186 |     11 |    339 |            185 | Frog        | water  |    2 |      1 |
| Azumarill  |       184 |      8 |    285 |            153 | Aqua Rabbit | water  |    2 |      1 |
| Marill     |       183 |      4 |     85 |             58 | Aqua Mouse  | water  |    2 |      1 |
| Lanturn    |       171 |     12 |    225 |            156 | Light       | water  |    2 |      1 |
| Chinchou   |       170 |      5 |    120 |             90 | Angler      | water  |    2 |      1 |
| Crobat     |       169 |     18 |    750 |            204 | Bat         | poison |    2 |      2 |
| Feraligatr |       160 |     23 |    888 |            210 | Big Jaw     | water  |    2 |      1 |
| Croconaw   |       159 |     11 |    250 |            143 | Big Jaw     | water  |    2 |      1 |
| Totodile   |       158 |      6 |     95 |             66 | Big Jaw     | water  |    2 |      1 |
| Vaporeon   |       134 |     10 |    290 |            196 | Bubble Jet  | water  |    1 |      1 |
| Lapras     |       131 |     25 |   2200 |            219 | Transport   | water  |    1 |      1 |
| Gyarados   |       130 |     65 |   2350 |            214 | Atrocious   | water  |    1 |      1 |
| Magikarp   |       129 |      9 |    100 |             20 | Fish        | water  |    1 |      1 |
| Starmie    |       121 |     11 |    800 |            207 | Mysterious  | water  |    1 |      1 |
| Staryu     |       120 |      8 |    345 |            106 | Star Shape  | water  |    1 |      1 |
| Seaking    |       119 |     13 |    390 |            170 | Goldfish    | water  |    1 |      1 |
| Goldeen    |       118 |      6 |    150 |            111 | Goldfish    | water  |    1 |      1 |
| Seadra     |       117 |     12 |    250 |            155 | Dragon      | water  |    1 |      1 |
| Horsea     |       116 |      4 |     80 |             83 | Dragon      | water  |    1 |      1 |
| Weezing    |       110 |     12 |     95 |            173 | Poison Gas  | poison |    1 |      2 |
| Koffing    |       109 |      6 |     10 |            114 | Poison Gas  | poison |    1 |      2 |
| Kingler    |        99 |     13 |    600 |            206 | Pincer      | water  |    1 |      1 |
| Krabby     |        98 |      4 |     65 |            115 | River Crab  | water  |    1 |      1 |
| Cloyster   |        91 |     15 |   1325 |            203 | Bivalve     | water  |    1 |      1 |
| Shellder   |        90 |      3 |     40 |             97 | Bivalve     | water  |    1 |      1 |
| Muk        |        89 |     12 |    300 |            157 | Sludge      | poison |    1 |      2 |
| Grimer     |        88 |      9 |    300 |             90 | Sludge      | poison |    1 |      2 |
| Dewgong    |        87 |     17 |   1200 |            176 | Sea Lion    | water  |    1 |      1 |
| Seel       |        86 |     11 |    900 |            100 | Sea Lion    | water  |    1 |      1 |
| Slowbro    |        80 |     16 |    785 |            164 | Hermit Crab | water  |    1 |      1 |
| Slowpoke   |        79 |     12 |    360 |             99 | Dopey       | water  |    1 |      1 |
| Tentacruel |        73 |     16 |    550 |            205 | Jellyfish   | water  |    1 |      1 |
| Tentacool  |        72 |      9 |    455 |            105 | Jellyfish   | water  |    1 |      1 |
| Poliwrath  |        62 |     13 |    540 |            185 | Tadpole     | water  |    1 |      1 |
| Poliwhirl  |        61 |     10 |    200 |            131 | Tadpole     | water  |    1 |      1 |
| Poliwag    |        60 |      6 |    124 |             77 | Tadpole     | water  |    1 |      1 |
| Golduck    |        55 |     17 |    766 |            174 | Duck        | water  |    1 |      1 |
| Psyduck    |        54 |      8 |    196 |             80 | Duck        | water  |    1 |      1 |
| Golbat     |        42 |     16 |    550 |            171 | Bat         | poison |    1 |      2 |
| Zubat      |        41 |      8 |     75 |             54 | Bat         | poison |    1 |      2 |
| Nidoking   |        34 |     14 |    620 |            195 | Drill       | poison |    1 |      2 |
| Nidorino   |        33 |      9 |    195 |            118 | Poison Pin  | poison |    1 |      2 |
| Nidoran♂ |        32 |      5 |     90 |             60 | Poison Pin  | poison |    1 |      2 |
| Nidoqueen  |        31 |     13 |    600 |            194 | Drill       | poison |    1 |      2 |
| Nidorina   |        30 |      8 |    200 |            117 | Poison Pin  | poison |    1 |      2 |
| Nidoran♀ |        29 |      4 |     70 |             59 | Poison Pin  | poison |    1 |      2 |
| Arbok      |        24 |     35 |    650 |            147 | Cobra       | poison |    1 |      2 |
| Ekans      |        23 |     20 |     69 |             62 | Snake       | poison |    1 |      2 |
| Blastoise  |         9 |     16 |    855 |            210 | Shellfish   | water  |    1 |      1 |
| Wartortle  |         8 |     10 |    225 |            143 | Turtle      | water  |    1 |      1 |
| Squirtle   |         7 |      5 |     90 |             66 | Tiny Turtle | water  |    1 |      1 |
+------------+-----------+--------+--------+----------------+-------------+--------+------+--------+
126 rows in set (0.00 sec)

mysql> show tables;
+-------------------+
| Tables_in_pokemon |
+-------------------+
| Attributes        |
| Evolution         |
| First10           |
| PokeData          |
| PokeStats         |
| Pokemon           |
| SpTypes           |
| Species           |
| Types             |
| fff               |
| foo               |
| imagine           |
| poke10            |
| poke10s           |
| poke5             |
| pokefoo           |
| tmp               |
| ttt               |
+-------------------+
18 rows in set (0.00 sec)

mysql> select * from First10;
+------------+-----------+--------+--------+----------------+--------+
| Name       | PokedexID | Height | Weight | BaseExperience | typeId |
+------------+-----------+--------+--------+----------------+--------+
| Caterpie   |        10 |      3 |     29 |             53 |      7 |
| Charmander |         4 |      6 |     85 |             65 |     10 |
| Charmeleon |         5 |     11 |    190 |            142 |     10 |
| Charizard  |         6 |     17 |    905 |            209 |     10 |
| Squirtle   |         7 |      5 |     90 |             66 |     11 |
| Wartortle  |         8 |     10 |    225 |            143 |     11 |
| Blastoise  |         9 |     16 |    855 |            210 |     11 |
| Bulbasaur  |         1 |      7 |     69 |             64 |     12 |
| Ivysaur    |         2 |     10 |    130 |            141 |     12 |
| Venusaur   |         3 |     20 |   1000 |            208 |     12 |
+------------+-----------+--------+--------+----------------+--------+
10 rows in set (0.00 sec)

mysql> select * from Types;
+--------+----------+------------+-------------+
| TypeID | Type     | Generation | DamageClass |
+--------+----------+------------+-------------+
|      1 | normal   |          1 |           2 |
|      2 | fighting |          1 |           2 |
|      3 | flying   |          1 |           2 |
|      4 | poison   |          1 |           2 |
|      5 | ground   |          1 |           2 |
|      6 | rock     |          1 |           2 |
|      7 | bug      |          1 |           2 |
|      8 | ghost    |          1 |           2 |
|      9 | steel    |          2 |           2 |
|     10 | fire     |          1 |           3 |
|     11 | water    |          1 |           3 |
|     12 | grass    |          1 |           3 |
|     13 | electric |          1 |           3 |
|     14 | psychic  |          1 |           3 |
|     15 | ice      |          1 |           3 |
|     16 | dragon   |          1 |           3 |
|     17 | dark     |          2 |           3 |
|  10001 | unknown  |          2 |        NULL |
|  10002 | shadow   |          3 |        NULL |
+--------+----------+------------+-------------+
19 rows in set (0.00 sec)

mysql> describe First10
    -> ;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| Name           | varchar(20) | YES  |     | NULL    |       |
| PokedexID      | int(11)     | NO   |     | 0       |       |
| Height         | int(11)     | YES  |     | NULL    |       |
| Weight         | int(11)     | YES  |     | NULL    |       |
| BaseExperience | int(11)     | YES  |     | NULL    |       |
| typeId         | int(11)     | YES  |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> select f.name, f.PokedexId, f.typeId, t.*
    -> from First10 f JOIN Types t using (typeid);
+------------+-----------+--------+--------+-------+------------+-------------+
| name       | PokedexId | typeId | TypeID | Type  | Generation | DamageClass |
+------------+-----------+--------+--------+-------+------------+-------------+
| Caterpie   |        10 |      7 |      7 | bug   |          1 |           2 |
| Charmander |         4 |     10 |     10 | fire  |          1 |           3 |
| Charmeleon |         5 |     10 |     10 | fire  |          1 |           3 |
| Charizard  |         6 |     10 |     10 | fire  |          1 |           3 |
| Squirtle   |         7 |     11 |     11 | water |          1 |           3 |
| Wartortle  |         8 |     11 |     11 | water |          1 |           3 |
| Blastoise  |         9 |     11 |     11 | water |          1 |           3 |
| Bulbasaur  |         1 |     12 |     12 | grass |          1 |           3 |
| Ivysaur    |         2 |     12 |     12 | grass |          1 |           3 |
| Venusaur   |         3 |     12 |     12 | grass |          1 |           3 |
+------------+-----------+--------+--------+-------+------------+-------------+
10 rows in set (0.00 sec)

mysql> select f.name,  f.typeId, t.* from First10 f JOIN Types t using (typeid);
+------------+--------+--------+-------+------------+-------------+
| name       | typeId | TypeID | Type  | Generation | DamageClass |
+------------+--------+--------+-------+------------+-------------+
| Caterpie   |      7 |      7 | bug   |          1 |           2 |
| Charmander |     10 |     10 | fire  |          1 |           3 |
| Charmeleon |     10 |     10 | fire  |          1 |           3 |
| Charizard  |     10 |     10 | fire  |          1 |           3 |
| Squirtle   |     11 |     11 | water |          1 |           3 |
| Wartortle  |     11 |     11 | water |          1 |           3 |
| Blastoise  |     11 |     11 | water |          1 |           3 |
| Bulbasaur  |     12 |     12 | grass |          1 |           3 |
| Ivysaur    |     12 |     12 | grass |          1 |           3 |
| Venusaur   |     12 |     12 | grass |          1 |           3 |
+------------+--------+--------+-------+------------+-------------+
10 rows in set (0.00 sec)

mysql> select f.name, f.pokedexid,  f.typeId, t.type from First10 f JOIN Types t using (typeid);
+------------+-----------+--------+-------+
| name       | pokedexid | typeId | type  |
+------------+-----------+--------+-------+
| Caterpie   |        10 |      7 | bug   |
| Charmander |         4 |     10 | fire  |
| Charmeleon |         5 |     10 | fire  |
| Charizard  |         6 |     10 | fire  |
| Squirtle   |         7 |     11 | water |
| Wartortle  |         8 |     11 | water |
| Blastoise  |         9 |     11 | water |
| Bulbasaur  |         1 |     12 | grass |
| Ivysaur    |         2 |     12 | grass |
| Venusaur   |         3 |     12 | grass |
+------------+-----------+--------+-------+
10 rows in set (0.00 sec)

mysql> select f.name, f.pokedexid,  f.typeId, t.type from First10 f RIGHT JOIN Types t using (typeid);
+------------+-----------+--------+----------+
| name       | pokedexid | typeId | type     |
+------------+-----------+--------+----------+
| NULL       |      NULL |   NULL | normal   |
| NULL       |      NULL |   NULL | fighting |
| NULL       |      NULL |   NULL | flying   |
| NULL       |      NULL |   NULL | poison   |
| NULL       |      NULL |   NULL | ground   |
| NULL       |      NULL |   NULL | rock     |
| Caterpie   |        10 |      7 | bug      |
| NULL       |      NULL |   NULL | ghost    |
| NULL       |      NULL |   NULL | steel    |
| Charmander |         4 |     10 | fire     |
| Charmeleon |         5 |     10 | fire     |
| Charizard  |         6 |     10 | fire     |
| Squirtle   |         7 |     11 | water    |
| Wartortle  |         8 |     11 | water    |
| Blastoise  |         9 |     11 | water    |
| Bulbasaur  |         1 |     12 | grass    |
| Ivysaur    |         2 |     12 | grass    |
| Venusaur   |         3 |     12 | grass    |
| NULL       |      NULL |   NULL | electric |
| NULL       |      NULL |   NULL | psychic  |
| NULL       |      NULL |   NULL | ice      |
| NULL       |      NULL |   NULL | dragon   |
| NULL       |      NULL |   NULL | dark     |
| NULL       |      NULL |   NULL | unknown  |
| NULL       |      NULL |   NULL | shadow   |
+------------+-----------+--------+----------+
25 rows in set (0.00 sec)

mysql> select f.name, f.pokedexid,  f.typeId, t.type from First10 f FULL JOIN Types t using (typeid);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FULL JOIN Types t using (typeid)' at line 1
mysql> select f.name, f.pokedexid,  f.typeId, t.type from First10 f RIGHT JOIN Types t using (typeid);
+------------+-----------+--------+----------+
| name       | pokedexid | typeId | type     |
+------------+-----------+--------+----------+
| NULL       |      NULL |   NULL | normal   |
| NULL       |      NULL |   NULL | fighting |
| NULL       |      NULL |   NULL | flying   |
| NULL       |      NULL |   NULL | poison   |
| NULL       |      NULL |   NULL | ground   |
| NULL       |      NULL |   NULL | rock     |
| Caterpie   |        10 |      7 | bug      |
| NULL       |      NULL |   NULL | ghost    |
| NULL       |      NULL |   NULL | steel    |
| Charmander |         4 |     10 | fire     |
| Charmeleon |         5 |     10 | fire     |
| Charizard  |         6 |     10 | fire     |
| Squirtle   |         7 |     11 | water    |
| Wartortle  |         8 |     11 | water    |
| Blastoise  |         9 |     11 | water    |
| Bulbasaur  |         1 |     12 | grass    |
| Ivysaur    |         2 |     12 | grass    |
| Venusaur   |         3 |     12 | grass    |
| NULL       |      NULL |   NULL | electric |
| NULL       |      NULL |   NULL | psychic  |
| NULL       |      NULL |   NULL | ice      |
| NULL       |      NULL |   NULL | dragon   |
| NULL       |      NULL |   NULL | dark     |
| NULL       |      NULL |   NULL | unknown  |
| NULL       |      NULL |   NULL | shadow   |
+------------+-----------+--------+----------+
25 rows in set (0.00 sec)

mysql> 
mysql> select f.name, f.pokedexid,  f.typeId, t.type from First10 f LEFT JOIN Types t using (typeid);
+------------+-----------+--------+-------+
| name       | pokedexid | typeId | type  |
+------------+-----------+--------+-------+
| Caterpie   |        10 |      7 | bug   |
| Charmander |         4 |     10 | fire  |
| Charmeleon |         5 |     10 | fire  |
| Charizard  |         6 |     10 | fire  |
| Squirtle   |         7 |     11 | water |
| Wartortle  |         8 |     11 | water |
| Blastoise  |         9 |     11 | water |
| Bulbasaur  |         1 |     12 | grass |
| Ivysaur    |         2 |     12 | grass |
| Venusaur   |         3 |     12 | grass |
+------------+-----------+--------+-------+
10 rows in set (0.00 sec)

mysql>