Support the project! The site exists thanks to the community. If the help covers the expenses - the platform remains free. ☕ Support →
SQL code copied to buffer
Task 190:

Analyze Flipper Length

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

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

Privacy & Cookie Policy.