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"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (avg_g VARCHAR, name VARCHAR) Question: What is the total avg/g of McCrary, Greg? [/INST] SELECT COUNT(avg_g) FROM table_name_40 WHERE name = "mccrary, greg" </s>