Query: ibm_is_security_group_unassociated_status

with associated_sg as (
  select
    case when jsonb_array_length(targets) = 0 then 'unassociated' else 'associated' end as association
  from
    ibm_is_security_group
)
select
  association,
  count(*)
from
  associated_sg
group by
 association;