Table: short_film_award_winners
Columns: rank
film
director_s
producer_s
writer_s
production_company

Question: For which production company did Sam Mccarthy produce?
SQL: SELECT "production_company" FROM short_film_award_winners WHERE "producer_s" = 'sam mccarthy'

Question: Who was the director that worked with Dana Dorian as the writer?
SQL: SELECT "director_s" FROM short_film_award_winners WHERE "writer_s" = 'dana dorian'

Question: Which film, directed by Dana Dorian, was nominated?
SQL: SELECT "film" FROM short_film_award_winners WHERE "rank" = 'nominated' AND "director_s" = 'dana dorian'