course content

Course Content

Introduction to SQL

The AVG() FunctionThe AVG() Function

AVG() returns the average value of a certain column. Let's see an example:

AVG() can also determine the average of specific columns or rows (with some conditions). Let's take a look at the following example:


Write an SQL query to retrieve the average value of a surfacearea column from the country table.

Here's a short example of the country table:

1JapanAsiaEastern Asia377829Tokyo126714000
3MexicoNorth AmericaCentral America1958201Mexico City98881000
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 5. Chapter 1
toggle bottom row