A sql lab filled with pokemon data

12345678910111213141516171819202122
  1. ### Part 2: Simple Selects and Counts
  2. Directions: Write a sql query or sql queries that can answer the following questions
  3. * What are all the types of pokemon that a pokemon can have?
  4. SELECT COUNT(id) FROM pokemon.types;
  5. * What is the name of the pokemon with id 45?
  6. SELECT name FROM pokemon.pokemons WHERE id = 45;
  7. * How many pokemon are there?
  8. SELECT COUNT(id) FROM pokemon.pokemons;
  9. * How many types are there?
  10. * How many pokemon have a secondary type?
  11. SELECT COUNT(id) FROM pokemon.pokemons WHERE secondary_type IS NOT NULL;