CIA World Factbook: aggregate functions

This tutorial concerns aggregate functions such as COUNT, SUM and AVG.

Exercises

Using SUM, COUNT, MAX, AVG, DISTINCT and ORDER BY.

Using GROUP BY and HAVING.


The next tutorial is looks at the Movie database. It shows how queries may use records from two or more tables.