New month, new goals. Your help keeps the project moving forward. 🖥️ Support sqltest →
SQL code copied to buffer
Task 36:

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

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.