Count how many musicals for each one.
select nominee, count(*) from musical group by nominee
Which nominee has 2 musicals?
select nominee from musical group by nominee having count(*) = 2
Who has been nominated the greatest number of times?
select nominee from musical group by nominee order by count(*) desc limit 1