CREATE TABLE table_79776 ("Ranking" FLOAT, "Nationality" CLOB, "Name" CLOB, "Years" CLOB, "Total Appearances ( league only ) " CLOB)

How many total appearances (league only) have a name of gavin dykes?
SELECT "Total Appearances(league only)" FROM table_79776 WHERE "Name" = 'gavin dykes'
SELECT "Total Appearances(league only)" FROM "table_79776" WHERE "Name" = 'gavin dykes'