Table: clausura_2008_stats
Columns: place
team
played
draw
lost
goals_scored
goals_conceded
points

Question: Whate place has 18 points with lost less than 8?
SQL: SELECT COUNT("place") FROM clausura_2008_stats WHERE "points" = 18 AND "lost" < 8

Question: What is the average of lost for place less than 10, less than 23 points, and goals conceded less than 26 for the Chorrillo team?
SQL: SELECT AVG("lost") FROM clausura_2008_stats WHERE "place" < 10 AND "points" < 23 AND "team" = 'chorrillo' AND "goals_conceded" < 26

Question: When goals conceded is greater than 17 with 37 points, what is the greatest played?
SQL: SELECT MAX("played") FROM clausura_2008_stats WHERE "points" = 37 AND "goals_conceded" > 17

Question: What is the total points for a place less than 2 with a played greater than 18?
SQL: SELECT SUM("points") FROM clausura_2008_stats WHERE "place" < 2 AND "played" > 18

Question: When goals scored is more than 18, draw is less than 4, and goals conceded is more than 24, what is the sum of played?
SQL: SELECT COUNT("played") FROM clausura_2008_stats WHERE "goals_scored" > 18 AND "draw" < 4 AND "goals_conceded" > 24