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;