Query: storage_snapshot_by_resource_type

select
  resource_type,
  sum(size_gigabytes) as "GB"
from
  digitalocean_snapshot as d
group by
  resource_type;