To keep the penguins_by_islands table (created in this task) up to date, you need to write a trigger that fires after rows are added to the penguins table. The trigger code 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.
Write your request in the field below and click the "Check it!" button.
Use SQLite syntax to write your answer. Descriptions of tables are provided at the bottom of the screen.