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.
Use SQLite syntax to write your answer. Descriptions of tables are provided in the right pane.
Write your request in the field below and click the "Check it!" button.