To keep the penguins_by_islands table (created in this task) up to date, create a trigger that fires after rows are deleted from the penguins table and reduces the number of penguins living on the corresponding island.
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.