What is the average gold medals for countries with more than 0 bronze, more than 0 silver, rank over 2 and total over 3?
CREATE TABLE table_name_56 (
    gold INTEGER,
    total VARCHAR,
    rank VARCHAR,
    bronze VARCHAR,
    silver VARCHAR
)
SELECT AVG(gold) FROM table_name_56 WHERE bronze > 0 AND silver > 0 AND rank > 2 AND total > 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 medals for countries with more than 0 bronze, more than 0 silver, rank over 2 and total over 3? ### Input: CREATE TABLE table_name_56 (
    gold INTEGER,
    total VARCHAR,
    rank VARCHAR,
    bronze VARCHAR,
    silver VARCHAR
) ### Response: SELECT AVG(gold) FROM table_name_56 WHERE bronze > 0 AND silver > 0 AND rank > 2 AND total > 3