You are viewing a single comment's thread. Return to all comments →
Well,
avg(population) returns average city population count(population) returns total number of records
And average population * number of records = total populaion. So you will actually get a correct result with your code.
However, it's more logical to use SUM here.
Seems like cookies are disabled on this browser, please enable them to open this website
Revising Aggregations - The Sum Function
You are viewing a single comment's thread. Return to all comments →
Well,
And average population * number of records = total populaion. So you will actually get a correct result with your code.
However, it's more logical to use SUM here.