Lesson 10 of 20
Calculate indicators with COUNT, SUM and AVG
Transform a set of lines into simple indicators: volume, total, and average.
20 minSQL Essentials
By the end of this lesson
- Counting rows with COUNT
- Add a column with SUM
- Calculate and interpret an average with AVG
SQL Essentials
Unlock this lesson and continue the path.
Calculate indicators with COUNT, SUM and AVG is part of the complete programme: 38 lessons, 62 verifiable exercises and 8 published guided projects.
- Complete content with explained examples
- SQL simulator and expected result
- Detailed answer, common mistakes and challenge