Table: gene_tierney_career
Columns: year
title
format_genre
role
staged_by

Question: In what title did he act in 1940?
SQL: SELECT "title" FROM gene_tierney_career WHERE "year" = 1940

Question: What is the title of the work where the role was Molly O'Day?
SQL: SELECT "title" FROM gene_tierney_career WHERE "role" = 'molly o''day'

Question: What is the role in an original play, comedy in 1938?
SQL: SELECT "role" FROM gene_tierney_career WHERE "format_genre" = 'original play, comedy' AND "year" = 1938