human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Year, Award Ceremony, Category, Nominee, Result
###Question: What was the result for the nomination of Best Revival of a Musical?
gpt
SELECT Result FROM table WHERE Category = best revival of a musical