SQL code copied to buffer

SQLtest interactive SQL practice

Sharpen your SQL skills with our interactive exercises and assessments!
Practice a wide range of SQL tasks, from basic queries to advanced techniques. Get immediate feedback on your solutions, helping you learn from mistakes and improve your skills. Boost your confidence for job interviews and real-world SQL applications.
RU PT
Dear user,
You and many others enjoy this site for free. Our only sources of funding are advertising and donations. To help us keep this project free for everyone, please consider not blocking ads on the site.
If ads are an issue for you, please let me know, and I'll turn them off for your account.
Task 177: 
For all penguins in the little_penguins table, get the species, island, flipper length, maximal flipper length in the table, and the difference in individual flipper length from the maximum. Build a result table with the fields species, island, flipper_length_mm, max_flipper_length_mm, diff_from_max_flipper_length_mm.
Solve the problem without window functions.

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
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Explore over 330 diverse tasks on our platform.

Querynomicon (SQLite)

A compact database for learning the basics of SQL.

The Querynomicon database contains 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