CREATE TABLE table_name_26 (goals INT, result VARCHAR)

How many Goals have a Result of 0 4?
SELECT AVG(goals) FROM table_name_26 WHERE result = "0 – 4"
SELECT AVG("goals") FROM "table_name_26" WHERE "0 – 4" = "result"