PokemonSqlLab/pokemon_sql/part2

use pokemon;

#What are all the types of pokemon that a pokemon can have?
SELECT NAME AS "TYPE" FROM types;
#18

#What is the name of the pokemon with id 45?
SELECT ID, NAME
FROM pokemon.pokemons WHERE id IN (45);
# Eevee

#How many pokemon are there?
SELECT COUNT(*) AS "count"
FROM pokemon.pokemons;
#656


#How many types are there?
SELECT COUNT(*)
from pokemon.types;
#18

#How many pokemon have a secondary type?
SELECT pokemons.secondary_type
from pokemon.pokemons
where pokemons.secondary_type IS NOT NULL;
 #316