---

SELECT Regions.name AS region_name, SUM(Cities.population) AS total_population
FROM Regions
JOIN Cities ON Regions.id = Cities.regionid
GROUP BY Regions.name;