page1
countrycode | citycode | population
------------+----------+------------
ES | BAR | 1.9
ES | MAD | 3.3
ES | ZAR | 0.7
FR | PAR | 2.2
FR | LYO | 0.5
FR | LLL | 0.2
FR | AMN | 0.1
countrycode | count | sum
------------+-------+-----
ES | 3 | 5.9
FR | 4 | 3.0