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: 20 lessons, 44 verifiable exercises and 2 published guided projects.

  • Complete content with explained examples
  • SQL simulator and expected result
  • Detailed answer, common mistakes and challenge
View SQL EssentialsI already have access
Six-month access, one-time payment and no automatic renewal.
Calculate indicators with COUNT, SUM and AVG — SQL lesson — SQL.tn