New month, new goals. Your help keeps the project moving forward. 🖥️ Support sqltest →
SQL code copied to buffer
Task 189:

Analyze Bill Lengths

SQLite
For all penguins in the little_penguins table, get the species, island, beak length, average beak length in the table, and the difference in beak length for each penguin from the average. Build a result table with the fields species, island, bill_length_mm, avg_bill_length_mm, diff_from_avg_bill_length_mm.
Solve the problem using window functions.
Expected result Columns: 5 · Rows: 10
species island bill_length_mm avg_bill_length_mm diff_from_avg_bill_length_mm

Sample rows open after wrong checks: 0 of 2

Write your query below and click "Check it!". Tables are described in the right pane.

The query result will appear here. Ctrl+Enter - Run query

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.