Can you tell me the sum of Gain that has the Name of kass, rob, and the Avg/g smaller than 1.9?
CREATE TABLE table_name_75 (gain INTEGER, name VARCHAR, avg_g VARCHAR)
SELECT SUM(gain) FROM table_name_75 WHERE name = "kass, rob" AND avg_g < 1.9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_75 (gain INTEGER, name VARCHAR, avg_g VARCHAR) Question: Can you tell me the sum of Gain that has the Name of kass, rob, and the Avg/g smaller than 1.9? [/INST] SELECT SUM(gain) FROM table_name_75 WHERE name = "kass, rob" AND avg_g < 1.9 </s>