Skip to content

Instantly share code, notes, and snippets.

@srsgores

srsgores/all_pokemon.sql

Last active November 11, 2017 01:59
Show Gist options
  • Save srsgores/13743b592b88a06b72270c97ee92e957 to your computer and use it in GitHub Desktop.
Save srsgores/13743b592b88a06b72270c97ee92e957 to your computer and use it in GitHub Desktop.
Download ZIP
Query pokemon data
Raw
all_pokemon.sql
SELECT p.species_id, p.height, p.weight, p.base_experience, p.is_default, ps.*, pev.* FROM pokemon p
INNER JOIN pokemon_species ps on ps.id=p.id
INNER JOIN pokemon_evolution pev on pev.id=p.id
INNER JOIN pokemon_stats pstat on pstat.pokemon_id=p.id
@srsgores
Copy link
Author

Getting duplicates...
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment