How to get the pivot result for these 3 tables ?

;with mycte as
(SELECT p.CountryCode AS 'Country',
CASE WHEN e.EventCode = 'TournReg' THEN COUNT(e.EventCode)
ELSE 0 
END AS 'Registered Players'
FROM EventType AS e
INNER JOIN BalanceAudit AS b ON e.EventTypeID = b.EventTypeID
INNER JOIN Player AS p ON b.PlayerID = p.PlayerID
WHERE b.EventDateTime BETWEEN '2013-09-01' AND '2013-09-30'
GROUP BY p.CountryCode, e.EventCode) 

select * from mycte src Pivot (Max([Registered Players]) For [Country] IN ([DNK],[KOR],[SWE])) pvt