What is the total number of E scores when the total score was 19.7 and the A score was more than 6?
CREATE TABLE table_name_49 (
    e_score VARCHAR,
    total VARCHAR,
    a_score VARCHAR
)
SELECT COUNT(e_score) FROM table_name_49 WHERE total = 19.7 AND a_score > 6
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 total number of E scores when the total score was 19.7 and the A score was more than 6? ### Input: CREATE TABLE table_name_49 (
    e_score VARCHAR,
    total VARCHAR,
    a_score VARCHAR
) ### Response: SELECT COUNT(e_score) FROM table_name_49 WHERE total = 19.7 AND a_score > 6