New month, new goals. Your help keeps the project moving forward. 🖥️ Support sqltest →
SQL code copied to buffer
Task

Create Penguins Stats Table

SQLite
Create a table penguins_by_islands with fields island - field type text, primary key and penguins_count - field type integer.
Fill the new table with data based on the table penguins so that the column island contains the name of the island, and penguins_count - the number of penguins living on it.

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

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

Privacy & Cookie Policy.