PokemonSqlLab/Part 2

#What are all the types of pokemon that a pokemon can have?

18 types

select * from Pokemon.types

#What is the name of the pokemon with id 45?

"Eevee"

select * from Pokemon.pokemons where id=45

#How many pokemon are there?

28804

select count(*) from pokemon_trainer;

#How many types are there?
18
select count(id) from Pokemon.types

#How many pokemon have a secondary type?
316
select count(id) from pokemon.pokemons where secondary_type IS NOT NULL