CREATE TABLE table_name_47 (year VARCHAR2, title VARCHAR2, award VARCHAR2)

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