Query: ram_users_with_direct_attached_policy

with direct_attached_policies as (
  select
    case
      when jsonb_array_length(attached_policy) > 0 then 'with attached policies'
      else 'no attached policies'
    end as has_attached
  from
    alicloud_ram_user
)
select
  has_attached,
  count(*)
from
  direct_attached_policies
group by
  has_attached;