user: ### NOW ANSWER:
Question: Who was the director where the role was Fred Ayres?
Columns: ['Date', 'Theatre, Studio, or Network', 'Role', 'Dance Partner', 'Director']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['June 3, 1931', 'New Amsterdam', 'Himself', 'Adele Astaire Tilly Losch', 'Hassard Short']
SQL:

assistant: SELECT "Director" FROM "Table" WHERE "Role" = 'Fred Ayres';