Table: player_stats_2007
Columns: player
rec
yards
avg
td_s
long

Question: When the Long is 42, what is the average TD's?
SQL: SELECT AVG("td_s") FROM player_stats_2007 WHERE "long" = '42'

Question: Which Rec has Jerel Myers as the Player?
SQL: SELECT "rec" FROM player_stats_2007 WHERE "player" = 'jerel myers'