To keep the penguins_by_islands table (created in this task) up to date, write a trigger that fires after rows are added to the penguins table. The trigger should update the number of penguins in the corresponding record of the resulting table, or create a new record if a penguin is added for an island that is not yet in the table.
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.