Query: redshift_cluster_by_publicly_accessible_status

select
  publicly_accessible_status,
  count(*)
from (
  select publicly_accessible,
    case when publicly_accessible then
      'public'
    else
      'private'
    end publicly_accessible_status
  from
    aws_redshift_cluster) as t
group by
  publicly_accessible_status
order by
  publicly_accessible_status desc;