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