Top scorers who scored over 30 goals AND had more than 20 penalty minutes (PIM)
SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AVG(PTS) as AveragePoints, AVG(G) AS AverageGoals, AVG(PIM) AS EveragePIM FROM n' at line 1 running query
SELECT * AVG(PTS) as AveragePoints, AVG(G) AS AverageGoals, AVG(PIM) AS EveragePIM FROM nhlstats
WHERE G>=30 AND PIM>20