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

Question: What is the total number of points when draw is 4?
SQL: SELECT COUNT("points") FROM primera_division_apertura_2004 WHERE "draw" = 4

Question: what is the goals scored when draw is less than 8, points is 19 and goals conceded is more than 26?
SQL: SELECT SUM("goals_scored") FROM primera_division_apertura_2004 WHERE "draw" < 8 AND "points" = 19 AND "goals_conceded" > 26

Question: what is the points when the goals conceded is less than 24, place is less than 6 and goals scored is less than 26?
SQL: SELECT SUM("points") FROM primera_division_apertura_2004 WHERE "goals_conceded" < 24 AND "place" < 6 AND "goals_scored" < 26

Question: what is the place when losses is less than 12 and points is less than 19?
SQL: SELECT SUM("place") FROM primera_division_apertura_2004 WHERE "lost" < 12 AND "points" < 19

Question: what is the average place when lost is more than 12?
SQL: SELECT AVG("place") FROM primera_division_apertura_2004 WHERE "lost" > 12