Query: iam_groups_without_users

with groups_without_users as (
  select
    arn,
    case
      when users is null then 'no users'
      else 'with users'
    end as has_users
  from
    aws_iam_group
)
select
  has_users,
  count(*)
from
  groups_without_users
group by
  has_users;