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"
### Context: CREATE TABLE table_name_97 (long VARCHAR, avg_g VARCHAR) ### Question: Which Long has redshirt for its Avg/G? ### Answer: SELECT long FROM table_name_97 WHERE avg_g = "redshirt"