Table: darren_aronofsky_awards
Columns: year
award
category
title
result

Question: What year was Black Swan up for the Gotham Awards?
SQL: SELECT COUNT("year") FROM darren_aronofsky_awards WHERE "title" = 'black swan' AND "award" = 'gotham awards'

Question: What is the earliest year in which Requiem for a Dream was in the running for Best Director?
SQL: SELECT MIN("year") FROM darren_aronofsky_awards WHERE "title" = 'requiem for a dream' AND "category" = 'best director'