Query: ibm_is_security_group_by_resource_group

select
  resource_group ->> 'name' as "Resource Group",
  count(*) as "security_groups"
from
  ibm_is_security_group
group by
  resource_group ->> 'name'
order by
  resource_group ->> 'name';