Below is my table and the population is with respect to each city.

```
City state country population
c1   s1   co1   100000
c2   s1   co1   100000
c3   s1   co1   100000
c11  s2   co1   100000
c12  s2   co1   100000

```

And I need the output as follows

```
s1 300000
s2 200000
co1 500000

```

Can anyone help in doing this using sql server or Teradata would be appreciated