aliascity

Data utworzenia: 14-11-2024 13:37:14

SELECT co.Name, SUM(c.Population) AS IluObywateli FROM city AS c, country AS co WHERE Continent="South America" AND c.Population>=100000 AND co.Code=c.CountryCode GROUP BY co.name ORDER BY IluObywateli DESC;