Query: vpc_default_security_group_status

with default_sg as (
  select
    group_id,
    case when group_name = 'default' then true else false end as is_default
  from
    aws_vpc_security_group
)
select
  case
    when is_default then 'default'
    else 'non-default'
  end as default_status,
  count(*)
from
  default_sg
group by is_default;