← All lessons lesson_17 · 17 of 31

GROUP BY

← Prev Next →

exercise

Lesson 17 of 31

GROUP BY

You can use aggregate functions such as COUNT, SUM, AVG, MAX, and MIN with the GROUP BY clause.

When you GROUP BY something, you split the table into different piles based on the value of each row.

For example,
SELECT COUNT(*), species FROM friends_of_pickles GROUP BY species; would return the number of rows for each species.

Can you return the tallest height for each species? Remember to return the species name next to the height too, like in the example query.

available tables

Loading…

your-query.sql

Ctrl + ⏎ ready

Press Run query to see your result.