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
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 number of averages having a balls faced over 297 and more than 7 innings? ### Input: CREATE TABLE table_name_34 (
    average VARCHAR,
    balls_faced VARCHAR,
    innings VARCHAR
) ### Response: SELECT COUNT(average) FROM table_name_34 WHERE balls_faced > 297 AND innings > 7