Support the project! The site exists thanks to the community. If the help covers the expenses - the platform remains free.Support →
SQL code copied to buffer
Task 8:

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.