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;