Create a table penguins_by_islands with fields island - field type text, primary key and penguins_count - field type integer. Fill the new table with data based on the table penguins so that the column island contains the name of the island, and penguins_count - the number of penguins living on it.
Use SQLite syntax to write your answer. Descriptions of tables are provided in the right pane.
Write your request in the field below and click the "Check it!" button.