Based on the penguins table, create a view penguins_averages with the following fields: - species: penguin species - sex: penguin sex - penguins_count: the number of individuals - avg_bill_length_mm: average bill length in mm - avg_bill_depth_mm: average bill depth in mm - avg_flipper_length_mm: average flipper length in mm - avg_body_mass_g: average body mass in grams, calculated by species and sex.
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.