Who is the player from Aurillac?
CREATE TABLE table_name_49 (player VARCHAR, club_province VARCHAR)
SELECT player FROM table_name_49 WHERE club_province = "aurillac"
### Context: CREATE TABLE table_name_49 (player VARCHAR, club_province VARCHAR) ### Question: Who is the player from Aurillac? ### Answer: SELECT player FROM table_name_49 WHERE club_province = "aurillac"