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
Task 1:

Create Islands Table

SQLite
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.
Expected result Columns: 2 · Rows: 3
id name

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial
The query result will appear here. Ctrl+Enter - Run query