Table: player_stats_9
Columns: player
country
caps
goals
years_active

Question: What were the years active of the player from New Zealand with more than 11 caps?
SQL: SELECT "years_active" FROM player_stats_9 WHERE "caps" > 11 AND "country" = 'new zealand'

Question: How many goals did a player from France have?
SQL: SELECT "goals" FROM player_stats_9 WHERE "country" = 'france'

Question: How many goals did a player active since 2006 have?
SQL: SELECT "goals" FROM player_stats_9 WHERE "years_active" = '2006'