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;