Long ตัวไหนมีเสื้อแดงสำหรับ Avg/G?ไม่จำเป็นต้องใช้ทุกโต๊ะ
Which Long has redshirt for its Avg/G?It is not neccessary to use all the tables.
 table_name_97:  (long [ VARCHAR ] avg_g [ VARCHAR) ]
SELECT long FROM table_name_97 WHERE avg_g = "redshirt"