Working with Subqueries

UPDATE country
SET Population = (
    SELECT SUM(Population)
    FROM city
    WHERE city.CountryCode = country.Code
)


We set the population of the countries by selecting the total number of inhabitants of the cities of this country.