CREATE TABLE table_8864 ("Goal" FLOAT, "Date" CLOB, "Venue" CLOB, "Score" CLOB, "Result" CLOB, "Competition" CLOB)

What was the competition for goal 8?
SELECT "Competition" FROM table_8864 WHERE "Goal" = '8'
SELECT "Competition" FROM "table_8864" WHERE "Goal" = '8'