Show all the musical names information.
select name from musical
Which of them has the nominee of "Bob Fosse"?
select name from musical where nominee = "Bob Fosse"
How about the award of 'Tony Award'?
select name from musical where award = 'Tony Award'
What about the distinct nominees of the musicals with the award that is not that award?
select distinct nominee from musical where award != "Tony Award"