COUNT, SUM, AVG, MIN and MAX
Aggregate functions turn many rows into one answer.
Examplesql
Add a WHERE first to summarise only some rows.
Examplesql
Quick check
Which function counts rows?
Your turn: write the code
Count how many products cost more than 20.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.