Query: compute_disk_by_attachment

select
  attachment,
  count(*)
from
  (
    select
      disk_state,
      case
        when disk_state = 'Unattached' then 'unattached'
        else 'attached'
      end attachment
    from
      azure_compute_disk
  ) as cd
group by
  attachment
order by
  attachment;