Table: league_stats_1911
Columns: position
team
points
played
drawn
lost
against
difference

Question: How many positions have points against less than 28, americano-sp as the team, with a played greater than 8?
SQL: SELECT COUNT("position") FROM league_stats_1911 WHERE "against" < 28 AND "team" = 'americano-sp' AND "played" > 8

Question: How many losses have points against less than 15?
SQL: SELECT COUNT("lost") FROM league_stats_1911 WHERE "against" < 15

Question: What average played has an against less than 15?
SQL: SELECT AVG("played") FROM league_stats_1911 WHERE "against" < 15

Question: How many losses have a played greater than 8, ypiranga-sp as the team, with a position greater than 5?
SQL: SELECT COUNT("lost") FROM league_stats_1911 WHERE "played" > 8 AND "team" = 'ypiranga-sp' AND "position" > 5

Question: What lost has a position greater than 2, a drawn greater than 0, with an against greater than 15?
SQL: SELECT "lost" FROM league_stats_1911 WHERE "position" > 2 AND "drawn" > 0 AND "against" > 15