Query: ibm_is_security_group_by_vpc

select
  vpc ->> 'id' as "VPC",
  count(*) as "security_groups"
from
  ibm_is_security_group
group by
  vpc ->> 'id'
order by
  vpc ->> 'id';