Table: top_football_scorers
Columns: rank
name
years
matches
goals
goals_matches

Question: What average goals have matches less than 228?
SQL: SELECT AVG("goals") FROM top_football_scorers WHERE "matches" < 228

Question: How many goals/matches have 153 as the goals with matches greater than 352?
SQL: SELECT SUM("goals_matches") FROM top_football_scorers WHERE "goals" = 153 AND "matches" > 352

Question: What are the lowest goal that have goals/matches greater than 0.43 with joachim streich as the name and matches greater than 378?
SQL: SELECT MIN("goals") FROM top_football_scorers WHERE "goals_matches" > 0.43 AND "name" = 'joachim streich' AND "matches" > 378

Question: What years have goals less than 229, and 440 as matches?
SQL: SELECT "years" FROM top_football_scorers WHERE "goals" < 229 AND "matches" = 440