Table: john_player_league_1970
Columns: player
county
matches
innings
runs
average
highest_score
100s
50s

Question: Which player has a 50 of 2?
SQL: SELECT "player" FROM john_player_league_1970 WHERE "50s" = 2

Question: How many 100 for the player with 3 50s?
SQL: SELECT "100s" FROM john_player_league_1970 WHERE "50s" = 3

Question: What is the average for the player from Lancashire 1 100?
SQL: SELECT "average" FROM john_player_league_1970 WHERE "county" = 'Lancashire' AND "100s" = 1