Give me the list of nominees that has been nominated multiple times for musicals
select nominee from musical group by nominee having count ( * ) > 1
And what musicals were they nominated for?
select name from musical group by nominee having count ( * ) > 1
What year(s) were they nominated in?
select year from musical group by nominee having count ( * ) > 1
Who else was also nominated in 1986?
select distinct nominee from musical where year = 1986 and nominee ! = "Bob Fosse"
What musicals were they nominated for?
select name from musical where year = 1986 and nominee = "Cleavant Derricks"
And in what categories were those nominations?
select name, category from musical where year = 1986 and nominee = "Cleavant Derricks"