🙏 Thank you for your support. Last month we received only $32. That covers servers, but not development, so there will be no new lessons or features this month. If you can, please support next month. Support now →
SQL code copied to buffer
RU PT FR
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.