CREATE TABLE table_name_89 (role VARCHAR2, teams VARCHAR2)

What role has the team of Troyes AC Grenoble Foot?
SELECT role FROM table_name_89 WHERE teams = "troyes ac grenoble foot"
SELECT "role" FROM "table_name_89" WHERE "teams" = "troyes ac grenoble foot"