Query: rds_db_cluster_multiple_az_status

with multiaz_enabled as (
  select
    distinct db_cluster_identifier as name
  from
    aws_rds_db_cluster
  where
    multi_az
  group by
    name
),
multiaz_status as (
  select
    case
      when c.name is not null then 'enabled'
      else 'disabled'
    end as multiaz_stat
  from
    aws_rds_db_cluster as r
    left join multiaz_enabled as c on r.db_cluster_identifier = c.name
)
select
  multiaz_stat,
  count(*)
from
  multiaz_status
group by
  multiaz_stat;