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';
human
How many actors appeared in it?
assistant
SELECT COUNT( T1.Name ) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID WHERE t2.year = 1986 AND t2.category = "Best Book of a Musical" AND t2.Result = "Nominated" ;