Table: player_stats_31
Columns: season
team
league
games
goals

Question: What is the league listed that has goals of 10?
SQL: SELECT "league" FROM player_stats_31 WHERE "goals" = '10'

Question: What is the team name that as games of 7?
SQL: SELECT "team" FROM player_stats_31 WHERE "games" = '7'

Question: What season has a Games listed of 10?
SQL: SELECT "season" FROM player_stats_31 WHERE "games" = '10'

Question: What is the league name that has a Games listing of 10?
SQL: SELECT "league" FROM player_stats_31 WHERE "games" = '10'

Question: What is the Season with goals of 6 and BCLA as the league?
SQL: SELECT "season" FROM player_stats_31 WHERE "league" = 'bcla' AND "goals" = '6'

Question: What is the name of the team with a Games listing of 7?
SQL: SELECT "team" FROM player_stats_31 WHERE "games" = '7'