Fórum Pessoal, como posso fazer 2 SELECT no SQL sendo que vai ter dois COUNT separando o resultado em duas colunas? #592823

$sql = "SELECT DISTINCT
    production.Nome, CASE WHEN ContaSegmentoOutros.QtdeOutros IS NULL THEN 0 ELSE ContaSegmentoOutros.QtdeOutros END AS Outros, 
    CASE WHEN ContaSegmentoPrivado.QtdePrivado IS NULL THEN 0 ELSE ContaSegmentoPrivado.QtdePrivado END AS Privado
FROM production LEFT OUTER JOIN
    (SELECT Nome, Segmento, COUNT(Segmento) AS QtdeOutros
        FROM production
        WHERE (Segmento = 'Outros')
        GROUP BY Nome, Segmento) AS ContaSegmentoOutros ON ContaSegmentoOutros.Nome = production.Nome LEFT OUTER JOIN
    (SELECT Nome, Segmento, COUNT(Segmento) AS QtdePrivado
    FROM production
    WHERE (Segmento = 'Privado')
    GROUP BY Nome, Segmento) AS ContaSegmentoPrivado ON ContaSegmentoPrivado.Nome = production.Nome";
$result = $conexao->query($sql);
while ($row = $result->fetch()){
  echo "<tr><td>" . $row['Nome'] . "</td>
        <td>" . $row['QtdeOutros'] . "</td>
        <td>" . $row['QtdePrivado'] . "</td>
        <td>" . "Abril" . "</td></tr></span>";
}

$sql = "SELECT Nome, COUNT(Segmento) AS qtd FROM production WHERE [Segmento] = 'Outros' GROUP BY Nome";
$result = $conexao->query($sql);
while ($row = $result->fetch()){
  echo "<tr><td>". $row['Nome'] . "</td>
        <td>" . $row['qtd'] . "</tr></span>";
}

echo "</table>";
?>

TRANSFORM Count(production.[Código]) AS ContarDeCódigo
SELECT production.[Nome]
FROM production
GROUP BY production.[Nome]
PIVOT production.[Segmento];

$sql = "SELECT Nome, SUM([Segmento] = 'Privado') AS qtd, SUM([Segmento] = 'Outros') AS qtd2 FROM tb_nova_production GROUP BY Nome";
  
$result = $conexao->query($sql);
while ($row = $result->fetch()){
  echo "<tr><td>" . $row[''Nome''] . "</td>
        <td>" . $row[''qtd'']  . "</td>
        <td>" . $row[''qtd2'']  . "</td></tr></span>";
}