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

SQLtest.online

Practice

Lessons

Playground

Test

Task 38:

Penguin Species on Every Island

SQLite 
For every penguin species and every island in the penguins table, count the penguins of that species on the island. A species that doesn't live on an island must be shown with 0 for it.
Output columns:
- species
- island
- penguins - the number of penguins

Sort the result by species, then by island.
Expected result Columns: 3 · Rows: 9
species island penguins

Sample rows open after wrong checks: 0 of 2

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