Keep SQLtest alive: Help cover this month's $100 server costs to keep all lessons and the SQL playground online. Support the project →
SQL code copied to buffer

SQLtest.online

Practice

Lessons

Playground

Test

Task 190:

Analyze Flipper Length

SQLite 
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.
Expected result Columns: 5 · Rows: 10
species island flipper_length_mm max_flipper_length_mm diff_from_max_flipper_length_mm

Sample rows open after wrong checks: 0 of 2

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