CREATE TABLE table_name_50 (goals_for NUMBER, wins VARCHAR2, losses VARCHAR2)

How many goals for were scored for the team(s) that won fewer than 4 games and lost more than 6?
SELECT SUM(goals_for) FROM table_name_50 WHERE wins < 4 AND losses > 6
SELECT SUM("goals_for") FROM "table_name_50" WHERE "losses" > 6 AND "wins" < 4