CREATE TABLE table_name_50 (goals_for NUMBER, played VARCHAR2, goals_against VARCHAR2, position VARCHAR2, losses VARCHAR2)

what is the sum of goals for when the position is less than 8, the losses is less than 10 the goals against is less than 35 and played is less than 38?
SELECT SUM(goals_for) FROM table_name_50 WHERE position < 8 AND losses < 10 AND goals_against < 35 AND played < 38
SELECT SUM("goals_for") FROM "table_name_50" WHERE "goals_against" < 35 AND "losses" < 10 AND "played" < 38 AND "position" < 8