Can you list the awards of the musical nominee "Bob Fosse"?
select distinct award from musical where nominee = "Bob Fosse"
Can you list the awards of the musical nominee "Cleavant Derricks"?
select distinct award from musical where nominee = "Cleavant Derricks"
What categories did Cleavant Derricks win for?
select category from musical where nominee = "Cleavant Derricks" and result = "Won"
What categories were Cleavant Derrick nominated for?
select category from musical where nominee = "Cleavant Derricks" and result = "Nominated"
What categories did Bob Fosse win in?
select category from musical where nominee = "Bob Fosse" and result = "Won"