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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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 [/INST] SELECT AVG(average) FROM table_name_40 WHERE tally = "0-29" AND total > 29 </s>