Query: compute_disk_unattached

with disks as (
  select
    case
      when users is null then 'available'
      else 'in-use'
    end as attachment_status
  from
    gcp_compute_disk
)
select
  attachment_status,
  count(*)
from
  disks
group by
  attachment_status;