Table: chester_fc_history
Columns: year
league
position
leading_scorer
goals

Question: Leading Scorer that has a Goal smaller than 23, and a League of football league division 3, and a Year of 1997–98 is who?
SQL: SELECT "leading_scorer" FROM chester_fc_history WHERE "goals" < 23 AND "league" = 'football league division 3' AND "year" = '1997–98'

Question: Leading Scorer of Ian rush is what lowest # of goals?
SQL: SELECT MIN("goals") FROM chester_fc_history WHERE "leading_scorer" = 'ian rush'

Question: Goals that has a Position of 14th of 24, and a League of football conference has what sum?
SQL: SELECT SUM("goals") FROM chester_fc_history WHERE "position" = '14th of 24' AND "league" = 'football conference'

Question: Position of 7th of 24, and a Goals smaller than 24 is what league?
SQL: SELECT "league" FROM chester_fc_history WHERE "position" = '7th of 24' AND "goals" < 24