Table: fifa_2010_stats
Columns: stadium
city
capacity
matches_played
overall_attendance
average_attendance_per_match
average_attendance_as_of_capacity
overall_goals_scored
average_goals_scored_per_match
elevation

Question: how many overall goals were scored at moses mabhida stadium?
SQL: SELECT MAX("overall_goals_scored") FROM fifa_2010_stats WHERE "stadium" = 'Moses Mabhida Stadium'

Question: how many matches were played that average goals scored 1.25?
SQL: SELECT COUNT("matches_played") FROM fifa_2010_stats WHERE "average_goals_scored_per_match" = '1.25'

Question: what is the minimum overall attendance where the goals scored were 19?
SQL: SELECT MIN("overall_attendance") FROM fifa_2010_stats WHERE "overall_goals_scored" = 19

Question: what is the elevation for port elizabeth?
SQL: SELECT "elevation" FROM fifa_2010_stats WHERE "city" = 'Port Elizabeth'

Question: what is the average attendance per match wheree the elevation is 1500 m?
SQL: SELECT "average_attendance_per_match" FROM fifa_2010_stats WHERE "elevation" = '1500 m'