Table: player_stats_9
Columns: ranking
nationality
name
years
total_appearances_league_only

Question: How many total appearances (league only) have a name of gavin dykes?
SQL: SELECT "total_appearances_league_only" FROM player_stats_9 WHERE "name" = 'gavin dykes'

Question: What nationality has a ranking less than 7 with tony stenson as the name?
SQL: SELECT "nationality" FROM player_stats_9 WHERE "ranking" < 7 AND "name" = 'tony stenson'