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.
Expected result
| species | sex | penguins_count | avg_bill_length_mm | avg_bill_depth_mm | avg_flipper_length_mm | avg_body_mass_g |
|---|
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