Query: compute_virtual_machine_scale_set_by_subscription

select
  a.title as "Subscription",
  count(vmss.*) as "Scale Sets"
from
  azure_compute_virtual_machine_scale_set as vmss,
  azure_subscription as a
where
  a.subscription_id = vmss.subscription_id
group by
  a.title
order by
  a.title;