CREATE TABLE table_name_98 (attendance NUMBER, score VARCHAR2)

How many Attendance in a match which scores 0:0 - 4:1 (pen)
SELECT AVG(attendance) FROM table_name_98 WHERE score = "0:0 - 4:1 (pen)"
SELECT AVG("attendance") FROM "table_name_98" WHERE "0:0 - 4:1 (pen)" = "score"