Course Content
Introduction to SQL
Introduction to SQL
The SUM() Function
SUM()
- This function returns the sum of the values in a specific column. Let's take a look at the example:
SELECT SUM(population) FROM country WHERE continent='Asia';
Explanation: The SUM()
function returns the sum of the population of all countries in Asia from the country
table.
Task
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 |
Thanks for your feedback!
The SUM() Function
SUM()
- This function returns the sum of the values in a specific column. Let's take a look at the example:
SELECT SUM(population) FROM country WHERE continent='Asia';
Explanation: The SUM()
function returns the sum of the population of all countries in Asia from the country
table.
Task
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 |
Thanks for your feedback!
The SUM() Function
SUM()
- This function returns the sum of the values in a specific column. Let's take a look at the example:
SELECT SUM(population) FROM country WHERE continent='Asia';
Explanation: The SUM()
function returns the sum of the population of all countries in Asia from the country
table.
Task
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 |
Thanks for your feedback!
SUM()
- This function returns the sum of the values in a specific column. Let's take a look at the example:
SELECT SUM(population) FROM country WHERE continent='Asia';
Explanation: The SUM()
function returns the sum of the population of all countries in Asia from the country
table.
Task
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 |