CREATE TABLE table_52682 ("Division" CLOB, "League Apps  ( Sub ) " FLOAT, "League Goals" FLOAT, "FA Cup Apps  ( Sub ) " CLOB, "FA Cup Goals" FLOAT, "FL Cup Apps  ( Sub ) " FLOAT, "FL Cup Goals" FLOAT, "Other Apps" FLOAT, "Other Goals" FLOAT, "Total Apps  ( Sub ) " CLOB, "Total Goals" FLOAT)

What is Division One's average Other Apps, with a League Goal less than 1?
SELECT AVG("Other Apps") FROM table_52682 WHERE "Division" = 'one' AND "League Goals" < '1'
SELECT AVG("Other Apps") FROM "table_52682" WHERE "Division" = 'one' AND "League Goals" < '1'