What is the total gain for Brandon Mcrae with a loss less than 4, and an Avg/g less than -0.1?
CREATE TABLE table_name_90 (gain VARCHAR, avg_g VARCHAR, long VARCHAR, name VARCHAR)
SELECT COUNT(gain) FROM table_name_90 WHERE long < 4 AND name = "brandon mcrae" AND avg_g < -0.1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_90 (gain VARCHAR, avg_g VARCHAR, long VARCHAR, name VARCHAR) Question: What is the total gain for Brandon Mcrae with a loss less than 4, and an Avg/g less than -0.1? [/INST] SELECT COUNT(gain) FROM table_name_90 WHERE long < 4 AND name = "brandon mcrae" AND avg_g < -0.1 </s>