Schema: CREATE TABLE table_name_89 (role VARCHAR, teams VARCHAR)
Question: What role has the team of Troyes AC Grenoble Foot?
SQL: SELECT role FROM table_name_89 WHERE teams = "troyes ac grenoble foot"