The SUM() Function | Aggregate Functions
Introduction to SQL

Course Content

Introduction to SQL

## Introduction to SQL

1. Retrieving Data
2. Sorting Retrieved Data
3. Filtering Data
5. Aggregate Functions

# The SUM() Function

`SUM()` - This function returns the sum of the values in a specific column. Let's take a look at the example:

Explanation: The `SUM()` function returns the sum of the population of all countries in Asia from the `country` table.

Write an SQL query that returns the sum of the `surfacearea` of countries from 'Europe'.

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Write an SQL query that returns the sum of the `surfacearea` of countries from 'Europe'.

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

Section 5. Chapter 8

# The SUM() Function

`SUM()` - This function returns the sum of the values in a specific column. Let's take a look at the example:

Explanation: The `SUM()` function returns the sum of the population of all countries in Asia from the `country` table.

Write an SQL query that returns the sum of the `surfacearea` of countries from 'Europe'.

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Write an SQL query that returns the sum of the `surfacearea` of countries from 'Europe'.

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

Section 5. Chapter 8

# The SUM() Function

`SUM()` - This function returns the sum of the values in a specific column. Let's take a look at the example:

Explanation: The `SUM()` function returns the sum of the population of all countries in Asia from the `country` table.

Write an SQL query that returns the sum of the `surfacearea` of countries from 'Europe'.

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Write an SQL query that returns the sum of the `surfacearea` of countries from 'Europe'.

Here's a short example of the `country` table:

 id name continent region surfacearea capital population 1 Japan Asia Eastern Asia 377829 Tokyo 126714000 2 Latvia Europe NULL 64589 Riga 2424200 3 Mexico North America Central America 1958201 Mexico City 98881000 ... ... ... ... ... ... ... 15 Malta Europe Southern Europe 316 Valletta 380200

Everything was clear?

`SUM()` - This function returns the sum of the values in a specific column. Let's take a look at the example:

Explanation: The `SUM()` function returns the sum of the population of all countries in Asia from the `country` table.

Write an SQL query that returns the sum of the `surfacearea` of countries from 'Europe'.
Here's a short example of the `country` table: