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

Question: What is the average amount of goals that have a goal difference or 8 and the losses are smaller than 12?
SQL: SELECT AVG("goals_for") FROM football_stats_13 WHERE "goal_difference" = 8 AND "losses" < 12

Question: How many goals have a Lokomotiv Plovdiv club and goals against larger than 58?
SQL: SELECT COUNT("goals_for") FROM football_stats_13 WHERE "club" = 'lokomotiv plovdiv' AND "goals_against" > 58

Question: What is the average goal difference using slavia sofia club?
SQL: SELECT AVG("goal_difference") FROM football_stats_13 WHERE "club" = 'slavia sofia'

Question: What is the played average that has botev plovdiv as the club and wins larger than 11?
SQL: SELECT AVG("played") FROM football_stats_13 WHERE "club" = 'botev plovdiv' AND "wins" > 11