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;