human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Ranking, Nationality, Name, Years, Total Appearances(league only)
###Question: How many total appearances (league only) have a name of gavin dykes?
gpt
SELECT Total Appearances(league only) FROM table WHERE Name = gavin dykes