PokemonSqlLab/Part2-SimpleSelectAndCounts...

#What are all the types of pokemon that a pokemon can have?
SELECT distinct p.primary_type
FROM Pokemon.Pokemons p
18 

#What is the name of the pokemon with id 45?
SELECT ID, name 
FROM Pokemon.pokemons
  WHERE id = 45
Eevee

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

#How many types are there?
SELECT COUNT(*) AS "count"
FROM Pokemon.types
18

#How many pokemon have a secondary type?
SELECT p.*
FROM Pokemon.Pokemons p
WHERE p.secondary_type IS NOT NULL
316