What is the average medal total when the rank is less than 5 and less than 7 bronze medals were won?
CREATE TABLE table_name_64 (
    total INTEGER,
    rank VARCHAR,
    bronze VARCHAR
)
SELECT AVG(total) FROM table_name_64 WHERE rank < 5 AND bronze < 7
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 medal total when the rank is less than 5 and less than 7 bronze medals were won? ### Input: CREATE TABLE table_name_64 (
    total INTEGER,
    rank VARCHAR,
    bronze VARCHAR
) ### Response: SELECT AVG(total) FROM table_name_64 WHERE rank < 5 AND bronze < 7