Query: network_express_route_circuit_by_peerings

select
  peering,
  count(*)
from
  (
    select
      case
        when jsonb_array_length(peerings) = 0 then 'no peering'
        else 'with peering'
      end as peering
    from
      azure_express_route_circuit
  ) as cd
group by
  peering
order by
  peering;