What is Division One's average Other Apps, with a League Goal less than 1?
CREATE TABLE table_name_76 (
    other_apps INTEGER,
    division VARCHAR,
    league_goals VARCHAR
)
SELECT AVG(other_apps) FROM table_name_76 WHERE division = "one" AND league_goals < 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is Division One's average Other Apps, with a League Goal less than 1? ### Input: CREATE TABLE table_name_76 (
    other_apps INTEGER,
    division VARCHAR,
    league_goals VARCHAR
) ### Response: SELECT AVG(other_apps) FROM table_name_76 WHERE division = "one" AND league_goals < 1