Task 82:

Count the penguins

SQLite

Count the number of penguins of each species. Output the result in two columns species and quantity.

Expected result Columns: 2 · Rows: 3

species	quantity

Write your query below and click "Check it!". Tables are described in the right pane.

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.