Based on the penguins table, create a view penguins_averages with the fields species - penguin species, sex - penguin sex, penguins_count - the number of individuals, and the fields avg_bill_length_mm, avg_bill_depth_mm, avg_flipper_length_mm and avg_body_mass_g - representing average values by species and sex of animals.
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.