I agree.  Here is a query that will do it for you:

select stgpool_name as stgpool,
cast(mean(est_capacity_MB/1024) as decimal(5,2)) as
gb_per_FULL_vol from volumes where status='FULL' group by
stgpool_name