WCHLSIM.com - West Coast Hockey League
JOUEUR TEAM PAYS GP GS W L OTL PCT GAA MP PIM SO GA SA SV A Unknown column 'goalies.goalies.Shutouts' in 'order clause'
SELECT *,sum((goalies.SA - goalies.GA) / goalies.SA) as totalpct, sum(goalies.GA / (goalies.MIN / 3600)) as totalavg, sum(goalies.SA - goalies.GA) AS SV FROM goalies, teams WHERE Teamg = tnumber AND TeamName LIKE '%' AND Rookie != '0' AND goalies.year = '2023-2024' AND Country LIKE '%' AND goalies.GP != 0 GROUP BY Nameg ORDER BY goalies.`goalies.Shutouts` DESC, goalies.GP DESC LIMIT 0, 50