Questions and Answers
Question 1: What is the total number of Pokémon currently in the Pokédex?
The total number of Pokémon currently in the Pokédex is 928.
Question 2: Which Pokémon has the highest Attack stat amongst Legendary Pokémon? Which one has the highest Attack stat amongst non-Legendary Pokémon?
The Pokémon that has the highest Attack stat amongst Legendary Pokémon is Kartana.
The Pokémon that has the highest Attack stat amongst non-Legendary Pokémon is Rampardos.
Question 3: How many Pokémon are exclusively "Fire" types?
The number of Pokémon that are exclusively 'Fire' types is 34.
Question 4: What are the names and attack stats of all the Legendary Pokémon in Generation 7?
| Pokémon Name | Attack stats |
|---|---|
| Tapu Koko | 115 |
| Tapu Lele | 85 |
| Tapu Bulu | 130 |
| Tapu Fini | 75 |
| Cosmog | 29 |
| Cosmoem | 29 |
| Solgaleo | 137 |
| Lunala | 113 |
| Nihilego | 53 |
| Buzzwole | 139 |
| Pheromosa | 137 |
| Xurkitree | 89 |
| Celesteela | 101 |
| Kartana | 181 |
| Guzzlord | 101 |
| Necrozma | 107 |
| Necrozma | 157 |
| Necrozma | 113 |
| Magearna | 95 |
| Marshadow | 125 |
| Poipole | 73 |
| Naganadel | 73 |
| Stakataka | 131 |
| Blacephalon | 127 |
Question 5: What is the average defense stat of all the Pokémon?
The average defense of all the Pokémon in our database is 73.
Question 6: What are the names and types of all of the non-Legendary Pokémon with a speed greater than 120?
| Pokémon Name | Type 1 | Type 2 |
|---|---|---|
| Alakazam | Psychic | |
| Gengar | Ghost | Poison |
| Exeggutor | Grass | Psychic |
| Zapdos | Electric | Flying |
| Moltres | Fire | Flying |
| Crobat | Poison | Flying |
| Gardevoir | Psychic | Fairy |
| Roserade | Grass | Poison |
| Magnezone | Electric | Steel |
| Magmortar | Fire | |
| Glaceon | Ice | |
| Porygon-Z | Normal | |
| Darmanitan | Fire | Psychic |
| Duosion | Psychic | |
| Reuniclus | Psychic | |
| Beheeyem | Psychic | |
| Chandelure | Ghost | Fire |
| Hydreigon | Dark | Dragon |
| Volcarona | Bug | Fire |
| Primarina | Water | Fairy |
| Vikavolt | Bug | Electric |
| Wishiwashi | Water | School |
| Drampa | Normal | Dragon |
| Inteleon | Water | |
| Polteageist | Ghost | |
| Hatterene | Psychic | Fairy |
| Cursola | Ghost | |
| Frosmoth | Ice | Bug |
Question 7: Which five (5) Pokémon have the highest HP (Hit Points) amongst all 'Water' types?
| Pokémon Name | HP (Hit Points) |
|---|---|
| Wailord | 170 |
| Alomomola | 165 |
| Vaporeon | 130 |
| Lapras | 130 |
| Wailmer | 130 |
Question 8: What is the total number of Pokémon in each generation?
| Generation | Total number of Pokémon |
|---|---|
| 1 | 151 |
| 2 | 100 |
| 3 | 135 |
| 4 | 133 |
| 5 | 164 |
| 6 | 73 |
| 7 | 91 |
| 8 | 81 |
Question 9: What are the names of Pokémon that have both "Ghost" and "Fairy" as their types?
Mimikyu is the name of Pokémon that have both 'Ghost' and 'Fairy' as their types.
Question 10: What is the average HP, attack, and defense stats of the Pokémon belonging to the "Grass" type?
The stats of the Pokemon belonging to the 'Grass' type are the following : the average HP is 66, the avarage attack is 74, and the average defense is 72.
Question 11: Insert a new Pokémon into the Pokédex with the following details: Name: Sprigatito Type: Grass HP: 40 Attack: 61 Defense: 54 Speed: 65 Sp. Atk: 45 Sp. Def: 45 Generation: 9 Legendary: No Retrieve the record for Sprigatito and display it to the user.
Pokémon Name: Sprigatito
Type: Grass
HP: 40
Attack: 61
Defense: 54
Speed: 65
Special Attack: 45
Special Defense: 45
Generation: 9
Legendary: No
Question 12: Increment Sprigatito speed stat by 10 and display the updated entry to the user.
Pokémon Name: Sprigatito
Type: Grass
HP: 40
Attack: 61
Defense: 54
Speed: 75
Special Attack: 45
Special Defense: 45
Generation: 9
Legendary: No
Question 13: Delete Sprigatito from the Pokédex and try to display it to the user.
Sprigatito not found in the database.