user: ### NOW ANSWER:
Question: What is the latest year for the role of Joan Gordon, aka Francine La Rue?
Columns: ['Year', 'Film', 'Role', 'Leading Man', 'Director']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1927.0, 'Broadway Nights', 'Fan dancer (uncredited)', '—', 'Joseph C. Boyle']
SQL:

assistant: SELECT MAX("Year") FROM "Table" WHERE "Role" = 'Joan Gordon, aka Francine La Rue';