PokemonSqlLab/Part2.txt

//What are all the types of pokemon that a pokemon can have?
SELECT name
FROM pokemon.types;


//What is the name of the pokemon with id 45? Eevee
SELECT name, id
FROM pokemon.pokemons
WHERE id = 45;

//How many pokemon are there? 656

SELECT id, name
FROM pokemon.pokemons
ORDER BY id DESC;

//How many types are there? 18
SELECT id, name
FROM pokemon.types
ORDER BY id DESC;

How many pokemon have a secondary type? 316
SELECT name, secondary_type
FROM pokemon.pokemons
WHERE secondary_type IS NOT NULL;