PokemonSqlLab/pokemon_sql/Part 2

--What are all the types of pokemon that a pokemon can have?
select types.name
from pokemon.types;


--What is the name of the pokemon with id 45?
select pokemons.name
from pokemon.pokemons
where id = 45;


--How many pokemon are there?
select count(pokemons.name)
from pokemon.pokemons;



--How many types are there?
select count(types.id)
from pokemon.types;



-- How many pokemon have a secondary type?
select count(pokemons.secondary_type)
from pokemons;