sql dividing numbers by different group by results : Basically I have a table with several columns but I'm only interested in 4. My table looks like that:

colA colB, colC, **date**, colE, **country**, colF, **city**, colH, **quantity**.


What I want to achieve is to get 5 columns like this:


[results][1]

So far my script looks like this:
select country, city, sum(quantity)
from table
where date > dateadd(month,-1,getdate())
group by country, city
order by country, city

The where condition is because I only want the last month of data so consider it irrelevant. 

How can I achieve what I want with a simple script?


  [1]: https://i.stack.imgur.com/bpkc7.png