SQL Basics | Functions | AVG

AVG calculates the average of the data retrieved from a table.

AVG syntax

SELECT AVG("field_name")
FROM "table_name";

AVG example

For example, suppose you want to find the average of the sales field in the table below.

store_information table

Enter the following command.

SELECT AVG(sales)
FROM store_information

The result is as follows.