question: What is the average medal total when the rank is less than 5 and less than 7 bronze medals were won?
answer: SELECT AVG(total) FROM table_name_64 WHERE rank < 5 AND bronze < 7
context: CREATE TABLE table_name_64 (total INTEGER, rank VARCHAR, bronze VARCHAR)