top scorers whose 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 'FROM dent_hockey.nhlstats
WHERE G >= 30 AND PIM > 20' at line 5 running query
SELECT
AVG(PTS) AS AveragePoints,
AVG(PIM) AS AveragePenalties,
SUM(TOI_Game) AS TotalGameMinutes,
FROM dent_hockey.nhlstats
WHERE G >= 30 AND PIM > 20