What is the number of averages having a balls faced over 297 and more than 7 innings?
CREATE TABLE table_name_34 (average VARCHAR, balls_faced VARCHAR, innings VARCHAR)
SELECT COUNT(average) FROM table_name_34 WHERE balls_faced > 297 AND innings > 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_34 (average VARCHAR, balls_faced VARCHAR, innings VARCHAR) Question: What is the number of averages having a balls faced over 297 and more than 7 innings? [/INST] SELECT COUNT(average) FROM table_name_34 WHERE balls_faced > 297 AND innings > 7 </s>