Table: hartlepool_managers
Columns: nationality
matches
drawn
lost
win

Question: Nationality of england, and a Matches smaller than 510, and a Lost of 4, and a Win % smaller than 28.6 had what lowest drawn?
SQL: SELECT MIN("drawn") FROM hartlepool_managers WHERE "nationality" = 'england' AND "matches" < 510 AND "lost" = 4 AND "win" < 28.6

Question: Win % larger than 47.1, and a Matches smaller than 145 had what lowest lost?
SQL: SELECT MIN("lost") FROM hartlepool_managers WHERE "win" > 47.1 AND "matches" < 145

Question: Matches of 15, and a Win % smaller than 20 had what highest lost?
SQL: SELECT MAX("lost") FROM hartlepool_managers WHERE "matches" = 15 AND "win" < 20

Question: Nationality of england, and a Lost larger than 39, and a Win % of 28.7, and a Drawn smaller than 37 had what sum of matches?
SQL: SELECT SUM("matches") FROM hartlepool_managers WHERE "nationality" = 'england' AND "lost" > 39 AND "win" = 28.7 AND "drawn" < 37

Question: Drawn smaller than 24, and a Lost smaller than 17, and a Win % smaller than 31.25 had how many total number of matches?
SQL: SELECT COUNT("matches") FROM hartlepool_managers WHERE "drawn" < 24 AND "lost" < 17 AND "win" < 31.25

Question: Lost of 18 had what sum of win %?
SQL: SELECT SUM("win") FROM hartlepool_managers WHERE "lost" = 18