CREATE TABLE table_name_97 (long VARCHAR, avg_g VARCHAR)

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