Select only first place in the first half - SQL Server Code

Question

I made this code for SQL Server to select how many times the driver "Asdovolante" came first in the first half of 2017. But it doesn’t work. What may be wrong?

SELECT P.Data, Nm.Nome, epp.PosicaoFinal
FROM Prova P, Piloto Nm, EquipaParticipaProva epp
WHERE epp.PosicaoFinal = (SELECT PosicaoFinal FROM EquipaParticipaProva where PosicaoFinal = 1)
HAVING Nm.Nome ='AsdoVolante' AND P.Data BETWEEN '2017-01-01' AND '2017-06-30';

Answer 1

You have to first check which error is displaying.

Anyway, try the select below: SELECT P.Data, Nm.Name, Epp.Posiofinal FROM Prova P, Piloto Nm, Equipaparticipaprova Epp WHERE Epp.Posicaofinal = 1 AND Nm.Name ='Asdovolante' AND P.Date BETWEEN '2017-01-01' AND '2017-06-30';

Answer 2

SELECT P.Data, Nm.Nome, epp.PosicaoFinal
FROM Prova P, Piloto Nm, EquipaParticipaProva epp
WHERE epp.PosicaoFinal = (SELECT epp.PosicaoFinal FROM EquipaParticipaProva where epp.PosicaoFinal = 1)
HAVING Nm.Nome ='AsdoVolante' AND P.Data BETWEEN '2017-01-01' AND '2017-06-30';

Answer 3

You can obtain such information by linking the information with JOIN and restricting in WHERE:

SELECT Nm.Nome,
       COUNT(epp.PosicaoFinal) AS quantidade
  FROM Prova P
       INNER JOIN EquipaParticipaProva epp ON epp.IdProva = P.IdProva
       INNER JOIN Piloto Nm ON epp.IdPiloto = epp.IdPiloto
 WHERE epp.PosicaoFinal = 1
   and Nm.Nome = 'AsdoVolante'
   and P.Data BETWEEN '2017-01-01' AND '2017-06-30';
 GROUP BY Nm.Nome