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
| 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.
By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more
The query result will appear here. Ctrl+Enter - Run query