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