human
Schema:
musical (Musical_ID, Name, Year, Award, Category, Nominee, Result)
actor (Actor_ID, Name, Musical_ID, Character, Duration, age)
Please answer with SQL.
assistant
Sure, I understand.
human
What 1986 movie was nominated for a Tony Award for Best Book of a Musical?
assistant
SELECT name FROM musical WHERE year = 1986 AND category = "Best Book of a Musical" AND Result = "Nominated" ;