Query: compute_disk_storage_by_subscription

select
  sub.title as "Subscription",
  sum(d.disk_size_gb) as "GB"
from
  azure_compute_disk as d,
  azure_subscription as sub
where
  sub.subscription_id = d.subscription_id
group by
  sub.title
order by
  sub.title;