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;