🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 37:

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.
Expected result Columns: 2 · Rows: 4
island penguins_count

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

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

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