To select data for nodes with respect to storage pool

select node_name, stgpool_name,sum(num_files) as Number_of_files, sum(physical_mb) as MB from occupancy group by node_name, stgpool_name