This goes top down instead of side by side ...
but it's quick and easy!

 select stgpool_name, sum(physical_mb)/1024 as physical_GB
  from occupancy                -
 group by stgpool_name order by stgpool_name