Table: club_stats
Columns: club
overall_record
goals_for
goals_for_avg
goals_against
goals_against_avg

Question: what is the overall record when the club is dallas burn?
SQL: SELECT "overall_record" FROM club_stats WHERE "club" = 'Dallas Burn'

Question: what is the goals for when the  club is new england revolution?
SQL: SELECT "goals_for" FROM club_stats WHERE "club" = 'New England Revolution'