Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Aggregation

Select the average of the bill_length_mm column:

SELECT avg(bill_length_mm)
FROM penguins;

Select the maximum of the bill_length_mm column, grouped by species:

SELECT
  species,
  max(bill_length_mm)
FROM penguins
GROUP BY species;