Table: no_coach
Columns: name
years
wins
losses
ties
pct

Question: Which percent has Wins larger than 72, and a Name of john yovicsin?
SQL: SELECT SUM("pct") FROM no_coach WHERE "wins" > 72 AND "name" = 'john yovicsin'

Question: How many Ties have Years of 1919–1925, and a Pct larger than 0.734?
SQL: SELECT SUM("ties") FROM no_coach WHERE "years" = '1919–1925' AND "pct" > 0.734

Question: Which Pct has Years of 1957–1970, and Wins smaller than 78?
SQL: SELECT SUM("pct") FROM no_coach WHERE "years" = '1957–1970' AND "wins" < 78

Question: Which Wins have Years of 1881, and a Pct larger than 0.75?
SQL: SELECT AVG("wins") FROM no_coach WHERE "years" = '1881' AND "pct" > 0.75