WITH Winners(GameID, PlayerNick) AS
(
	SELECT g.GameID, w.PlayerNick
	FROM dbo.Games AS g
	CROSS APPLY fGameWinner(g.GameID) AS w
	WHERE g.GameID IN
	(
		SELECT g.GameID FROM Games AS g
		INNER JOIN GameEntries AS ge1
		ON ge1.GameID = g.GameID
		INNER JOIN GameEntries AS ge2
		ON ge2.GameID = g.GameID
		INNER JOIN vPlayerPerGame AS ppg
		ON ppg.GameID = g.GameID
		WHERE ge1.PlayerNick = 'Jostein'
		AND ge2.PlayerNick = 'tavi'
		AND ppg.Players = 2
	)
)
SELECT     PlayerNick, COUNT(GameID) AS 'Wins'
 FROM         Winners
 GROUP BY PlayerNick


-- RESULTS

Jostein	33
tavi	36