Which Long has redshirt for its Avg/G?
CREATE TABLE table_name_97 (long VARCHAR, avg_g VARCHAR)
SELECT long FROM table_name_97 WHERE avg_g = "redshirt"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (long VARCHAR, avg_g VARCHAR) Question: Which Long has redshirt for its Avg/G? [/INST] SELECT long FROM table_name_97 WHERE avg_g = "redshirt" </s>