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