Table: fifa_world_cup_english
Columns: player
club
qualifying_goals
finals_goals
total_goals

Question: What is the Average Qualifying Goals for Jack Froggatt where the Final Goals is greater than 0?
SQL: SELECT AVG("qualifying_goals") FROM fifa_world_cup_english WHERE "player" = 'jack froggatt' AND "finals_goals" > 0

Question: Which Player has a Total Goals greater than 1 and Qualifying Goals smaller than 3?
SQL: SELECT "player" FROM fifa_world_cup_english WHERE "total_goals" > 1 AND "qualifying_goals" < 3

Question: What is the total number of Total Goals scored by Stan Mortensen where the Qualifying Goals is greater than 3?
SQL: SELECT COUNT("total_goals") FROM fifa_world_cup_english WHERE "player" = 'stan mortensen' AND "qualifying_goals" > 3

Question: What is the Average Finals Goals if the Total Goals is less than 1?
SQL: SELECT AVG("finals_goals") FROM fifa_world_cup_english WHERE "total_goals" < 1