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.