The SUM() Function
SUM()
returns the total of all the values in a given column.
Hereβs an example:
SELECT SUM(population) FROM country WHERE continent='Asia';
The SUM()
function calculates the total population of all Asian countries found in the country
table.
Here is the country
table we are working with:
Task
Swipe to start coding
Write an SQL query that returns the sum of the surfacearea
of countries from 'Europe'.
Solution
Everything was clear?
Thanks for your feedback!
SectionΒ 5. ChapterΒ 8