Pokemon Data

This data set includes Pokemon statistics, including their number, name, first and second type, and basic stats: HP, Attack, Defense, Special Attack, Special Defense, and Speed. It has been of great use when teaching statistics to kids. With certain types you can also give a geeky introduction to machine learning.

GamesGamesPopular Culturedata scienceanalyticsCTE

Getting Started

This dataset is ready for exploration using PostgreSQL 17. Switch to the "SQL Editor" tab to start writing queries.

Sample Queries

Try these example queries to get started:

Challenge: Build a team with this constraints, team size = 10, atleast 1 pokemon from each generation, team strength is sum of Total for all members. Find such a team with highest score
...

SQL Output