Rename the director table as d within the query.

Make sure to type director AS d.