CREATE TABLE table_name_40 (avg_g VARCHAR2, name VARCHAR2)

What is the total avg/g of McCrary, Greg?
SELECT COUNT(avg_g) FROM table_name_40 WHERE name = "mccrary, greg"
SELECT COUNT("avg_g") FROM "table_name_40" WHERE "mccrary, greg" = "name"