Query: ibm_compute_instance_by_account

select
  a.name as "account",
  count(i.*) as "Total"
from
  ibm_is_instance as i,
  ibm_account as a
where
  a.customer_id = i.account_id
group by
  account
order by
  count(i.*) desc;