Table: french_div2_1992
Columns: rank
club
points
played
victories
draws
defeats
goals_for
goals_against
goal_average

Question: What is the highest amount of points with a goal average larger than 4, less than 12 draws, and a goal of 63?
SQL: SELECT MAX("points") FROM french_div2_1992 WHERE "goal_average" > 4 AND "draws" < 12 AND "goals_for" = 63

Question: What is the lowest goal for a goal against 37 and less than 15 victories?
SQL: SELECT MIN("goals_for") FROM french_div2_1992 WHERE "goals_against" = 37 AND "victories" < 15

Question: How many goals on average are there for rank 3?
SQL: SELECT AVG("goals_for") FROM french_div2_1992 WHERE "rank" = 3