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;