Name the average with tally of 0-29 and total more than 29
CREATE TABLE table_name_40 (average INTEGER, tally VARCHAR, total VARCHAR)
SELECT AVG(average) FROM table_name_40 WHERE tally = "0-29" AND total > 29
### Context: CREATE TABLE table_name_40 (average INTEGER, tally VARCHAR, total VARCHAR) ### Question: Name the average with tally of 0-29 and total more than 29 ### Answer: SELECT AVG(average) FROM table_name_40 WHERE tally = "0-29" AND total > 29