Query: storage_account_blob_public_access_status

select
  public_access,
  count(*)
from (
  select
    case when allow_blob_public_access then 'public'
    else 'private'
    end public_access
  from
    azure_storage_account) as cd
group by
  public_access
order by
  public_access;