mysql80> SELECT Continent, Name, SUM(Population) AS Population FROM country GROUP BY Continent, Name WITH ROLLUP; +---------------+----------------------------------------------+------------+ | Continent | Name | Population | +---------------+----------------------------------------------+------------+ | Asia | Afghanistan | 22720000 | | Asia | Armenia | 3520000 | | Asia | Azerbaijan | 7734000 | .