Table: g_mcelroy_stats
Columns: season
gp_gs
yards
long
avg_g

Question: What was the GP-GS for the 2009 season?
SQL: SELECT "gp_gs" FROM g_mcelroy_stats WHERE "season" = '2009'

Question: Which GP-GS had a long of 17 and a season of total?
SQL: SELECT "gp_gs" FROM g_mcelroy_stats WHERE "long" = '17' AND "season" = 'total'

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

Question: What was the Av/G of the 2009 season?
SQL: SELECT "avg_g" FROM g_mcelroy_stats WHERE "season" = '2009'

Question: For the Avg/G of 5.9, what was the long?
SQL: SELECT "long" FROM g_mcelroy_stats WHERE "avg_g" = '5.9'