Query: ram_groups_without_users

with groups_without_users as (
  select
    title,
    case
      when users = '[]' then 'no users'
      else 'with users'
    end as has_users
  from
    alicloud_ram_group
)
select
  has_users,
  count(*)
from
  groups_without_users
group by
  has_users;