CREATE TABLE table_name_50 (appearances NUMBER, club VARCHAR2, goals VARCHAR2)

How many appearances with fc igea virtus and 1 goal?
SELECT AVG(appearances) FROM table_name_50 WHERE club = "fc igea virtus" AND goals = 1
SELECT AVG("appearances") FROM "table_name_50" WHERE "club" = "fc igea virtus" AND "goals" = 1