CREATE TABLE table_name_6 (goals VARCHAR2, player VARCHAR2)

How many goals does Mike Eruzione have in total?
SELECT goals FROM table_name_6 WHERE player = "mike eruzione"
SELECT "goals" FROM "table_name_6" WHERE "mike eruzione" = "player"