Query: network_express_route_circuit_by_subscription

select
  sub.title as "Subscription",
  count(n.*) as "Express Route Circuits"
from
  azure_express_route_circuit as n,
  azure_subscription as sub
where
  sub.subscription_id = n.subscription_id
group by
  sub.title
order by
  sub.title;