It worked before I migrated and I actually migrated to the same company just a new personal account
SELECT teamcon.Driver, teamcon.Hometown, teamcon.seqnumb, SUM(PassResults.finish) AS Wins, COUNT(PassResults.RaceID) AS Races
FROM PassResults
INNER JOIN PassSchedule AS schedcon ON (schedcon.RaceID = PassResults.RaceID) INNER JOIN Teams AS teamcon ON (teamcon.seqnumb = PassResults.TeamLink)
WHERE PassResults.finish = 1 AND schedcon.season = :P1
GROUP BY teamcon.Driver, teamcon.Hometown
ORDER BY Wins DESC
SELECT
teamcon.Driver,
teamcon.Hometown,
teamcon.seqnumb,
SUM(PassResults.finish) AS Wins,
COUNT(PassResults.RaceID) AS Races
FROM PassResults
INNER JOIN PassSchedule AS schedcon ON schedcon.RaceID = PassResults.RaceID
INNER JOIN Teams AS teamcon ON teamcon.seqnumb = PassResults.TeamLink
WHERE PassResults.finish = 1
AND schedcon.season = :P1
GROUP BY teamcon.Driver, teamcon.Hometown, teamcon.seqnumb
ORDER BY Wins DESC;
so that the teamcon.seqnumb is also in the groupby.