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

Grouping

Count the number of entries in the penguins table for each species:

SELECT
  species,
  count(*)
FROM penguins
GROUP BY species;