Query: ibm_is_vpc_empty_status

with by_empty as (
  select
    vpc.id,
    case
      when s.id is null then 'empty'
      else 'non-empty'
    end as status
  from
    ibm_is_vpc as vpc
    left join ibm_is_subnet as s on vpc.id = s.vpc ->> 'id'
)
select
  status,
  count(*)
from
  by_empty
group by
  status;