Table: segunda_division_standings_6
Columns: position
played
points
wins
draws
losses
goals_for
goals_against
goal_difference

Question: What is the highest goals for the position after 10, a goal difference less than -24, and played more than 30 times?
SQL: SELECT MAX("goals_for") FROM segunda_division_standings_6 WHERE "position" > 10 AND "goal_difference" < -24 AND "played" > 30

Question: What is the lowest goals for more than 30 games played?
SQL: SELECT MIN("goals_for") FROM segunda_division_standings_6 WHERE "played" > 30

Question: What is the highest amount of goals in the position after 8, 12 losses, and played less than 30 games?
SQL: SELECT MAX("goals_for") FROM segunda_division_standings_6 WHERE "position" > 8 AND "losses" = 12 AND "played" < 30

Question: What is the total number of losses for the over 30 games played?
SQL: SELECT COUNT("losses") FROM segunda_division_standings_6 WHERE "played" > 30

Question: What is the total number of losses and draws less than 7, points larger than 26, 60 goals, and a position before 4?
SQL: SELECT COUNT("losses") FROM segunda_division_standings_6 WHERE "draws" < 7 AND "points" > 26 AND "goals_for" = 60 AND "position" < 4