Do Math with Your Data

Let’s make your database do some basic calculations. SQL includes powerful functions like COUNT, SUM, AVG, MIN, and MAX, and they’re easier than you think.

Goal

You’ll aim to:

• Use SQL aggregate functions to summarize data.

• Calculate totals, averages, highs, and lows.

Tables

Let’s use the following table in this lesson:

The people table