Query: ebs_snapshot_by_public_status

with public_status as (
  select
    case
      when create_volume_permissions @> '[{"Group": "all"}]' then 'public'
      else 'private'
    end as visibility
  from
    aws_ebs_snapshot
)
select
  visibility,
  count(*)
from
  public_status
group by
  visibility;