Table: mlb_season_records
Columns: year
franchise
league
percentage
finish

Question: Which Franchise has a Percentage under 0.707, a Year larger than 1931, and the Finish was won 1998 World Series?
SQL: SELECT "franchise" FROM mlb_season_records WHERE "percentage" < 0.707 AND "year" > 1931 AND "finish" = 'won 1998 world series'

Question: What is the average Year for the Finish of lost 2001 alcs and the Percentage is over 0.716?
SQL: SELECT AVG("year") FROM mlb_season_records WHERE "finish" = 'lost 2001 alcs' AND "percentage" > 0.716

Question: In the Year 1939, what was the Finish when Al was the League?
SQL: SELECT "finish" FROM mlb_season_records WHERE "league" = 'al' AND "year" = 1939

Question: What was the Finish when NL was the League, the Percentage was under 0.726, the Year was larger than 1897, and the Franchies was the Pittsburgh Pirates?
SQL: SELECT "finish" FROM mlb_season_records WHERE "league" = 'nl' AND "percentage" < 0.726 AND "year" > 1897 AND "franchise" = 'pittsburgh pirates'