Player Profile for Carl Ernest
Men's Arena - Dulude/Pinecrest (Thurs)
| GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
|---|---|---|---|---|---|---|---|---|---|
| 10 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0.10 |
| Team | Season | GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Goblins | 23S | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0.10 |
| League | GP | G | A | P | PPG | SHG | GWG | PIM | Stars | P/G |
|---|---|---|---|---|---|---|---|---|---|---|
| Coed Gym - Kanata (Fri) | 17 | 27 | 18 | 45 | 2 | 0 | 3 | 12 | 15 | 2.65 |
| Men's Gym - Hintonburg (Sun) | 17 | 9 | 11 | 20 | 1 | 0 | 1 | 16 | 4 | 1.18 |
| Men's Gym - Alta Vista (Sun) | 6 | 4 | 4 | 8 | 1 | 0 | 0 | 0 | 2 | 1.33 |
| Men's Arena - St Laurent (Sun) | 7 | 2 | 6 | 8 | 0 | 0 | 0 | 2 | 1 | 1.14 |
| Men's Gym - Kanata (Mon/Wed) | 4 | 0 | 5 | 5 | 0 | 0 | 0 | 6 | 0 | 1.25 |
| Men's Arena - Dulude/Pinecrest (Thurs) | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0.10 |
| Totals | 61 | 43 | 44 | 87 | 4 | 0 | 4 | 38 | 22 | 1.43 |
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 = 'Carl' AND LastName = 'Ernest' AND GP > 0 GROUP BY PlayerTeam.PlayerId