Query: vpc_flow_logs_status

with vpc_logs as (
  select
    vpc_id,
    case
      when vpc_id in (
        select
          resource_id
        from
          aws_vpc_flow_log
      ) then 'enabled'
      else 'disabled'
    end as flow_logs_configured
  from
    aws_vpc
)
select
  flow_logs_configured,
  count(*)
from
  vpc_logs
group by
  flow_logs_configured;