Table schema:
CREATE TABLE table_name_97 (long VARCHAR, avg_g VARCHAR)

Question: Which Long has redshirt for its Avg/G?
SQL: SELECT long FROM table_name_97 WHERE avg_g = "redshirt"