New month, new goals. Your help keeps the project moving forward. 🖥️ Support sqltest →
SQL code copied to buffer
Task

Update Statistics Trigger

SQLite
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.

Write your query below and click "Check it!". Tables are described in the right pane.

The query result will appear here. Ctrl+Enter - Run query

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.