SQL Assessment: Penguins and Islands

SQL code copied to buffer

Group by

complexity

category

database

Advertising income and donations are our sole funding sources. Please don’t disable ads or consider donating.
Thank you for your support! 🙏🌟

Help make SQLtest.online even better!

Greetings, SQL lovers!

I am writing to you today because I need your help.

SQLtest.online is a free platform designed to help people of all levels master SQL.
We offer a wide range of interactive tests, problems and training materials to help you improve your SQL skills.
The platform has already helped a lot of people, but we want to make it even better. And this is where you can help us!

How you can help:

Invite your friends and colleagues to join SQLtest.online!
Tell your friends and colleagues about SQLtest.online. Share a link to our site on social networks, by email or in person.
Write an article or blog post about SQLtest.online. Share your experience with the platform.
Together we can make SQLtest.online the best resource for learning SQL!

The more people use the platform, the better it will become. We'll be able to add more content, improve features, and create a better community for SQL enthusiasts.

Thanks for your help!
Command SQLtest.online

Task 12:

Find the number of penguin species and the number of islands they inhabit. Display the result in two columns species and islands.

Write your request in the field below and click the "Check it!" button.

To write the answer, use SQLite syntax. Descriptions of the tables are given in the right panel.

Explore over 300 diverse tasks on our platform.

Querynomicon (SQLite)

Small database for learn SQL basics.

SQLtest: interactive SQL practice

Querynomicon (SQLite)