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;