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.
Write your request in the field below and click the "Check it!" button.
Use SQLite syntax to write your answer. Descriptions of tables are provided at the bottom of the screen.
