Query: ram_groups_without_policies

with groups_without_policies as (
  select
    title,
    case
      when jsonb_array_length(attached_policy) = 0 then 'no policies'
      else 'with policies'
    end as has_policies
  from
    alicloud_ram_group
  )
  select
    has_policies,
    count(*)
  from
    groups_without_policies
  group by
    has_policies;