text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_name_54 (film VARCHAR, role VARCHAR, leading_man VARCHAR, director VARCHAR, year VARCHAR)
  ### Question:
  What film was the director william a. wellman, later than 1931 with a leading man of george brent, and a Role of joan gordon, aka francine la rue?
  ### Answer:
  SELECT film FROM table_name_54 WHERE director = "william a. wellman" AND year > 1931 AND leading_man = "george brent" AND role = "joan gordon, aka francine la rue"