Query: activedirectory_group_with_no_member

select
  case when jsonb_array_length(member_ids) = 0  then 'no members' else 'with members' end as status,
  count(*)
from
  azuread_group
group by
  status;