Query: compute_snapshot_by_network_access_policy_status

select
  status,
  count(*)
from (
  select network_access_policy,
    case
    when network_access_policy = 'AllowPrivate' then 'restricted'
    when network_access_policy = 'AllowAll' then 'unrestricted'
    else 'denied'
    end as status
  from
    azure_compute_snapshot) as cs
group by
  status
order by
  status;