There is very little time left until the end of the month! Help us pay for hosting and infrastructure. 🖥️ Support sqltest →
SQL code copied to buffer
Task 235:

Create Islands Table

For data normalization purpose, create a new dictionary table named islands with a autoincrement primary key column id and a text column name. Populate this table with distinct island names from the penguins table, ensuring the names are sorted in ascending order.

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.
Tutorial Get hint
Copy code Clear editor

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.