Table: amanda_harrison_awards
Columns: year
award
production
role
result

Question: Which award was given in 2012?
SQL: SELECT "award" FROM amanda_harrison_awards WHERE "year" = '2012'

Question: Which award was given for the role of Elphaba in 2009?
SQL: SELECT "award" FROM amanda_harrison_awards WHERE "role" = 'elphaba' AND "year" = '2009'

Question: What was the result for the role of Ellie Greenwich in 2005?
SQL: SELECT "result" FROM amanda_harrison_awards WHERE "role" = 'ellie greenwich' AND "year" = '2005'

Question: Which award was An Officer and a Gentleman nominated for?
SQL: SELECT "award" FROM amanda_harrison_awards WHERE "result" = 'nominated' AND "production" = 'an officer and a gentleman'

Question: During what year was Wicked associated with the Green Room Awards?
SQL: SELECT "year" FROM amanda_harrison_awards WHERE "production" = 'wicked' AND "award" = 'green room awards'