Query: ibm_compute_instance_by_resource_group

select
  resource_group ->> 'name' as "Resource Group",
  count(i.*) as total
from
  ibm_is_instance as i
group by
  resource_group ->> 'name';