Task 28:

Common penguin species

SQLite

Find the species of penguin that are present on every single island presents in the dataset.
Display the result in a single column named species.

Expected result Columns: 1 · Rows: 1

species

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

Querynomicon Database: table structure and overview

Querynomicon (SQLite) is a compact training database for learning SQL fundamentals with clear and simple examples.

This page presents the tables, key columns, and sample rows for hands-on SQL practice.

The Querynomicon database contains 5 main tables.

department - table of departments.

ident	name	building
gen	Genetics	Chesson

little_penguins - table of little penguins.

species	island	bill_length_mm	bill_depth_mm	flipper_length_mm	body_mass_g	sex
Gentoo	Biscoe	52.1	17	230	5550	MALE

penguins - table of penguins.

species	island	bill_length_mm	bill_depth_mm	flipper_length_mm	body_mass_g	sex
Gentoo	Biscoe	52.1	17	230	5550	MALE

staff - table of employees.

ident	personal	family	dept	age
7	Abram	Chokshi	gen	23

machine - table of machines.