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;