Query: compute_virtual_machine_scale_set_by_resource_group

select
  resource_group || ' [' || sub.title || ']' as "Resource Group",
  count(s.*) as "Scale Sets"
from
  azure_compute_virtual_machine_scale_set as s,
  azure_subscription as sub
where
   s.subscription_id = sub.subscription_id
group by
  resource_group, sub.title
order by
  resource_group;