mysql> show tables;
+-------------------+
| Tables_in_pokemon |
+-------------------+
| Attributes        |
| Evolution         |
| PokeStats         |
| Pokemon           |
| Species           |
| Types             |
+-------------------+
6 rows in set (0.00 sec)

mysql> describe Attributes;
+----------------+---------+------+-----+---------+-------+
| Field          | Type    | Null | Key | Default | Extra |
+----------------+---------+------+-----+---------+-------+
| PokedexID      | int(11) | NO   | PRI | 0       |       |
| Height         | int(11) | YES  |     | NULL    |       |
| Weight         | int(11) | YES  |     | NULL    |       |
| BaseExperience | int(11) | YES  |     | NULL    |       |
+----------------+---------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> describe PokeStats;
+----------------+-------------+------+-----+---------+-------+
| 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    |       |
+----------------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)

mysql> describe Species;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| PokedexID | int(11)     | NO   | PRI | 0       |       |
| TypeID    | int(11)     | YES  | MUL | NULL    |       |
| Genus     | varchar(20) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> select 
    -> *
    -> from Pokemon 
    -> where name = 'Pikachu';
+-----------+---------+
| PokedexID | Name    |
+-----------+---------+
|        25 | Pikachu |
+-----------+---------+
1 row in set (0.00 sec)

mysql> select  * from PokeStats  where name = 'Pikachu';
+---------+-----------+--------+--------+----------------+
| Name    | PokedexID | Height | Weight | BaseExperience |
+---------+-----------+--------+--------+----------------+
| Pikachu |        25 |      4 |     60 |             82 |
+---------+-----------+--------+--------+----------------+
1 row in set (0.00 sec)

mysql> select Name
    -> from PokeStats
    -> ;
+------------+
| Name       |
+------------+
| Genesect   |
| Meloetta   |
| Keldeo     |
| Kyurem     |
| Landorus   |
| Zekrom     |
| Reshiram   |
| Thundurus  |
| Tornadus   |
| Virizion   |
| Terrakion  |
| Cobalion   |
| Volcarona  |
| Larvesta   |
| Hydreigon  |
| Zweilous   |
| Deino      |
| Durant     |
| Heatmor    |
| Mandibuzz  |
| Vullaby    |
| Braviary   |
| Rufflet    |
| Bouffalant |
| Bisharp    |
| Pawniard   |
| Golurk     |
| Golett     |
| Druddigon  |
| Mienshao   |
| Mienfoo    |
| Stunfisk   |
| Accelgor   |
| Shelmet    |
| Cryogonal  |
| Beartic    |
| Cubchoo    |
| Haxorus    |
| Fraxure    |
| Axew       |
| Chandelure |
| Lampent    |
| Litwick    |
| Beheeyem   |
| Elgyem     |
| Eelektross |
| Eelektrik  |
| Tynamo     |
| Klinklang  |
| Klang      |
| Klink      |
| Ferrothorn |
| Ferroseed  |
| Galvantula |
| Joltik     |
| Alomomola  |
| Jellicent  |
| Frillish   |
| Amoonguss  |
| Foongus    |
| Escavalier |
| Karrablast |
| Emolga     |
| Sawsbuck   |
| Deerling   |
| Vanilluxe  |
| Vanillish  |
| Vanillite  |
| Swanna     |
| Ducklett   |
| Reuniclus  |
| Duosion    |
| Solosis    |
| Gothitelle |
| Gothorita  |
| Gothita    |
| Cinccino   |
| Minccino   |
| Zoroark    |
| Zorua      |
| Garbodor   |
| Trubbish   |
| Archeops   |
| Archen     |
| Carracosta |
| Tirtouga   |
| Cofagrigus |
| Yamask     |
| Sigilyph   |
| Scrafty    |
| Scraggy    |
| Crustle    |
| Dwebble    |
| Maractus   |
| Darmanitan |
| Darumaka   |
| Krookodile |
| Krokorok   |
| Sandile    |
| Basculin   |
| Lilligant  |
| Petilil    |
| Whimsicott |
| Cottonee   |
| Scolipede  |
| Whirlipede |
| Venipede   |
| Leavanny   |
| Swadloon   |
| Sewaddle   |
| Sawk       |
| Throh      |
| Seismitoad |
| Palpitoad  |
| Tympole    |
| Conkeldurr |
| Gurdurr    |
| Timburr    |
| Audino     |
| Excadrill  |
| Drilbur    |
| Swoobat    |
| Woobat     |
| Gigalith   |
| Boldore    |
| Roggenrola |
| Zebstrika  |
| Blitzle    |
| Unfezant   |
| Tranquill  |
| Pidove     |
| Musharna   |
| Munna      |
| Simipour   |
| Panpour    |
| Simisear   |
| Pansear    |
| Simisage   |
| Pansage    |
| Liepard    |
| Purrloin   |
| Stoutland  |
| Herdier    |
| Lillipup   |
| Watchog    |
| Patrat     |
| Samurott   |
| Dewott     |
| Oshawott   |
| Emboar     |
| Pignite    |
| Tepig      |
| Serperior  |
| Servine    |
| Snivy      |
| Victini    |
| Arceus     |
| Shaymin    |
| Darkrai    |
| Manaphy    |
| Phione     |
| Cresselia  |
| Giratina   |
| Regigigas  |
| Heatran    |
| Palkia     |
| Dialga     |
| Azelf      |
| Mesprit    |
| Uxie       |
| Rotom      |
| Froslass   |
| Dusknoir   |
| Probopass  |
| Gallade    |
| Porygon-Z  |
| Mamoswine  |
| Gliscor    |
| Glaceon    |
| Leafeon    |
| Yanmega    |
| Togekiss   |
| Magmortar  |
| Electivire |
| Tangrowth  |
| Rhyperior  |
| Lickilicky |
| Magnezone  |
| Weavile    |
| Abomasnow  |
| Snover     |
| Mantyke    |
| Lumineon   |
| Finneon    |
| Carnivine  |
| Toxicroak  |
| Croagunk   |
| Drapion    |
| Skorupi    |
| Hippowdon  |
| Hippopotas |
| Lucario    |
| Riolu      |
| Munchlax   |
| Garchomp   |
| Gabite     |
| Gible      |
| Spiritomb  |
| Chatot     |
| Happiny    |
| Mime Jr.   |
| Bonsly     |
| Bronzong   |
| Bronzor    |
| Skuntank   |
| Stunky     |
| Chingling  |
| Purugly    |
| Glameow    |
| Honchkrow  |
| Mismagius  |
| Lopunny    |
| Buneary    |
| Drifblim   |
| Drifloon   |
| Ambipom    |
| Gastrodon  |
| Shellos    |
| Cherrim    |
| Cherubi    |
| Floatzel   |
| Buizel     |
| Pachirisu  |
| Vespiquen  |
| Combee     |
| Mothim     |
| Wormadam   |
| Burmy      |
| Bastiodon  |
| Shieldon   |
| Rampardos  |
| Cranidos   |
| Roserade   |
| Budew      |
| Luxray     |
| Luxio      |
| Shinx      |
| Kricketune |
| Kricketot  |
| Bibarel    |
| Bidoof     |
| Staraptor  |
| Staravia   |
| Starly     |
| Empoleon   |
| Prinplup   |
| Piplup     |
| Infernape  |
| Monferno   |
| Chimchar   |
| Torterra   |
| Grotle     |
| Turtwig    |
| Deoxys     |
| Jirachi    |
| Rayquaza   |
| Groudon    |
| Kyogre     |
| Latios     |
| Latias     |
| Registeel  |
| Regice     |
| Regirock   |
| Metagross  |
| Metang     |
| Beldum     |
| Salamence  |
| Shelgon    |
| Bagon      |
| Luvdisc    |
| Relicanth  |
| Gorebyss   |
| Huntail    |
| Clamperl   |
| Walrein    |
| Sealeo     |
| Spheal     |
| Glalie     |
| Snorunt    |
| Wynaut     |
| Absol      |
| Chimecho   |
| Tropius    |
| Dusclops   |
| Duskull    |
| Banette    |
| Shuppet    |
| Kecleon    |
| Castform   |
| Milotic    |
| Feebas     |
| Armaldo    |
| Anorith    |
| Cradily    |
| Lileep     |
| Claydol    |
| Baltoy     |
| Crawdaunt  |
| Corphish   |
| Whiscash   |
| Barboach   |
| Solrock    |
| Lunatone   |
| Seviper    |
| Zangoose   |
| Altaria    |
| Swablu     |
| Cacturne   |
| Cacnea     |
| Flygon     |
| Vibrava    |
| Trapinch   |
| Spinda     |
| Grumpig    |
| Spoink     |
| Torkoal    |
| Camerupt   |
| Numel      |
| Wailord    |
| Wailmer    |
| Sharpedo   |
| Carvanha   |
| Swalot     |
| Gulpin     |
| Roselia    |
| Illumise   |
| Volbeat    |
| Minun      |
| Plusle     |
| Manectric  |
| Electrike  |
| Medicham   |
| Meditite   |
| Aggron     |
| Lairon     |
| Aron       |
| Mawile     |
| Sableye    |
| Delcatty   |
| Skitty     |
| Nosepass   |
| Azurill    |
| Hariyama   |
| Makuhita   |
| Exploud    |
| Loudred    |
| Whismur    |
| Shedinja   |
| Ninjask    |
| Nincada    |
| Slaking    |
| Vigoroth   |
| Slakoth    |
| Breloom    |
| Shroomish  |
| Masquerain |
| Surskit    |
| Gardevoir  |
| Kirlia     |
| Ralts      |
| Pelipper   |
| Wingull    |
| Swellow    |
| Taillow    |
| Shiftry    |
| Nuzleaf    |
| Seedot     |
| Ludicolo   |
| Lombre     |
| Lotad      |
| Dustox     |
| Cascoon    |
| Beautifly  |
| Silcoon    |
| Wurmple    |
| Linoone    |
| Zigzagoon  |
| Mightyena  |
| Poochyena  |
| Swampert   |
| Marshtomp  |
| Mudkip     |
| Blaziken   |
| Combusken  |
| Torchic    |
| Sceptile   |
| Grovyle    |
| Treecko    |
| Celebi     |
| Ho-Oh      |
| Lugia      |
| Tyranitar  |
| Pupitar    |
| Larvitar   |
| Suicune    |
| Entei      |
| Raikou     |
| Blissey    |
| Miltank    |
| Magby      |
| Elekid     |
| Smoochum   |
| Hitmontop  |
| Tyrogue    |
| Smeargle   |
| Stantler   |
| Porygon2   |
| Donphan    |
| Phanpy     |
| Kingdra    |
| Houndoom   |
| Houndour   |
| Skarmory   |
| Mantine    |
| Delibird   |
| Octillery  |
| Remoraid   |
| Corsola    |
| Piloswine  |
| Swinub     |
| Magcargo   |
| Slugma     |
| Ursaring   |
| Teddiursa  |
| Sneasel    |
| Heracross  |
| Shuckle    |
| Scizor     |
| Qwilfish   |
| Granbull   |
| Snubbull   |
| Steelix    |
| Gligar     |
| Dunsparce  |
| Forretress |
| Pineco     |
| Girafarig  |
| Wobbuffet  |
| Unown      |
| Misdreavus |
| Slowking   |
| Murkrow    |
| Umbreon    |
| Espeon     |
| Quagsire   |
| Wooper     |
| Yanma      |
| Sunflora   |
| Sunkern    |
| Aipom      |
| Jumpluff   |
| Skiploom   |
| Hoppip     |
| Politoed   |
| Sudowoodo  |
| Azumarill  |
| Marill     |
| Bellossom  |
| Ampharos   |
| Flaaffy    |
| Mareep     |
| Xatu       |
| Natu       |
| Togetic    |
| Togepi     |
| Igglybuff  |
| Cleffa     |
| Pichu      |
| Lanturn    |
| Chinchou   |
| Crobat     |
| Ariados    |
| Spinarak   |
| Ledian     |
| Ledyba     |
| Noctowl    |
| Hoothoot   |
| Furret     |
| Sentret    |
| Feraligatr |
| Croconaw   |
| Totodile   |
| Typhlosion |
| Quilava    |
| Cyndaquil  |
| Meganium   |
| Bayleef    |
| Chikorita  |
| Mew        |
| Mewtwo     |
| Dragonite  |
| Dragonair  |
| Dratini    |
| Moltres    |
| Zapdos     |
| Articuno   |
| Snorlax    |
| Aerodactyl |
| Kabutops   |
| Kabuto     |
| Omastar    |
| Omanyte    |
| Porygon    |
| Flareon    |
| Jolteon    |
| Vaporeon   |
| Eevee      |
| Ditto      |
| Lapras     |
| Gyarados   |
| Magikarp   |
| Tauros     |
| Pinsir     |
| Magmar     |
| Electabuzz |
| Jynx       |
| Scyther    |
| Mr. Mime   |
| Starmie    |
| Staryu     |
| Seaking    |
| Goldeen    |
| Seadra     |
| Horsea     |
| Kangaskhan |
| Tangela    |
| Chansey    |
| Rhydon     |
| Rhyhorn    |
| Weezing    |
| Koffing    |
| Lickitung  |
| Hitmonchan |
| Hitmonlee  |
| Marowak    |
| Cubone     |
| Exeggutor  |
| Exeggcute  |
| Electrode  |
| Voltorb    |
| Kingler    |
| Krabby     |
| Hypno      |
| Drowzee    |
| Onix       |
| Gengar     |
| Haunter    |
| Gastly     |
| Cloyster   |
| Shellder   |
| Muk        |
| Grimer     |
| Dewgong    |
| Seel       |
| Dodrio     |
| Doduo      |
| Farfetch'd |
| Magneton   |
| Magnemite  |
| Slowbro    |
| Slowpoke   |
| Rapidash   |
| Ponyta     |
| Golem      |
| Graveler   |
| Geodude    |
| Tentacruel |
| Tentacool  |
| Victreebel |
| Weepinbell |
| Bellsprout |
| Machamp    |
| Machoke    |
| Machop     |
| Alakazam   |
| Kadabra    |
| Abra       |
| Poliwrath  |
| Poliwhirl  |
| Poliwag    |
| Arcanine   |
| Growlithe  |
| Primeape   |
| Mankey     |
| Golduck    |
| Psyduck    |
| Persian    |
| Meowth     |
| Dugtrio    |
| Diglett    |
| Venomoth   |
| Venonat    |
| Parasect   |
| Paras      |
| Vileplume  |
| Gloom      |
| Oddish     |
| Golbat     |
| Zubat      |
| Wigglytuff |
| Jigglypuff |
| Ninetales  |
| Vulpix     |
| Clefable   |
| Clefairy   |
| Nidoking   |
| Nidorino   |
| Nidoran♂ |
| Nidoqueen  |
| Nidorina   |
| Nidoran♀ |
| Sandslash  |
| Sandshrew  |
| Raichu     |
| Pikachu    |
| Arbok      |
| Ekans      |
| Fearow     |
| Spearow    |
| Raticate   |
| Rattata    |
| Pidgeot    |
| Pidgeotto  |
| Pidgey     |
| Beedrill   |
| Kakuna     |
| Weedle     |
| Butterfree |
| Metapod    |
| Caterpie   |
| Blastoise  |
| Wartortle  |
| Squirtle   |
| Charizard  |
| Charmeleon |
| Charmander |
| Venusaur   |
| Ivysaur    |
| Bulbasaur  |
+------------+
649 rows in set (0.00 sec)

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

mysql> CREATE table poke10 as (select * from PokeStats where PokedexId <=10);
Query OK, 10 rows affected (0.04 sec)
Records: 10  Duplicates: 0  Warnings: 0

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.01 sec)

mysql> select *
    -> from poke10 a, poke10b;
ERROR 1146 (42S02): Table 'pokemon.poke10b' doesn't exist
mysql> select * from poke10 a, poke10 b;
+------------+-----------+--------+--------+----------------+------------+-----------+--------+--------+----------------+
| Name       | PokedexID | Height | Weight | BaseExperience | Name       | PokedexID | Height | Weight | BaseExperience |
+------------+-----------+--------+--------+----------------+------------+-----------+--------+--------+----------------+
| Caterpie   |        10 |      3 |     29 |             53 | Caterpie   |        10 |      3 |     29 |             53 |
| Blastoise  |         9 |     16 |    855 |            210 | Caterpie   |        10 |      3 |     29 |             53 |
| Wartortle  |         8 |     10 |    225 |            143 | Caterpie   |        10 |      3 |     29 |             53 |
| Squirtle   |         7 |      5 |     90 |             66 | Caterpie   |        10 |      3 |     29 |             53 |
| Charizard  |         6 |     17 |    905 |            209 | Caterpie   |        10 |      3 |     29 |             53 |
| Charmeleon |         5 |     11 |    190 |            142 | Caterpie   |        10 |      3 |     29 |             53 |
| Charmander |         4 |      6 |     85 |             65 | Caterpie   |        10 |      3 |     29 |             53 |
| Venusaur   |         3 |     20 |   1000 |            208 | Caterpie   |        10 |      3 |     29 |             53 |
| Ivysaur    |         2 |     10 |    130 |            141 | Caterpie   |        10 |      3 |     29 |             53 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Caterpie   |        10 |      3 |     29 |             53 |
| Caterpie   |        10 |      3 |     29 |             53 | Blastoise  |         9 |     16 |    855 |            210 |
| Blastoise  |         9 |     16 |    855 |            210 | Blastoise  |         9 |     16 |    855 |            210 |
| Wartortle  |         8 |     10 |    225 |            143 | Blastoise  |         9 |     16 |    855 |            210 |
| Squirtle   |         7 |      5 |     90 |             66 | Blastoise  |         9 |     16 |    855 |            210 |
| Charizard  |         6 |     17 |    905 |            209 | Blastoise  |         9 |     16 |    855 |            210 |
| Charmeleon |         5 |     11 |    190 |            142 | Blastoise  |         9 |     16 |    855 |            210 |
| Charmander |         4 |      6 |     85 |             65 | Blastoise  |         9 |     16 |    855 |            210 |
| Venusaur   |         3 |     20 |   1000 |            208 | Blastoise  |         9 |     16 |    855 |            210 |
| Ivysaur    |         2 |     10 |    130 |            141 | Blastoise  |         9 |     16 |    855 |            210 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Blastoise  |         9 |     16 |    855 |            210 |
| Caterpie   |        10 |      3 |     29 |             53 | Wartortle  |         8 |     10 |    225 |            143 |
| Blastoise  |         9 |     16 |    855 |            210 | Wartortle  |         8 |     10 |    225 |            143 |
| Wartortle  |         8 |     10 |    225 |            143 | Wartortle  |         8 |     10 |    225 |            143 |
| Squirtle   |         7 |      5 |     90 |             66 | Wartortle  |         8 |     10 |    225 |            143 |
| Charizard  |         6 |     17 |    905 |            209 | Wartortle  |         8 |     10 |    225 |            143 |
| Charmeleon |         5 |     11 |    190 |            142 | Wartortle  |         8 |     10 |    225 |            143 |
| Charmander |         4 |      6 |     85 |             65 | Wartortle  |         8 |     10 |    225 |            143 |
| Venusaur   |         3 |     20 |   1000 |            208 | Wartortle  |         8 |     10 |    225 |            143 |
| Ivysaur    |         2 |     10 |    130 |            141 | Wartortle  |         8 |     10 |    225 |            143 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Wartortle  |         8 |     10 |    225 |            143 |
| Caterpie   |        10 |      3 |     29 |             53 | Squirtle   |         7 |      5 |     90 |             66 |
| Blastoise  |         9 |     16 |    855 |            210 | Squirtle   |         7 |      5 |     90 |             66 |
| Wartortle  |         8 |     10 |    225 |            143 | Squirtle   |         7 |      5 |     90 |             66 |
| Squirtle   |         7 |      5 |     90 |             66 | Squirtle   |         7 |      5 |     90 |             66 |
| Charizard  |         6 |     17 |    905 |            209 | Squirtle   |         7 |      5 |     90 |             66 |
| Charmeleon |         5 |     11 |    190 |            142 | Squirtle   |         7 |      5 |     90 |             66 |
| Charmander |         4 |      6 |     85 |             65 | Squirtle   |         7 |      5 |     90 |             66 |
| Venusaur   |         3 |     20 |   1000 |            208 | Squirtle   |         7 |      5 |     90 |             66 |
| Ivysaur    |         2 |     10 |    130 |            141 | Squirtle   |         7 |      5 |     90 |             66 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Squirtle   |         7 |      5 |     90 |             66 |
| Caterpie   |        10 |      3 |     29 |             53 | Charizard  |         6 |     17 |    905 |            209 |
| Blastoise  |         9 |     16 |    855 |            210 | Charizard  |         6 |     17 |    905 |            209 |
| Wartortle  |         8 |     10 |    225 |            143 | Charizard  |         6 |     17 |    905 |            209 |
| Squirtle   |         7 |      5 |     90 |             66 | Charizard  |         6 |     17 |    905 |            209 |
| Charizard  |         6 |     17 |    905 |            209 | Charizard  |         6 |     17 |    905 |            209 |
| Charmeleon |         5 |     11 |    190 |            142 | Charizard  |         6 |     17 |    905 |            209 |
| Charmander |         4 |      6 |     85 |             65 | Charizard  |         6 |     17 |    905 |            209 |
| Venusaur   |         3 |     20 |   1000 |            208 | Charizard  |         6 |     17 |    905 |            209 |
| Ivysaur    |         2 |     10 |    130 |            141 | Charizard  |         6 |     17 |    905 |            209 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Charizard  |         6 |     17 |    905 |            209 |
| Caterpie   |        10 |      3 |     29 |             53 | Charmeleon |         5 |     11 |    190 |            142 |
| Blastoise  |         9 |     16 |    855 |            210 | Charmeleon |         5 |     11 |    190 |            142 |
| Wartortle  |         8 |     10 |    225 |            143 | Charmeleon |         5 |     11 |    190 |            142 |
| Squirtle   |         7 |      5 |     90 |             66 | Charmeleon |         5 |     11 |    190 |            142 |
| Charizard  |         6 |     17 |    905 |            209 | Charmeleon |         5 |     11 |    190 |            142 |
| Charmeleon |         5 |     11 |    190 |            142 | Charmeleon |         5 |     11 |    190 |            142 |
| Charmander |         4 |      6 |     85 |             65 | Charmeleon |         5 |     11 |    190 |            142 |
| Venusaur   |         3 |     20 |   1000 |            208 | Charmeleon |         5 |     11 |    190 |            142 |
| Ivysaur    |         2 |     10 |    130 |            141 | Charmeleon |         5 |     11 |    190 |            142 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Charmeleon |         5 |     11 |    190 |            142 |
| Caterpie   |        10 |      3 |     29 |             53 | Charmander |         4 |      6 |     85 |             65 |
| Blastoise  |         9 |     16 |    855 |            210 | Charmander |         4 |      6 |     85 |             65 |
| Wartortle  |         8 |     10 |    225 |            143 | Charmander |         4 |      6 |     85 |             65 |
| Squirtle   |         7 |      5 |     90 |             66 | Charmander |         4 |      6 |     85 |             65 |
| Charizard  |         6 |     17 |    905 |            209 | Charmander |         4 |      6 |     85 |             65 |
| Charmeleon |         5 |     11 |    190 |            142 | Charmander |         4 |      6 |     85 |             65 |
| Charmander |         4 |      6 |     85 |             65 | Charmander |         4 |      6 |     85 |             65 |
| Venusaur   |         3 |     20 |   1000 |            208 | Charmander |         4 |      6 |     85 |             65 |
| Ivysaur    |         2 |     10 |    130 |            141 | Charmander |         4 |      6 |     85 |             65 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Charmander |         4 |      6 |     85 |             65 |
| Caterpie   |        10 |      3 |     29 |             53 | Venusaur   |         3 |     20 |   1000 |            208 |
| Blastoise  |         9 |     16 |    855 |            210 | Venusaur   |         3 |     20 |   1000 |            208 |
| Wartortle  |         8 |     10 |    225 |            143 | Venusaur   |         3 |     20 |   1000 |            208 |
| Squirtle   |         7 |      5 |     90 |             66 | Venusaur   |         3 |     20 |   1000 |            208 |
| Charizard  |         6 |     17 |    905 |            209 | Venusaur   |         3 |     20 |   1000 |            208 |
| Charmeleon |         5 |     11 |    190 |            142 | Venusaur   |         3 |     20 |   1000 |            208 |
| Charmander |         4 |      6 |     85 |             65 | Venusaur   |         3 |     20 |   1000 |            208 |
| Venusaur   |         3 |     20 |   1000 |            208 | Venusaur   |         3 |     20 |   1000 |            208 |
| Ivysaur    |         2 |     10 |    130 |            141 | Venusaur   |         3 |     20 |   1000 |            208 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Venusaur   |         3 |     20 |   1000 |            208 |
| Caterpie   |        10 |      3 |     29 |             53 | Ivysaur    |         2 |     10 |    130 |            141 |
| Blastoise  |         9 |     16 |    855 |            210 | Ivysaur    |         2 |     10 |    130 |            141 |
| Wartortle  |         8 |     10 |    225 |            143 | Ivysaur    |         2 |     10 |    130 |            141 |
| Squirtle   |         7 |      5 |     90 |             66 | Ivysaur    |         2 |     10 |    130 |            141 |
| Charizard  |         6 |     17 |    905 |            209 | Ivysaur    |         2 |     10 |    130 |            141 |
| Charmeleon |         5 |     11 |    190 |            142 | Ivysaur    |         2 |     10 |    130 |            141 |
| Charmander |         4 |      6 |     85 |             65 | Ivysaur    |         2 |     10 |    130 |            141 |
| Venusaur   |         3 |     20 |   1000 |            208 | Ivysaur    |         2 |     10 |    130 |            141 |
| Ivysaur    |         2 |     10 |    130 |            141 | Ivysaur    |         2 |     10 |    130 |            141 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Ivysaur    |         2 |     10 |    130 |            141 |
| Caterpie   |        10 |      3 |     29 |             53 | Bulbasaur  |         1 |      7 |     69 |             64 |
| Blastoise  |         9 |     16 |    855 |            210 | Bulbasaur  |         1 |      7 |     69 |             64 |
| Wartortle  |         8 |     10 |    225 |            143 | Bulbasaur  |         1 |      7 |     69 |             64 |
| Squirtle   |         7 |      5 |     90 |             66 | Bulbasaur  |         1 |      7 |     69 |             64 |
| Charizard  |         6 |     17 |    905 |            209 | Bulbasaur  |         1 |      7 |     69 |             64 |
| Charmeleon |         5 |     11 |    190 |            142 | Bulbasaur  |         1 |      7 |     69 |             64 |
| Charmander |         4 |      6 |     85 |             65 | Bulbasaur  |         1 |      7 |     69 |             64 |
| Venusaur   |         3 |     20 |   1000 |            208 | Bulbasaur  |         1 |      7 |     69 |             64 |
| Ivysaur    |         2 |     10 |    130 |            141 | Bulbasaur  |         1 |      7 |     69 |             64 |
| Bulbasaur  |         1 |      7 |     69 |             64 | Bulbasaur  |         1 |      7 |     69 |             64 |
+------------+-----------+--------+--------+----------------+------------+-----------+--------+--------+----------------+
100 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 poke10 order by height;
+------------+-----------+--------+--------+----------------+
| Name       | PokedexID | Height | Weight | BaseExperience |
+------------+-----------+--------+--------+----------------+
| Caterpie   |        10 |      3 |     29 |             53 |
| Squirtle   |         7 |      5 |     90 |             66 |
| Charmander |         4 |      6 |     85 |             65 |
| Bulbasaur  |         1 |      7 |     69 |             64 |
| Wartortle  |         8 |     10 |    225 |            143 |
| Ivysaur    |         2 |     10 |    130 |            141 |
| Charmeleon |         5 |     11 |    190 |            142 |
| Blastoise  |         9 |     16 |    855 |            210 |
| Charizard  |         6 |     17 |    905 |            209 |
| Venusaur   |         3 |     20 |   1000 |            208 |
+------------+-----------+--------+--------+----------------+
10 rows in set (0.00 sec)

mysql> select Name from poke10;
+------------+
| Name       |
+------------+
| Caterpie   |
| Blastoise  |
| Wartortle  |
| Squirtle   |
| Charizard  |
| Charmeleon |
| Charmander |
| Venusaur   |
| Ivysaur    |
| Bulbasaur  |
+------------+
10 rows in set (0.00 sec)

mysql> select Name from poke10
    -> order by height;
+------------+
| Name       |
+------------+
| Caterpie   |
| Squirtle   |
| Charmander |
| Bulbasaur  |
| Wartortle  |
| Ivysaur    |
| Charmeleon |
| Blastoise  |
| Charizard  |
| Venusaur   |
+------------+
10 rows in set (0.01 sec)

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

mysql> describe Species;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| PokedexID | int(11)     | NO   | PRI | 0       |       |
| TypeID    | int(11)     | YES  | MUL | NULL    |       |
| Genus     | varchar(20) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

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

mysql> select p.Name, s.* from poke10 p, Species s where p.PokedexId = s.Pokedexid;
+------------+-----------+--------+-------------+
| Name       | PokedexID | TypeID | Genus       |
+------------+-----------+--------+-------------+
| Caterpie   |        10 |      7 | Worm        |
| Blastoise  |         9 |     11 | Shellfish   |
| Wartortle  |         8 |     11 | Turtle      |
| Squirtle   |         7 |     11 | Tiny Turtle |
| Charizard  |         6 |     10 | Flame       |
| Charmeleon |         5 |     10 | Flame       |
| Charmander |         4 |     10 | Lizard      |
| Venusaur   |         3 |     12 | Seed        |
| Ivysaur    |         2 |     12 | Seed        |
| Bulbasaur  |         1 |     12 | Seed        |
+------------+-----------+--------+-------------+
10 rows in set (0.00 sec)

mysql> select * from Species where Genus = 'Continent';
+-----------+--------+-----------+
| PokedexID | TypeID | Genus     |
+-----------+--------+-----------+
|       383 |      5 | Continent |
|       389 |     12 | Continent |
+-----------+--------+-----------+
2 rows in set (0.00 sec)

mysql> select * from Species, Pokemon where Genus = 'Continent' and
    -> Species.Pokedexid = Pokemon.pokedexid;
+-----------+--------+-----------+-----------+----------+
| PokedexID | TypeID | Genus     | PokedexID | Name     |
+-----------+--------+-----------+-----------+----------+
|       383 |      5 | Continent |       383 | Groudon  |
|       389 |     12 | Continent |       389 | Torterra |
+-----------+--------+-----------+-----------+----------+
2 rows in set (0.00 sec)

mysql> select p.Name, s.* from poke10 p, Species s where p.PokedexId = s.Pokedexid;
+------------+-----------+--------+-------------+
| Name       | PokedexID | TypeID | Genus       |
+------------+-----------+--------+-------------+
| Caterpie   |        10 |      7 | Worm        |
| Blastoise  |         9 |     11 | Shellfish   |
| Wartortle  |         8 |     11 | Turtle      |
| Squirtle   |         7 |     11 | Tiny Turtle |
| Charizard  |         6 |     10 | Flame       |
| Charmeleon |         5 |     10 | Flame       |
| Charmander |         4 |     10 | Lizard      |
| Venusaur   |         3 |     12 | Seed        |
| Ivysaur    |         2 |     12 | Seed        |
| Bulbasaur  |         1 |     12 | Seed        |
+------------+-----------+--------+-------------+
10 rows in set (0.00 sec)

mysql> select p.Name, s.* from poke10 p, Species s where p.PokedexId = s.Pokedexid and Genus = 'Seed';
+-----------+-----------+--------+-------+
| Name      | PokedexID | TypeID | Genus |
+-----------+-----------+--------+-------+
| Venusaur  |         3 |     12 | Seed  |
| Ivysaur   |         2 |     12 | Seed  |
| Bulbasaur |         1 |     12 | Seed  |
+-----------+-----------+--------+-------+
3 rows in set (0.00 sec)

mysql> select p.* from poke10 p, Species s where p.PokedexId = s.Pokedexid and Genus = 'Seed';
+-----------+-----------+--------+--------+----------------+
| Name      | PokedexID | Height | Weight | BaseExperience |
+-----------+-----------+--------+--------+----------------+
| Venusaur  |         3 |     20 |   1000 |            208 |
| Ivysaur   |         2 |     10 |    130 |            141 |
| Bulbasaur |         1 |      7 |     69 |             64 |
+-----------+-----------+--------+--------+----------------+
3 rows in set (0.00 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 p.name
    -> FROM poke10 s, poke10 p
    -> WHERE s.name = 'Wartortle' and s.weight < p.weight
    -> ;
+-----------+
| name      |
+-----------+
| Blastoise |
| Charizard |
| Venusaur  |
+-----------+
3 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 Species s, poke10 p where s.pokedexId = p.pokedexid;
+-----------+--------+-------------+------------+-----------+--------+--------+----------------+
| PokedexID | TypeID | Genus       | Name       | PokedexID | Height | Weight | BaseExperience |
+-----------+--------+-------------+------------+-----------+--------+--------+----------------+
|        10 |      7 | Worm        | Caterpie   |        10 |      3 |     29 |             53 |
|         9 |     11 | Shellfish   | Blastoise  |         9 |     16 |    855 |            210 |
|         8 |     11 | Turtle      | Wartortle  |         8 |     10 |    225 |            143 |
|         7 |     11 | Tiny Turtle | Squirtle   |         7 |      5 |     90 |             66 |
|         6 |     10 | Flame       | Charizard  |         6 |     17 |    905 |            209 |
|         5 |     10 | Flame       | Charmeleon |         5 |     11 |    190 |            142 |
|         4 |     10 | Lizard      | Charmander |         4 |      6 |     85 |             65 |
|         3 |     12 | Seed        | Venusaur   |         3 |     20 |   1000 |            208 |
|         2 |     12 | Seed        | Ivysaur    |         2 |     10 |    130 |            141 |
|         1 |     12 | Seed        | Bulbasaur  |         1 |      7 |     69 |             64 |
+-----------+--------+-------------+------------+-----------+--------+--------+----------------+
10 rows in set (0.00 sec)

mysql> select p.*, s.Species from Species s, poke10 p where s.pokedexId = p.pokedexid;
ERROR 1054 (42S22): Unknown column 's.Species' in 'field list'
mysql> describe Species;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| PokedexID | int(11)     | NO   | PRI | 0       |       |
| TypeID    | int(11)     | YES  | MUL | NULL    |       |
| Genus     | varchar(20) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

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

mysql> create table poke10s as (select p.*, s.Genus from Species s, poke10 p where s.pokedexId = p.pokedexid);
Query OK, 10 rows affected (0.02 sec)
Records: 10  Duplicates: 0  Warnings: 0

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

mysql> select * from 
    -> poke10s a, poke10s b where a.genus = b.genus
    -> ;
+------------+-----------+--------+--------+----------------+-------------+------------+-----------+--------+--------+----------------+-------------+
| Name       | PokedexID | Height | Weight | BaseExperience | Genus       | Name       | PokedexID | Height | Weight | BaseExperience | Genus       |
+------------+-----------+--------+--------+----------------+-------------+------------+-----------+--------+--------+----------------+-------------+
| Caterpie   |        10 |      3 |     29 |             53 | Worm        | Caterpie   |        10 |      3 |     29 |             53 | Worm        |
| Blastoise  |         9 |     16 |    855 |            210 | Shellfish   | Blastoise  |         9 |     16 |    855 |            210 | Shellfish   |
| Wartortle  |         8 |     10 |    225 |            143 | Turtle      | Wartortle  |         8 |     10 |    225 |            143 | Turtle      |
| Squirtle   |         7 |      5 |     90 |             66 | Tiny Turtle | Squirtle   |         7 |      5 |     90 |             66 | Tiny Turtle |
| Charizard  |         6 |     17 |    905 |            209 | Flame       | Charizard  |         6 |     17 |    905 |            209 | Flame       |
| Charmeleon |         5 |     11 |    190 |            142 | Flame       | Charizard  |         6 |     17 |    905 |            209 | Flame       |
| Charizard  |         6 |     17 |    905 |            209 | Flame       | Charmeleon |         5 |     11 |    190 |            142 | Flame       |
| Charmeleon |         5 |     11 |    190 |            142 | Flame       | Charmeleon |         5 |     11 |    190 |            142 | Flame       |
| Charmander |         4 |      6 |     85 |             65 | Lizard      | Charmander |         4 |      6 |     85 |             65 | Lizard      |
| Venusaur   |         3 |     20 |   1000 |            208 | Seed        | Venusaur   |         3 |     20 |   1000 |            208 | Seed        |
| Ivysaur    |         2 |     10 |    130 |            141 | Seed        | Venusaur   |         3 |     20 |   1000 |            208 | Seed        |
| Bulbasaur  |         1 |      7 |     69 |             64 | Seed        | Venusaur   |         3 |     20 |   1000 |            208 | Seed        |
| Venusaur   |         3 |     20 |   1000 |            208 | Seed        | Ivysaur    |         2 |     10 |    130 |            141 | Seed        |
| Ivysaur    |         2 |     10 |    130 |            141 | Seed        | Ivysaur    |         2 |     10 |    130 |            141 | Seed        |
| Bulbasaur  |         1 |      7 |     69 |             64 | Seed        | Ivysaur    |         2 |     10 |    130 |            141 | Seed        |
| Venusaur   |         3 |     20 |   1000 |            208 | Seed        | Bulbasaur  |         1 |      7 |     69 |             64 | Seed        |
| Ivysaur    |         2 |     10 |    130 |            141 | Seed        | Bulbasaur  |         1 |      7 |     69 |             64 | Seed        |
| Bulbasaur  |         1 |      7 |     69 |             64 | Seed        | Bulbasaur  |         1 |      7 |     69 |             64 | Seed        |
+------------+-----------+--------+--------+----------------+-------------+------------+-----------+--------+--------+----------------+-------------+
18 rows in set (0.01 sec)

mysql> select a.name, b.name from  poke10s a, poke10s b where a.genus = b.genus;
+------------+------------+
| name       | name       |
+------------+------------+
| Caterpie   | Caterpie   |
| Blastoise  | Blastoise  |
| Wartortle  | Wartortle  |
| Squirtle   | Squirtle   |
| Charizard  | Charizard  |
| Charmeleon | Charizard  |
| Charizard  | Charmeleon |
| Charmeleon | Charmeleon |
| Charmander | Charmander |
| Venusaur   | Venusaur   |
| Ivysaur    | Venusaur   |
| Bulbasaur  | Venusaur   |
| Venusaur   | Ivysaur    |
| Ivysaur    | Ivysaur    |
| Bulbasaur  | Ivysaur    |
| Venusaur   | Bulbasaur  |
| Ivysaur    | Bulbasaur  |
| Bulbasaur  | Bulbasaur  |
+------------+------------+
18 rows in set (0.00 sec)

mysql> select a.name, b.name from  poke10s a, poke10s b where a.genus = b.genus and a.pokedexid <> b.pokedexid;
+------------+------------+
| name       | name       |
+------------+------------+
| Charmeleon | Charizard  |
| Charizard  | Charmeleon |
| Ivysaur    | Venusaur   |
| Bulbasaur  | Venusaur   |
| Venusaur   | Ivysaur    |
| Bulbasaur  | Ivysaur    |
| Venusaur   | Bulbasaur  |
| Ivysaur    | Bulbasaur  |
+------------+------------+
8 rows in set (0.00 sec)

mysql> select a.name, b.name from  poke10s a, poke10s b where a.genus = b.genus and a.pokedexid < b.pokedexid;
+------------+-----------+
| name       | name      |
+------------+-----------+
| Charmeleon | Charizard |
| Ivysaur    | Venusaur  |
| Bulbasaur  | Venusaur  |
| Bulbasaur  | Ivysaur   |
+------------+-----------+
4 rows in set (0.00 sec)

mysql> select a.name, b.name from  poke10s a, poke10s b where a.genus = b.genus and a.name < b.name;
+-----------+------------+
| name      | name       |
+-----------+------------+
| Charizard | Charmeleon |
| Ivysaur   | Venusaur   |
| Bulbasaur | Venusaur   |
| Bulbasaur | Ivysaur    |
+-----------+------------+
4 rows in set (0.00 sec)

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

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

mysql> select Name, Genus from poke10s;
+------------+-------------+
| Name       | Genus       |
+------------+-------------+
| Caterpie   | Worm        |
| Blastoise  | Shellfish   |
| Wartortle  | Turtle      |
| Squirtle   | Tiny Turtle |
| Charizard  | Flame       |
| Charmeleon | Flame       |
| Charmander | Lizard      |
| Venusaur   | Seed        |
| Ivysaur    | Seed        |
| Bulbasaur  | Seed        |
+------------+-------------+
10 rows in set (0.01 sec)

mysql> select Name, Height/Weight from poke10s;
+------------+---------------+
| Name       | Height/Weight |
+------------+---------------+
| Caterpie   |        0.1034 |
| Blastoise  |        0.0187 |
| Wartortle  |        0.0444 |
| Squirtle   |        0.0556 |
| Charizard  |        0.0188 |
| Charmeleon |        0.0579 |
| Charmander |        0.0706 |
| Venusaur   |        0.0200 |
| Ivysaur    |        0.0769 |
| Bulbasaur  |        0.1014 |
+------------+---------------+
10 rows in set (0.00 sec)

mysql> select Name, weight*100/height from poke10s;
+------------+-------------------+
| Name       | weight*100/height |
+------------+-------------------+
| Caterpie   |          966.6667 |
| Blastoise  |         5343.7500 |
| Wartortle  |         2250.0000 |
| Squirtle   |         1800.0000 |
| Charizard  |         5323.5294 |
| Charmeleon |         1727.2727 |
| Charmander |         1416.6667 |
| Venusaur   |         5000.0000 |
| Ivysaur    |         1300.0000 |
| Bulbasaur  |          985.7143 |
+------------+-------------------+
10 rows in set (0.00 sec)

mysql> select 'My Pokemon', Name, weight*100/height from poke10s;
+------------+------------+-------------------+
| My Pokemon | Name       | weight*100/height |
+------------+------------+-------------------+
| My Pokemon | Caterpie   |          966.6667 |
| My Pokemon | Blastoise  |         5343.7500 |
| My Pokemon | Wartortle  |         2250.0000 |
| My Pokemon | Squirtle   |         1800.0000 |
| My Pokemon | Charizard  |         5323.5294 |
| My Pokemon | Charmeleon |         1727.2727 |
| My Pokemon | Charmander |         1416.6667 |
| My Pokemon | Venusaur   |         5000.0000 |
| My Pokemon | Ivysaur    |         1300.0000 |
| My Pokemon | Bulbasaur  |          985.7143 |
+------------+------------+-------------------+
10 rows in set (0.01 sec)

mysql> select 'Hello';
+-------+
| Hello |
+-------+
| Hello |
+-------+
1 row in set (0.00 sec)

mysql> select 'My Pokemon', Name, weight*100/height from poke10s;
+------------+------------+-------------------+
| My Pokemon | Name       | weight*100/height |
+------------+------------+-------------------+
| My Pokemon | Caterpie   |          966.6667 |
| My Pokemon | Blastoise  |         5343.7500 |
| My Pokemon | Wartortle  |         2250.0000 |
| My Pokemon | Squirtle   |         1800.0000 |
| My Pokemon | Charizard  |         5323.5294 |
| My Pokemon | Charmeleon |         1727.2727 |
| My Pokemon | Charmander |         1416.6667 |
| My Pokemon | Venusaur   |         5000.0000 |
| My Pokemon | Ivysaur    |         1300.0000 |
| My Pokemon | Bulbasaur  |          985.7143 |
+------------+------------+-------------------+
10 rows in set (0.00 sec)

mysql> tee off