Keep SQLtest alive: Help cover this month's $100 server costs to keep all lessons and the SQL playground online. Support the project →
SQL code copied to buffer

SQLtest.online

Practice

Lessons

Playground

Test

Task 2:

Update Penguin Islands

SQLite
Modify the penguins table by adding a new column named island_id that references the id column in the islands table. Then, populate the island_id column with the corresponding id from the islands table based on the matching island name in the penguins table.
Expected result Columns: 8 · Rows: 344
species island bill_length_mm bill_depth_mm flipper_length_mm body_mass_g sex island_id

Sample rows open after wrong checks: 0 of 3

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