🙏 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

SQLtest.online
Task 91: 
Retrieve all distinct penguin species from the database. Output a sorted table with a single column.

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

Use SQLite syntax to write your answer. Descriptions of tables are provided at the bottom of the screen.

Get hint Copy code Clear editor

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.

List of tables

department - table of departments.
  • identDepartment ID
  • nameDepartment name
  • buildingBuilding name
ident name building
gen Genetics Chesson
little_penguins - table of little penguins.
  • speciesPenguin species
  • islandIsland of residence
  • bill_length_mmBill length, mm
  • bill_depth_mmBill depth, mm
  • flipper_length_mmFlipper length, mm
  • body_mass_gBody mass, g
  • sexSex
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.
  • speciesPenguin species
  • islandIsland of residence
  • bill_length_mmBill length, mm
  • bill_depth_mmBill depth, mm
  • flipper_length_mmFlipper length, mm
  • body_mass_gBody mass, g
  • sexSex
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.
  • identEmployee number
  • personalEmployee first name
  • familyEmployee last name
  • deptDepartment
  • ageAge
ident personal family dept age
7 Abram Chokshi gen 23
machine - table of machines.
  • identMachine ID
  • nameMachine name
  • detailsJSON with details
ident name details
1 WY401 {"acquired": "2023-05-01"}
2 Inphormex {"acquired": "2021-07-15", "refurbished": "2023-10-22"}
3 AutoPlate 9000 {"note": "needs software update"}
Head First SQL: A Learner's Guide to Querying and Managing Data by Kimberly Fessel
Head First SQL: A Learner's Guide to Querying and Managing Data by Kimberly Fessel
Do you have an abundance of data but don't know how to make sense of it? Do you want to gain useful insights from your data, but you're not sure where to begin? Mining data is a vital, well-paying skill, and SQL provides the most fundamental way to query and manage data. But learning SQL can be intimidating. This thoroughly revised book teaches you SQL fundamentals in a painless and enjoyable manner. With the Head First series’ hands-on, conversational style, you'll quickly grasp SQL concepts, then move to intermediate topics, including subqueries and joins. You'll gain the knowledge, skills, and confidence necessary to get the most out of your data with SQL.