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;