Table: dolores_moran_movies
Columns: year
title
role
studio
director

Question: What is the title where the studio was RKO, the role was Dolly, and the year was later than 1943?
SQL: SELECT "title" FROM dolores_moran_movies WHERE "year" > 1943 AND "studio" = 'rko' AND "role" = 'dolly'

Question: Who was the director for To Have and Have Not, earlier than 1945 with WB studio?
SQL: SELECT "director" FROM dolores_moran_movies WHERE "studio" = 'wb' AND "year" < 1945 AND "title" = 'to have and have not'

Question: What year was The Horn Blows at Midnight, directed by Raoul Walsh?
SQL: SELECT AVG("year") FROM dolores_moran_movies WHERE "director" = 'raoul walsh' AND "title" = 'the horn blows at midnight'

Question: What title was directed by Raoul Walsh later than 1945?
SQL: SELECT "title" FROM dolores_moran_movies WHERE "director" = 'raoul walsh' AND "year" > 1945

Question: What was the studio for The Hard Way in 1943?
SQL: SELECT "studio" FROM dolores_moran_movies WHERE "year" = 1943 AND "title" = 'the hard way'