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

Getting Started
1Switch to a SQL tab and select a database
2Write or paste your SQL in the editor
3Press Alt+Enter to run
Quick Templates
Tip:Select text in the editor to run only that portion