Query: sql_server_public_status

select
  public_network,
  count(*)
from (
  select
    case when public_network_access = 'Enabled' then 'public'
    else 'private'
    end public_network
  from
    azure_sql_server) as s
group by
  public_network
order by
  public_network;