which Name has a Loss larger than 2, and a Avg/G larger than -16, and a GP-GS of 11–7, and a Gain larger than 86?
CREATE TABLE table_name_23 (name VARCHAR, gain VARCHAR, gp_gs VARCHAR, loss VARCHAR, avg_g VARCHAR)
SELECT name FROM table_name_23 WHERE loss > 2 AND avg_g > -16 AND gp_gs = "11–7" AND gain > 86
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (name VARCHAR, gain VARCHAR, gp_gs VARCHAR, loss VARCHAR, avg_g VARCHAR) Question: which Name has a Loss larger than 2, and a Avg/G larger than -16, and a GP-GS of 11–7, and a Gain larger than 86? [/INST] SELECT name FROM table_name_23 WHERE loss > 2 AND avg_g > -16 AND gp_gs = "11–7" AND gain > 86 </s>