pithos: Refactor statistics subquery

Use CTE to get current population.