Query: ibm_is_security_group_by_acount

select
  a.name as "account",
  count(s.*) as "security_groups"
from
  ibm_is_security_group as s,
  ibm_account as a
where
  a.customer_id = s.account_id
group by
  account
order by
  account;