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
Can you list the awards of the musical nominee 'Bob Fosse'?
assistant
SELECT DISTINCT Award FROM musical WHERE Nominee = 'Bob Fosse';
human
Can you list the awards of the musical nominee 'Cleavant Derricks'?
assistant
SELECT DISTINCT Award FROM musical WHERE Nominee = 'Cleavant Derricks';
human
What categories did Cleavant Derricks win for?
assistant
SELECT Category FROM musical WHERE Nominee = 'Cleavant Derricks' AND Result = 'Won';
human
What categories were Cleavant Derrick nominated for?
assistant
SELECT Category FROM musical WHERE Nominee = "Cleavant Derricks" AND Result = "Nominated" ;