Table: candide_awards
Columns: year
award
category
nominee
result

Question: What was the result for the best musical revival category?
SQL: SELECT "result" FROM candide_awards WHERE "category" = 'best musical revival'