CREATE TABLE table_name_41 (goals NUMBER, apps NUMBER)

Which Goals have Apps smaller than 1?
SELECT AVG(goals) FROM table_name_41 WHERE apps < 1
SELECT AVG("goals") FROM "table_name_41" WHERE "apps" < 1