Table: scotland_football_player_stats
Columns: name
scotland_career
caps
goals
average

Question: What is the average cap number in scotland in 1986–1998 leass than 69?
SQL: SELECT COUNT("average") FROM scotland_football_player_stats WHERE "caps" < 69 AND "scotland_career" = '1986–1998'

Question: Which caps was in scotland in 1920–1923?
SQL: SELECT "caps" FROM scotland_football_player_stats WHERE "scotland_career" = '1920–1923'

Question: What is the goal low with caps less than 38 and an average less than 1.083?
SQL: SELECT MIN("goals") FROM scotland_football_player_stats WHERE "caps" < 38 AND "average" < 1.083

Question: What is the goal top with caps of 38 and an average less than 0.579?
SQL: SELECT MAX("goals") FROM scotland_football_player_stats WHERE "caps" = 38 AND "average" < 0.579

Question: What is the low goal for kenny miller with an average smaller than 0.261?
SQL: SELECT MIN("goals") FROM scotland_football_player_stats WHERE "name" = 'kenny miller' AND "average" < 0.261