What is the average Gold, when Silver is less than 107, when Bronze is greater than 42, and when Rank is 3?
CREATE TABLE table_name_95 (
    gold INTEGER,
    rank VARCHAR,
    silver VARCHAR,
    bronze VARCHAR
)
SELECT AVG(gold) FROM table_name_95 WHERE silver < 107 AND bronze > 42 AND rank = "3"
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 the average Gold, when Silver is less than 107, when Bronze is greater than 42, and when Rank is 3? ### Input: CREATE TABLE table_name_95 (
    gold INTEGER,
    rank VARCHAR,
    silver VARCHAR,
    bronze VARCHAR
) ### Response: SELECT AVG(gold) FROM table_name_95 WHERE silver < 107 AND bronze > 42 AND rank = "3"