What is the total avg/g of McCrary, Greg?
CREATE TABLE table_name_40 (
    avg_g VARCHAR,
    name VARCHAR
)
SELECT COUNT(avg_g) FROM table_name_40 WHERE name = "mccrary, greg"
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 avg/g of McCrary, Greg? ### Input: CREATE TABLE table_name_40 (
    avg_g VARCHAR,
    name VARCHAR
) ### Response: SELECT COUNT(avg_g) FROM table_name_40 WHERE name = "mccrary, greg"