Table: league_stats_2005
Columns: position
team
played
wins
draws
losses
scored
conceded
points

Question: What is the average conceded number of the team with a position lower than 8 and more than 2 wins?
SQL: SELECT AVG("conceded") FROM league_stats_2005 WHERE "position" > 8 AND "wins" > 2

Question: What is the averaged scored number of team guaraní, which has less than 6 draws and less than 5 losses?
SQL: SELECT AVG("scored") FROM league_stats_2005 WHERE "draws" < 6 AND "team" = 'guaraní' AND "losses" < 5

Question: What is the total number scored of the team positioned lower than 10?
SQL: SELECT COUNT("scored") FROM league_stats_2005 WHERE "position" > 10

Question: What is the lowest number of wins of the team with less than 24 scored, 27 conceded, and more than 18 played?
SQL: SELECT MIN("wins") FROM league_stats_2005 WHERE "scored" < 24 AND "conceded" = 27 AND "played" > 18

Question: What is the lowest number of points of the team with 2 losses and a lower than 1 position?
SQL: SELECT MIN("points") FROM league_stats_2005 WHERE "losses" = 2 AND "position" > 1