Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quem é o jogador de Aurillac?
 ###Tabelas: CREATE TABLE qualifying_games (qualifying_games_id AUTO_INCREMENT PRIMARY KEY, Game INT, Date VARCHAR, Batting 1st VARCHAR, Batting 2nd VARCHAR, Result VARCHAR) CREATE TABLE america_rock (america_rock_id AUTO_INCREMENT PRIMARY KEY, Episode title VARCHAR, Subject VARCHAR, Music by VARCHAR, Lyrics by VARCHAR, Performed by VARCHAR, First aired VARCHAR) CREATE TABLE composition_of_the_20th_seanad (composition_of_the_20th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE men's_doubles:_16_10_titles_6_runner-ups (men's_doubles:_16_10_titles_6_runner-ups_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Year INT, Championship VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score in the final VARCHAR) CREATE TABLE [[_|_]] ([[_|_]]_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Position VARCHAR, Date of Birth (Age) VARCHAR, Caps INT, Club/province VARCHAR)  
SELECT Player FROM [[_|_]] WHERE Club/province = aurillac