For each question, you will need to construct a SQL query that fetches the desired data from the SQLite DBMS.

Question 1: Please create a SQL query to print out all pokemon id, name, height and weight from table pokemon_CSC321

Question 2: Please create a SQL query to group pokemons in table pokemon_CSC321 based on capture_rate, calculate and print out the maximum base_experience for each group (please use capture_rate to sort the result using the ascending order).

Question 3: Use table pokemon_species, please create a SQL query to output the total (summation) number of pokemons for generation 2,3 and 4 (using generation_id)

Question 4: Please use table pokemon_species_names and table pokemon_species to build a SQL query (using JOIN ) output id, name, species_id and capture_rate for pokemon from all generations.

Question 5: If two pokemons share the same evolution_chain_id, it means they are in the same evolution family. The base (first) pokemon in a family will have generation_id = 1. For example, Bulbsaure, Ivysaur and Venusaur are all in the same evolution family and the base pokemon for the family is Bulbsaure.

Please use table pokemon_species to create a SQL query and output all evolution families (use the base pokemon's name) and also output total number of pokemons in that family.

An example output are shown below: