Query: network_express_route_circuit_by_service_provider_provisioning_state

select
  service_provider_provisioning_state as "Service Provider Provisioning State",
  count(*) as "Express Route Circuits"
from
  azure_express_route_circuit
group by
  service_provider_provisioning_state
order by
  service_provider_provisioning_state;