🙏 Help keep this project alive. Last month we raised only $32 - enough for servers only. Without your support, there will be no new lessons or features. Support now →
SQL code copied to buffer
RU PT FR
Task 47:

Population Distribution (Pivot)

Write an SQL query to determine the total population size of each penguin species, breaking down the results by each unique island represented in the dataset.
The output should contain a species column and columns with island names in alphabetical order, displaying the abundance of each species on that island.

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.
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.