Table: player_stats_2007
Columns: player
car
yards
avg
td_s
long

Question: Tell me the long for TD's of 4
SQL: SELECT "long" FROM player_stats_2007 WHERE "td_s" = 4

Question: Tell me the long for charles frederick
SQL: SELECT "long" FROM player_stats_2007 WHERE "player" = 'charles frederick'

Question: Tell me the average for 1 yards
SQL: SELECT "avg" FROM player_stats_2007 WHERE "yards" = '1'

Question: Tell me the sum of TD's for 4 avg.
SQL: SELECT SUM("td_s") FROM player_stats_2007 WHERE "avg" = '4'