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

Create Trigger

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

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.