Table: arthur_chandler_period_1923
Columns: name
period
league
fa_cup
league_cup
other
total
apps
goal_ratio

Question: What's the Highest Goal Ratio with a League of 88 and an FA Cup less than 7?
SQL: SELECT MAX("goal_ratio") FROM arthur_chandler_period_1923 WHERE "league" = 88 AND "fa_cup" < 7

Question: What's the highest FA Cup with the Name of Alan Smith, and League Cup smaller than 4?
SQL: SELECT MAX("fa_cup") FROM arthur_chandler_period_1923 WHERE "name" = 'alan smith' AND "league_cup" < 4

Question: What's the lowest Total thats got an FA Cup larger than 10, Name of Arthur Chandler, and a League Cup thats larger than 0?
SQL: SELECT MIN("total") FROM arthur_chandler_period_1923 WHERE "fa_cup" > 10 AND "name" = 'arthur chandler' AND "league_cup" > 0