Player Profile for Al Nanji
Coed - Colonnade Rd

 

Career Coed - Colonnade Rd Scoring Stats

GP	G	A	P	PPG	SHG	GWG	PIM	Stars	P/G
13	1	2	3	0	0	0	0	0	0.23

 

Coed - Colonnade Rd Regular Season Scoring Stats

Team	Season	GP	G	A	P	PPG	SHG	GWG	PIM	Stars	P/G
Freebooters	14W	12	1	2	3	0	0	0	0	0	0.25

 

Coed - Colonnade Rd Playoff Scoring Stats

Team	Season	GP	G	A	P	PPG	SHG	GWG	PIM	Stars	P/G
Freebooters	14W	1	0	0	0	0	0	0	0	0	0.00

 

Overall HTBHL Scoring Stats

League	GP	G	A	P	PPG	SHG	GWG	PIM	Stars	P/G
Coed Orleans - Sunday	22	2	4	6	0	0	0	0	2	0.27
Coed - Colonnade Rd	13	1	2	3	0	0	0	0	0	0.23
Totals	35	3	6	9	0	0	0	0	2	0.26

 

SELECT 'thuma' AS League, CONCAT(FirstName, ' ', LastName) AS Name, Player.PlayerId, Sum(PlayerTeam.GP) AS GP, Sum(PlayerTeam.GW) AS GW, Sum(PlayerTeam.GL) AS GL, Sum(PlayerTeam.GGA) AS GA, (Sum(PlayerTeam.GGA)/Sum(PlayerTeam.GP)) AS GAA, Sum(PlayerTeam.GSA) AS SA, ((Sum(PlayerTeam.GSA)-Sum(PlayerTeam.GGA))/Sum(PlayerTeam.GSA)*100) AS SaveP, Sum(PlayerTeam.SO) AS SO, Sum(PlayerTeam.A) AS A, Sum(PlayerTeam.PIM) AS PIM, Sum(PlayerTeam.Star) AS Star FROM htbhl_thuma.Player, htbhl_thuma.PlayerTeam WHERE Player.PlayerId = PlayerTeam.PlayerId AND PlayerTeam.GP > 0 AND PlayerTeam.Goalie = 'y' AND FirstName = 'Al' AND LastName = 'Nanji' AND GP > 0 GROUP BY PlayerTeam.PlayerId