Table: barb_stanwyck_films
Columns: year
film
role
leading_man
director

Question: What leading man earlier than 1932 was directed by archie mayo?
SQL: SELECT "leading_man" FROM barb_stanwyck_films WHERE "year" < 1932 AND "director" = 'archie mayo'

Question: What year was the role nan taylor, alias of nan ellis, aka mrs. andrews and directed by William keighley?
SQL: SELECT SUM("year") FROM barb_stanwyck_films WHERE "role" = 'nan taylor, alias of nan ellis, aka mrs. andrews' AND "director" = 'william keighley'

Question: What is the latest year for the role of joan gordon, aka francine la rue?
SQL: SELECT MAX("year") FROM barb_stanwyck_films WHERE "role" = 'joan gordon, aka francine la rue'

Question: What film has a leading man of adolphe menjou in 1939?
SQL: SELECT "film" FROM barb_stanwyck_films WHERE "leading_man" = 'adolphe menjou' AND "year" = 1939

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?
SQL: SELECT "film" FROM barb_stanwyck_films WHERE "director" = 'william a. wellman' AND "year" > 1931 AND "leading_man" = 'george brent' AND "role" = 'joan gordon, aka francine la rue'

Question: What director directed the role of shelby barret wyatt in 1935?
SQL: SELECT "director" FROM barb_stanwyck_films WHERE "year" = 1935 AND "role" = 'shelby barret wyatt'