CREATE TABLE table_name_50 (goals_for INTEGER, wins VARCHAR(255), losses VARCHAR(255))
How many goals for were scored for the team(s) that won fewer than 4 games and lost more than 6?
    
SQL: SELECT SUM(goals_for) FROM table_name_50 WHERE wins < 4 AND losses > 6