Which Award Ceremony has a Result of nominated, and a Category of best revival of a musical?
CREATE TABLE table_name_75 (award_ceremony VARCHAR, result VARCHAR, category VARCHAR)
SELECT award_ceremony FROM table_name_75 WHERE result = "nominated" AND category = "best revival of a musical"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_75 (award_ceremony VARCHAR, result VARCHAR, category VARCHAR) Question: Which Award Ceremony has a Result of nominated, and a Category of best revival of a musical? [/INST] SELECT award_ceremony FROM table_name_75 WHERE result = "nominated" AND category = "best revival of a musical" </s>