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

Question: Name the sum of played for c.d. luis ángel firpo and place more than 3
SQL: SELECT SUM("played") FROM primera_apertura_2005 WHERE "team" = 'c.d. luis ángel firpo' AND "place" > 3

Question: Name the total number of places which has played more than 18
SQL: SELECT COUNT("place") FROM primera_apertura_2005 WHERE "played" > 18

Question: Name the total number of lost when goals scored is less than 22 and goals conceded is more than 27
SQL: SELECT COUNT("lost") FROM primera_apertura_2005 WHERE "goals_scored" < 22 AND "goals_conceded" > 27

Question: Name the average goals conceded with draw bigger than 7 and goals scored more than 24
SQL: SELECT AVG("goals_conceded") FROM primera_apertura_2005 WHERE "draw" > 7 AND "goals_scored" > 24

Question: Name the least goals scored with place more than 8 and lost less than 8
SQL: SELECT MIN("goals_scored") FROM primera_apertura_2005 WHERE "place" > 8 AND "lost" < 8