<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "How to retrieve population sums similar to /countries/?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "How to retrieve population sums similar to /countries/?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>How to retrieve population sums similar to /countries/?</title>
				<description><![CDATA[ I have allCountries.txt imported into mysql and want to do some analysis on population sums on certain regions.

Firstly, I tried to figure out "world population" by performing:
select sum(population)
from allCountries_table

Yet this result is extremely off from the realistic result.

I then tried to find sum of population per country doing:

select country_code, sum(population)
from allCountries_table
group by country_code

and yet, these numbers are far off from http://www.geonames.org/countries/

What fields in the query am I missing so that my results can match the populations listed on the link above?]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/10449.page#19067</guid>
				<link>http://forum.geonames.org/gforum/posts/list/10449.page#19067</link>
				<pubDate><![CDATA[Thu, 7 Aug 2014 11:13:27]]> GMT</pubDate>
				<author><![CDATA[ sparkletts]]></author>
			</item>
	</channel>
</rss>