Table: crewe_player
Columns: name
nationality
position
crewe_alexandra_career
appearances
goals

Question: What is the number of goals when the position is DF, the nationality is England, and the Crewe Alexandra career is 1948–1951?
SQL: SELECT COUNT("goals") FROM crewe_player WHERE "position" = 'df' AND "nationality" = 'england' AND "crewe_alexandra_career" = '1948–1951'

Question: What is the position when the Crewe Alexandra career is 1988–1990, with 31 goals?
SQL: SELECT "position" FROM crewe_player WHERE "crewe_alexandra_career" = '1988–1990' AND "goals" = 31

Question: What is the total number of Goals with a nationality of England, and position of DF, and a Crewe Alexandra career is 1958–1962, and less than 170 appearances?
SQL: SELECT COUNT("goals") FROM crewe_player WHERE "nationality" = 'england' AND "position" = 'df' AND "crewe_alexandra_career" = '1958–1962' AND "appearances" < 170